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
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

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.

Users online (4,670)