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.
Hi @ ChadVKealey,
The action "List rows present in a table" of Excel (Business) connector have the 256 rows limit in microsoft flow currently.
If you would like the limit of action "List rows present in a table" of Excel (Business) connector would be 2048 rows,
I afraid that there is no way to achieve your needs in Microsoft Flow currently.
If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
What happened to the "Get Rows" option? It worked really well, now I don't see it anymore. We only see "List rows present in a table"
You can get more rows returned by setting a higher value for the pagination settings.
The pagination setting works. I tested it with 500. However, the problem is the run-time increases quite significantly if I go above 1000.
Speakers, submit your sessions now! Call for speakers ends Feb. 10!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!