I need concatenate a value but not if the value already exist

[Johny_Freitas]

how the app work:
i have an app that scan somes QR’s
SO, a row (POS SPT) Scan the QR’s and another row (POS entregues) Concatenate these.

but if some one scan the same QR, my app concatenate it too.

i need a way to not concatenate if the value already exist.

[Steve]

I suggest changing POS entregues to a List type instead of Text, then you could do this:

[POS entregues]
+ IFS(
  NOT(
    IN(
      [POS SPT],
      [POS entregues]
    )
  ),
  LIST([POS SPT])
)

[Johny_Freitas]

Steve:

[POS entregues] + IFS( NOT( IN( [POS SPT], [POS entregues] ) ), LIST([POS SPT]) )

when i change the type to list, it’s tell me that only virtual column can be list type.

So i need to create a virtual colum to get your appformula and set POS entregues to get the virtual colum value?

[Steve · Accepted solution]

Whoops! My mistake. Make it an EnumList type. Keep the column a normal (not virtual) column.