cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
itsmeqp
Level: Powered On

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
Level: Powered On

Re: Concatenating Column Values to String

8 REPLIES 8
itsmeqp
Level: Powered On

Re: Concatenating Column Values to String

danherring
Level: Power Up

Re: Concatenating Column Values to String

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

itsmeqp
Level: Powered On

Re: Concatenating Column Values to String

Antonima
Level: Power Up

Re: Concatenating Column Values to String

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

Charles_Haines
Level: Powered On

Re: Concatenating Column Values to String

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
Level 10

Re: Concatenating Column Values to String

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
Level: Powered On

Re: Concatenating Column Values to String

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? 

DanielaHo
Level: Powered On

Re: Concatenating Column Values to String

Anyone? 

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,329)