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


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

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.