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

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (7,516)