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:
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.
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:
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?
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.