Unanswered

How can I bulk update a SharePoint list with specific values in a collection without delegation issues?

(0) Share

Report

Posted on by Community Power Pla...

I have a collection containing changes to a SharePoint list that I want to patch en masse to my list. I am considered delegation is going to be problem.

Here is a sample of the Items list:

ID	Name	Item	Status
1	Bill	Marketing	0
2	Jane	Accounting	1
3	Mark	IT	1

My colChanges collection is as follows:

ID	Name	Item	Status
1	Bill	Marketing	2
3	Mark	IT	2

I want to patch the changes to the Status column to the Items SP list simultaneously. I know I'll need ForAll and Patch, but I cannot figure out how to do it without running into delegation issues.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

mdevaney 29,989 Moderator on at

Like (0)

Report
@Anonymous

Will this work?

ForAll( colChanges, Patch(your_items_list, LookUp(your_items_list ,ID=colChanges[@ID]), {Status: colChanges[@Status]) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@mdevaney, thanks for responding. Unfortunately, no because that creates a delegation warning that hampers the functionality of the patch due to SharePoint not currently supporting certain actions on the native ID column.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Anonymous
If the ID field cannot be delegated then the best way to perform a bulk update might be sending the Collection to MS Flow and having it perform the update.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

I like the way you think. I'll do it that way. Hoping a native Power Apps solution becomes available soon. Thanks for your help!

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@Anonymous

I too would enjoy a native PowerApps solution. I prefer to use as few Flows as possible when building a PowerApp (low-flow LOL) so I am always looking for a workaround.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No