cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
itsmeqp
Advocate III
Advocate III

Concatenating Column Values to String

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.

1 ACCEPTED SOLUTION

Accepted Solutions
itsmeqp
Advocate III
Advocate III
9 REPLIES 9
itsmeqp
Advocate III
Advocate III

Anonymous
Not applicable

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

Antonima
Microsoft
Microsoft

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"

Capture.PNG

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

Anyone? 

Anonymous
Not applicable

Have you tried to use ProductName.Value?

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

 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,256)