cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

256 rows limit

I am trying to import up to 50,000 lines from a table in excel into a SharePoint list.

 

I have it working but it is currently capped at 256 rows. I have been doing some searchign on here and have found that other people have had the same issue but they have solutions based on using the 'Get Rows' action, however i dont seem to have this as a possible action?

 

I am using 

Capture.PNG

 

Capture.PNG

Capture.PNG#

 

Everything runs ok but i just hit the limit of 256, without using the 'Get Rows' action which i dont seem to have i cant find a way around it?

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please click Settings, then enable Pagination to increase the limit to the expected value.

Image reference:

10.PNG11.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

11 REPLIES 11
v-bacao-msft
Community Support
Community Support

Hi @Anonymous ,

 

Please click Settings, then enable Pagination to increase the limit to the expected value.

Image reference:

10.PNG11.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Thanks for this,

 

I gave it a try and it has worked to an extent, there is currently a limit of 5000 so i can not go any higher.

 

I will changed it to 5000 and 5000 worked. Will suggest to Microsoft they increase the limit!

Anonymous
Not applicable

So it seems to be able to read 5000 rows but it can only write 2048 rows into the SharePoint list? Any ideas?

Hi @Anonymous ,

 

Thanks for your reply.

Yes, it seems that this is the current limit. There is no additional setting for Create item action to increase the number of writes.

Please consider submitting your suggestion in Idea forum to increase the maximum number of writes:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Yes i have done thankyou 🙂

i am failing in apply to each . I have 1276 rows. I only has one action variable that adds all the valuves and gives a sum.

Anonymous
Not applicable

Can you share us a screenshot of your flow below?

 

like i am able to read all rows but in apply to each is failing after 10 min but if i run one branch then its running perfectly fine.

 

Capture.PNG

Gents, do you have any updates on the row limitation?  Has it been increased beyond 5000?

Nope, it has not increased yet.

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.

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,561)