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
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.
Solved! Go to Solution.
And shortly after I found a solution.
https://powerusers.microsoft.com/t5/Connecting-to-Data/convert-table-column-to-string/td-p/87539
And shortly after I found a solution.
https://powerusers.microsoft.com/t5/Connecting-to-Data/convert-table-column-to-string/td-p/87539
I can't access this link! How did you do it!!??
Have a look at this link: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concatenate
Concat([your table], [your column] & ";")
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?
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
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?
Anyone?
Have you tried to use ProductName.Value?
Set(VarTest, Concat(Collection, ProductName.Value))
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
208 | |
70 | |
49 | |
48 | |
20 |
User | Count |
---|---|
255 | |
125 | |
84 | |
77 | |
72 |