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
