Concat column values in a list, where an ID column equals a certain value - SharePoint List

(0) Share

Report

Posted on by fnanfne

260

Hey Power People!

I want to combine all the values from a column in a SharePoint List, where another ID column equals a certain value. Below is a depiction which may offer better clarity on what I want to achieve.

Concat Column Values.png

The result is in the rectangle on the right. It contains all the values of column C, where column B = 1.

So far, I've been playing around with trying to create a collection, and then filtering that collection but not having any success. Any ideas appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @fnanfne ,

This would give you a Table with those values - what do you mean by "combine" ?

Filter( SPListName, ID_column = 1 ).database_name

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
fnanfne 260 on at

Like (0)

Report
Hi @WarrenBelz thanks as always for the reply!

I have a SP list called "Servers List" containing information on many servers. Of the dozens of columns in this list, the ones of importance are ID_column and database_name.

From PowerApps, I simply want to combine or concat all the related values in the database_name column (related via the ID_column) into a single multiline Text box. This should allow a database engineer to simply copy this single text field for scripting related purposes. As opposed to opening each related record, and copying the info from each.

The approach I attempted was to create a collection of all the related servers, which works as well as the filter function but I'm thinking creating a collection is overkill, as the Filter function you supplied does the job just as well.

Here was my Collection attempt
ClearCollect( colPAscript, 'Servers List', {ID_column: ThisItem.ID} )

This does indeed create a table with all the related records, but I want to combine all the Text values of the server_names column in the table, into a single multiline text box.

So as per the pic in my original post, I want to combine all the values in the database_name column into a single multiline text box, IF the ID_column is the same.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report
@fnanfne ,

That should be if you want commas between them

Concat( Filter( SPListName, ID_column = 1 ), database_name, ", " )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
fnanfne 260 on at

Like (0)

Report

Hey @WarrenBelz

Brilliant thanks!

Can't believe I forgot the concat function! I even eluded to it in my original question lol, thanks for prodding me over the line WarrenBeltz, that's done it!

Was this reply helpful? Yes No