Add column to collection

(0) Share

Report

Posted on by Deeply

Here is what I currently have, collecting only one row of a Sharepoint list.

Collect(SRItemsCollection,Filter('Supply Request Items',ID=ThisItem.ID))

I would like to add a column "Action" to that collection and assign it a value. When I put an AddColumns in that statement it collects all rows from the Sharepoint list.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Use the addColumn() directly on the data source inside the Collect statement. That will add the column and then filter it down to one record.

Collect(SRItemsCollection, AddColumns( TempCol, "ColumnToAdd", Filter('Supply Request Items',ID=ThisItem.ID) ))

Was this reply helpful? Yes No
Deeply 25 on at

Like
a
(0)

Report
Copy link

Link copied!

I used the name of the Sharepoint List for TempCol, is that correct? When I do it still collects all items from the Sharepoint list.

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

No, that is a temporary collection that will hold the filtered results from the sharepoint list (I assume its 'Supply Request Items').

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@Deeply,
Based on the issue that you mentioned, do you want to collect a certain row from your SP list and add a column "Action" to be assigned a value?
Could you please share a bit more about the scenario, do you only want to collect a row rather than all rows from your SP list?
I want to explain to you that AddColumns() function could only add columns to a collection with the Collect function. You can't modify the columns of a data source by using these functions. You must modify the data at its source.
I have a test on my side, please take a try as below.
Collect( FinalCol, AddColumns( Collect( SRItemsCollection, Filter( 'Supply Request Items', ID = ThisItem.ID ) ), "Action", "Value" ) )
Regards,
Qi

Was this reply helpful? Yes No