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

[Anonymous]

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.

[mdevaney]

@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."

[Anonymous]

@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. 

[mdevaney]

@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."

[Anonymous]

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!

[mdevaney]

@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."