Unanswered

SharePoint Patch ForEach getting Duplicate errors on Multi-Update

(0) Share

Report

Posted on by SPA

I have a collection that stores multiple records for update. I use a ForEach / Patch combo tied to the OnSelect property of a Button, and it works... kinda.

The list I'm updating has a unique-required field index field (RMT_EID), and some other fields (one left as an example). When I try to update multiple records, I get an error for adding a duplicate record, for all of the records EXCEPT the last. The LAST changed record DOES work. It's not related to the data, as it is the same outcome regardless of which record is last.

The intent is to update the 'R1 Tower Lead EID' field for existing records, not to add anything. I added the 'RMT_EID' field to the Patch to fix an issue where the records were not updating at all... and it fixed that, but seemed to break something else. Thoughts?

Code is:

ForAll(

RenameColumns(Filter(collMultiUpdateChanged, IsChanged),"ID","GalleryID"),

Patch(listName, LookUp(listName,ID=GalleryID),

{ 'RMT_EID': Resource_1.Text,

'R1 Tower Lead EID': TowerLead_1.Selected.Value }

)

By the way @ShaneYoung has an excellent video on updating multiple records (https://www.youtube.com/watch?v=0xZ4fMJbLvk) and I highly recommend you check him out!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SPA :
The formula looks fine, could you tell me what difficulties you are currently experiencing?
In additon,If you want to batch update some records, you can also use UpdateIf.

UpdateIf( listName, ID in Filter(collMultiUpdateChanged, IsChanged).ID, { 'RMT_EID': Resource_1.Text,'R1 Tower Lead EID': TowerLead_1.Selected.Value } )

Note: These functions cannot be delegated (including ForALL), if the number of records in your data source exceeds 500, it may cause some problems
Best Regards,
Bof

Was this reply helpful? Yes No
SPA 81 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft thanks for the help... the problem is as stated in the original post: When I try to update multiple records, I get an error for adding a duplicate record, for all of the records EXCEPT the last. The LAST changed record DOES work. I need to understand why Power Apps thinks I'm trying to ADD records (hence the error for adding records with an existing value in a "unique" SharePoint list column)

View of data with requested changes highlighted (in last Yes/No column) Rows 1,3,5:

Error message when I run:
Results after I run. Note that the first 2 are not updated, but the last one is updated:

I use a collection to hold the records I need to update, so Delegation is not an issue... I use filters to restrict the user to ~100 updates at a time.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SPA :
I guess the reason is that in some cycles, LookUp(listName,ID=GalleryID) cannot find the corresponding record.
Maybe you could try:

ForAll( RenameColumns(Filter(collMultiUpdateChanged, IsChanged),"ID","GalleryID"), If(!IsBlank(LookUp(listName,ID=GalleryID)), Patch(listName, LookUp(listName,ID=GalleryID), { 'RMT_EID': Resource_1.Text,'R1 Tower Lead EID': TowerLead_1.Selected.Value } ) ) )

Best Regards,
Bof

Was this reply helpful? Yes No
SPA 81 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft, I know the records are in there to match, as they are used to populate the gallery control itself... plus the error describes a "duplication" error for values in a unique column, not a "not found" error.

Was this reply helpful? Yes No