Answered

Excel (Business) - List rows present in a table: 256 row limit, any way around it?

(12) Share

Report

Posted on by ChadVKealey

1,393

I know with some of the other Excel "get rows" or "get tables" actions, there is a "Maximum Get Count" property that can be increased to 2048. However, the "List rows present in a table (Preview)" action does not have that property. There is a "Top Count" property, which I've set to 2048 (see below), but the Flow I'm using is still only getting 256 rows from the file. In this file, there are typically going to be 1,000 or fewer rows, so this would be an ideal solution if I could get around the 256-row limit. Any help would be appreciated.

I have the same question (0)

All responses (25)

Answers (1)

webbrewer 336 on at

Like (0)

Report

Excel (Business) - List rows present in a table: 256 row limit, any way around it?

This is total nonsense from Msft - when I turn on pagination in "list rows..." and set a higher limit it doesn't get saved. An app touted as "enterprise ready" should be able to handle 1000's of rows without the need to triage why it fails.

Was this reply helpful? Yes No
powerpritish 15 on at

Like (0)

Report

Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

@KrishnaV Paul Muran shows a way to upload batch entries to sharepoint which willy significantly reduce time.
https://www.youtube.com/watch?v=2dV7fI4GUYU&t=135s&ab_channel=PaulMurana
https://www.tachytelic.net/2021/06/power-automate-flow-batch-create-sharepoint-list-items/

Was this reply helpful? Yes No
ChadVKealey 1,393 on at

Like (0)

Report

Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

Probably not use Power Automate. There are more efficient ways to process that amount of data. Which you use depends on what you want/need to do with it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

What if we have more than 10,000 records in excel. What we have to do?

Was this reply helpful? Yes No
antc 34 on at

Like (0)

Report

Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

Speed it up on your "Apply to each Loop"

Was this reply helpful? Yes No
Pavel48n0sh 87 on at

Like (0)

Report

Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

Hi! My task is much more difficult. More than 16 thousand rows to process.

It's been 1 hour and I'm still waiting...
I think it should be possible to break it down into sub-cycles in order to go through 500 rows first and get the result, then another 500, and so on.

Was this reply helpful? Yes No
km3000 9 on at

Like (0)

Report

Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

Worked perfectly. Thank you!

Was this reply helpful? Yes No
Deltodeus 80 on at

Like (0)

Report

Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

how long it took to process 3500 rows in excel?

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (1)

Report

Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

Hi @Anonymous,

Follow this article you will come to know more insight on Flow and its limitations:
https://docs.microsoft.com/en-us/power-automate/limits-and-config

Was this reply helpful? Yes No
Community Power Pla... on at

Like (6)

Report

Re: Excel (Business) - List rows present in a table: 256 row limit, any way around it?

Is there a way Microsoft can make limits like this more easily KNOWN? These things are not obvious. The Flow runs happily through 256 items and there's no warning -- nothing. We only found out after a significant business impact was detected.

Was this reply helpful? Yes No