cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gochix
Resolver I
Resolver I

Updating a sharepoint list ( only 256 rows updated)

Good evening everyone,

 

I have a bit of a struggle here.

Trying to make a update flow that i will have to use once a day. Did everything correct but my list got updated only by 256 rows.

I have around 6000 rows that has to be updated.

 

Using excel table located in sharepoint as source.

And updating sharepoint list as destination.

 

All i really needed by this flow to update stock quantities so i had to update this by flow.

Any suggestions how to increase number of rows updated?

 

Gochix_0-1632422960481.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

@Gochix 

By default, Excel will only return 256 rows.  To change the default, go to settings for the action, turn on pagination and set the threshold to a higher number.  One issue that you have is that Excel can retrieve a maximum of 5000 rows unless you have a premium license of some type.  The license that comes with M365 will permit a max of 5000.  In addition, an Apply to Each action is limited to 5000 loops unless you have a premium license.

image.png

 

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

2 REPLIES 2
ScottShearer
Super User
Super User

@Gochix 

By default, Excel will only return 256 rows.  To change the default, go to settings for the action, turn on pagination and set the threshold to a higher number.  One issue that you have is that Excel can retrieve a maximum of 5000 rows unless you have a premium license of some type.  The license that comes with M365 will permit a max of 5000.  In addition, an Apply to Each action is limited to 5000 loops unless you have a premium license.

image.png

 

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Thanks for explaining this. I went with ForAll Patch function instead. Average 7 minutes update but it's just once a day so no big deal.

Thanks again.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Top Solution Authors
Users online (2,112)