Removing duplicates from lookup fields?

[Y_S]

Is there a way to set up a lookup field without duplicates?

[Mohamed_Swella1]

Hi @Y_S

Instead of Lookup use Rollup and choose ArrayUnique() , this should remove the duplicates

[Y_S]

Hmm what should I put in the formula box?

[Mohamed_Swella1]

Just like that it should work

[Y_S]

Turns out i needed to do like this for it to work

[Mohamed_Swella1]

Yes, you shouldn’t have removed “values” from inside the bracket, I didn’t notice it in the first screenshot :slightly_smiling_face: