You’re offline. This is a read only version of the page.
354
Hello, I have a SharePoint list containing approx. 450 list items such as
ID | Name | Type | Owner
1 | Item 1 | A | user@domain.com
2 | item 2 | C | userb@doamin.com
....
450 | item 450 | ZX | userZ@domain.com
etc..
I also have an excel file which has the latest data e.g.
ID | Item | Type | Owner
1 | Item 1 | F | UserG@domainc
2 | Item2A| H | UserH@doamin.com
..
450 | Item450| ZXJ | UserABC@domain.com
I need to update this sharepoint with the new values in the Excel.
I created a Flow which has an Apply to each e.g.
Apply to Each 'SharePoint ID;
Apply to Each 'Excel ID'
If SharePoint ID = Excel ID
Then Update SharePoint list item
The problem with doing this is that is taking forever to run. I presume becuase the apply to each is looping through 450 items to find a match.
Is there a more optimal way to update several list items where their ID matches a value in an Excel table?
Thanks
Definitely use Eliot’s answer if you are a beginner.
Then if you become more proficient & need something more efficient, you can check this batch update template: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-SharePoint-List-With-External-Data/td-p/1365410
I have entirely misread your problem, sorry.
Just run actions to get both sets of data, then run an Apply to each on the SharePoint results.
Inside that, use a Filter action to filter the Excel results to the ID of the current SharePoint item, and update that.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
