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
Dual Super User
Dual Super User

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm 

 

have you turned on pagination in settings?

View solution in original post

6 REPLIES 6
Dual Super User
Dual Super User

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,

Dual Super User
Dual Super User

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm 

 

have you turned on pagination in settings?

View solution in original post

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,

Dual Super User
Dual Super User

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm 

 

Great !!!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 229 members 6,014 guests
Please welcome our newest community members: