cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vstar19
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        | 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

2 REPLIES 2
eliotcole
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.

takolota
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: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-SharePoint-List-With-Extern...

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,075)