Answered

How to update multiple records from a collection into one SharePoint list column

(0) Share

Report

Posted on by cgarude

I have multiple rows in a collection called outputTable. I need to update all rows from this collection into a SINGLE column in a SharePoint list called MyList. It seems to be updating only the last row. DataCardValue1 is the list's ID column. DataCardValue16 is the Response column (multi-line text) in the SharePoint list. Not sure what I am missing.

// Clear the table and the selected (chosen) rows
Clear(outputTable);

Collect(
 outputTable,
 Filter(
 Gallery2.AllItems,
 IsChosen
 )
);

// Loop thru the selected (chosen) rows, update the SharePoint list's response column with the file names
ForAll(
 outputTable,
 Patch(
 'MyList',
 LookUp(
 'MyList',
 ID = (Value(DataCardValue11.Text))
 ),
 {
 Response: DataCardValue16.HtmlText & "<br/>" & outputTable[@Name] & "<br/>"
 }
 )
)

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@cgarude

Please consider changing your Formula to the following:

Patch('MyList', ForAll( Filter(Gallery2.AllItems, IsChosen) As _item, { ID = Value(_item.DataCardValue11.Text), Response: _item.DataCardValue16.HtmlText & "<br/>" & _item.Name & "<br/>" } ) )

There is no need for the collection as your Gallery already is a collection/table and you can directly retrieve the values from it.

I hope this is helpful for you.

EDIT: Left out a comma in the formula...it's corrected above.
C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, i think it's because DataCardValue11.Text is one value that doesn't change, it's only updating one record where the ID = DataCardValue11.Text im not sure what DataCardValue11.Text brings to the formula? can you not update all record that are in your collection regardless of DataCardValue11.Text?

ForAll(outputTable,Patch('MyList',ID = ID,{Response: DataCardValue16.HtmlText & "<br/>" & outputTable[@Name] & "<br/>"}))