ArrayUnique & ArrayFlatten not working

[Vijay_chen]

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

[kuovonne]

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.

[Vijay_chen]

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