Trying to concatenate values(not repeating) from collection and storing them into text.

[CYJ]

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

[eka24]

Tested with the following:

Collect( Test4, { Company:Split(Label1.Text,"@").Result});

ClearCollect(Test5,Ungroup(Test4,"Company"))

Then Concat in the TextBox:

Concat(Test5,Result &",")

------------

If you like this post, give a Thumbs up. Where it solved your request,

Mark it as a Solution to enable other users find it.

[Rahber]

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

[CYJ]

Hi @eka24 ,

Why is there ice cream flavor? 🤣

[CYJ]

Hi @Rahber ,

Tested your method but got the following red lines underneath the result.

[eka24 · Accepted 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:

Collect( Test4, { Company:Split(Label1.Text,"@").Result});

ClearCollect(Test5,Ungroup(Test4,"Company"))

Then Concat in the TextBox:

Concat(Test5,Result &",")

------------

If you like this post, give a Thumbs up. Where it solved your request,

Mark it as a Solution to enable other users find it.

[CYJ]

@eka24 ,

Thanks man. It worked

[Rahber]

Its because your Records are inside a record.

Since @eka24 has already given you the solution which is similar to mine the only difference is this code will not return the recurring values.

This is on my button
Collect(Test4, {company: Split(TextInput7.Text,",")} );
ClearCollect(Test5,Ungroup(Test4,"company"));

This is my new text field
Concat(Distinct(Test5,Result),Result & ";")

[CYJ]

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"