Concatenating Column Values to String

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Verified answer

itsmeqp 93 on at

Like
a
(1)

Report
Copy link

Link copied!

And shortly after I found a solution.

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(8)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
itsmeqp 93 on at

Like
a
(2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Antonima Microsoft Employee on at

Like
a
(10)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
K-A-R-L 715 on at

Like
a
(3)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
DanielaHo 241 on at

Like
a
(1)

Report
Copy link

Link copied!
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?

Was this reply helpful? Yes No
DanielaHo 241 on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Have you tried to use ProductName.Value?
Set(VarTest, Concat(Collection, ProductName.Value))

Was this reply helpful? Yes No
VickyPower23 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this,

Concat(FirstN(CollectionTableWhichHasValues, 100),ThisRecord.Value&",")

Was this reply helpful? Yes No