Hello everyone, i have text value which is i split them before inserting into collection. After splitting them, i am trying to concatenate them and stored them into a text without repeating the same value
My text value:
My button Function:
Inside the collection,
I am trying to concatenate the values without repeating them and storing them into a text but i got the following error
Solved! Go to Solution.
😀😀Sorry about that. Those are column and table names i use for my test. I have edited the post.
Tested with the following:
So expand your collection to:
Revise it to:
Tested with the following:
As easy way could be.
Concat(Distinct(CollectionName,ColoumnName),Result & ";")
Please accept it as a solution if it resolved your problem or up vote if it helped you in anyway!
Regards,
Rahber
😀😀Sorry about that. Those are column and table names i use for my test. I have edited the post.
Tested with the following:
So expand your collection to:
Hello @eka24 ,
Do you have any idea on how to not repeat the same value in the text? For example, in the collection, i have three values : "Company1", "Company2", "Company1"? In the text, i would like to have "Company1,Company2"