Concatenating Column Values to String

[itsmeqp]

I am looking for a way to concatenation/join the values of a column from a table to generate a single string of text

Say I had a collection with 3 values in column Result:

Result

• dog
• cat
• bird

I would like to concatenate those values and using semi-colon as a delimiter to create a text value of dog;cat;bird;

I tried using Concat and ForAll but can't seem to find a way to make it work.

[itsmeqp · Accepted solution]

And shortly after I found a solution.

https://powerusers.microsoft.com/t5/Connecting-to-Data/convert-table-column-to-string/td-p/87539

[Anonymous]

I can't access this link! How did you do it!!??

[itsmeqp]

Have a look at this link: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concatenate

[Antonima]

Concat([your table], [your column] & ";")

[Charles_Haines]

How do I do this if I don't have any columns?
I have a string "1,2,3,4,5"

I used split to get it into a collection to display in a lisbox. 
Set(itemNumbers, TrimEnds( Split( gallery.Selected.ItemNumbers, ",") ))
I later want to get all the selected items back into a new flat string. Ex: "1,2,5"

How can I do this?

[K-A-R-L]

You can try to save your selected Items as a Collection and assisgn a Column Name.

To check, you can add a Label and a Button

then Use this on OnSelect Property of the button (e.g Save Button):

Set(CollectedItems, Concat([your table], [your column] & ","))

On the Label set the Text Property to:

CollectedItems

[DanielaHo]

Hi, 

I am trying to do something similar, only my collection includes one or more objects, as the underlying data source is a choice column. For this reason, the proposed code is not working for me:

Set(VarTest, Concat(Collection, ProductName)

The error sais "Invalid argument type (Table). Expecting Text value instead"

How can I generate a string from the content/objects in this collection? 

[DanielaHo]

Anyone? 

[arevsun1]

Have you tried to use ProductName.Value?

Set(VarTest, Concat(Collection, ProductName.Value))