Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Updating several SharePoint list items using Flow

Hello, I have a SharePoint list containing approx. 450 list items such as 


ID    | Name   | Type  | Owner 

1     | Item 1   | A        |

2     | item 2   | C        |


450 | item 450 | ZX    | 




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         |


450 | Item450| ZXJ     | 


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?



Super User
Super User

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.

Super User
Super User

@Vstar19 @eliotcole 


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:

Helpful resources

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,773)