Answered

Getting 256 rows limit from Excel

(0) Share

Report

Posted on by ricardosanchezm

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

Could please you check around what is going on?.

Regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

RezaDorrani 12,143 on at

Like (0)

Report

Hi @ricardosanchezm

check this post

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

Regards,
Reza Dorrani

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

Was this reply helpful? Yes No
ricardosanchezm 86 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Verified answer

RezaDorrani 12,143 on at

Like (0)

Report

Hi @ricardosanchezm

have you turned on pagination in settings?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
ricardosanchezm 86 on at

Like (1)

Report

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,

Was this reply helpful? Yes No
RezaDorrani 12,143 on at

Like (0)

Report

Hi @ricardosanchezm

Great !!!

Was this reply helpful? Yes No