Hello, I have a SharePoint list containing approx. 450 list items such as
ID | Name | Type | Owner
1 | Item 1 | A | email@example.com
2 | item 2 | C | firstname.lastname@example.org
450 | item 450 | ZX | userZ@domain.com
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?
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.
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-Extern...
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.