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

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
sss
Microsoft
Microsoft

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

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

Users online (1,658)