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
Memorable Member
Memorable Member

@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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,027)