cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ricardosanchezm
Level: Powered On

Getting 256 rows limit from Excel

Hi folks,

 

I have an excel file with 524 records. When getting the records to insert in an sql database I'm just getting 256 limit. I have set the top count to 500, 524, 600 without success. Here is my flow configuration

flow1.png

 

flowrun.png

Could please you check around what is going on?.

 

Regards, 

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Level 10

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm 

 

have you turned on pagination in settings?

6 REPLIES 6
RezaDorrani
Level 10

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm 

 

check this post

 

https://powerusers.microsoft.com/t5/General-Discussion/256-rows-limit-getting-rows-from-excel/td-p/2...

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

ricardosanchezm
Level: Powered On

Re: Getting 256 rows limit from Excel

Hi @RezaDorrani ,

 

I have seen this post before, I have set the top count as it is described in it but the solution is not working.

 

Regards,

RezaDorrani
Level 10

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm 

 

have you turned on pagination in settings?

Super User
Super User

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm 

Depending on your needs, you can use the Static Data connector to bring in up to 15000 records from an Excel file in a few seconds.  The resulting table will be read only though.

ricardosanchezm
Level: Powered On

Re: Getting 256 rows limit from Excel

Hi @RezaDorrani ,

 

That's it this option was off in the settings. I thought it was enought to set the top count value and didn't imagine this option existed. Now I can get the 524 as expected.

 

Thanks!

 

Regards,

RezaDorrani
Level 10

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm 

 

Great !!!

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 182 members 5,333 guests
Please welcome our newest community members: