cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Auto update sharepoint list 2000 items with flow

Hi all

Is it possible to update the SharePoint list quickly when the 2000 rows excel is updated in "onedrive"?

I have a SharePoint list with 2000 items and continues to update from Excel. I want to update empty fields by using email addresses on that list.

I created a flow this.

flow1.jpgflow2.jpg
this flow took so long,  almost 6 hours. and it created 38000 flow runs in 6 hours.  SharePoint list includes 1060 rows.

 
I don't understand  why it took so long 
 
 
I created the same flow to manage this manually. at this time this flow worked for 100  rows.  and it took 11-15 minutes.
flow3.jpg

best  regards

Sinan 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: Auto update sharepoint list 2000 items with flow

Since you are using the trigger 'when a item is created or modified', If any update made on each Item, it will go through all processes.

From your description, your request is focus on updating empty fields.

 

My suggestion is adding conditions to reduce the action performed after 'Get Item'

 

If (Line manager, Office location == null/empty):

then {go to the next step}

else{finish}

View solution in original post

1 REPLY 1
Microsoft
Microsoft

Re: Auto update sharepoint list 2000 items with flow

Since you are using the trigger 'when a item is created or modified', If any update made on each Item, it will go through all processes.

From your description, your request is focus on updating empty fields.

 

My suggestion is adding conditions to reduce the action performed after 'Get Item'

 

If (Line manager, Office location == null/empty):

then {go to the next step}

else{finish}

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (7,940)