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