How do I use the ARRAYUNIQUE() for this two-line string

Topic Labels: Formulas
920 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I want to get the unique value of the {Photos IDs} column, but ARRAYUNIQUE() doesn’t work, presumably because it has a newline symbol in it. What should I do

2 Replies 2

ARRAYUNIQUE() only works on arrays, such as in rollup fields. It does not work on lists that are really text strings. Your formula field is probably producing a text string. How are you generating the list initially? If there is a rollup earlier in the process, you can try putting ARRAYUNIQUE() there.

If the values come from a long text field, you can use a script to split the text string into a list and make the list unique.

I can’t, because the value of the Photos IDs column is the ID of the attachment in the automatically captured attachment column