256 rows limit getting rows from excel. I am not able to get more than 256 rows from excel located on ftp in flow. I have 400 rows in excel. It only gives me 256 rows.
Solved! Go to Solution.
I just crosschecked from my end and I was able to retrieve more than 256 by providing the appropriate value in the "Maximum Get Count" field. Sending your flow information helps us in debugging the issue specific to your flow.
As shown in the previous posts "Maximum Get Count" filed will restrict the number of rows returned by the GetRows operation.
Provide a value in "Maximum Get Count" filed - to set the max rows to be returned.
E.g: 400 - as shown in the sceenshot.
Once the flow gets a run then we should see 400 entries in the output - as shown in the below screenshot.
Try following above two steps - and let me know where exactly are you facing the issue?
No. GetRows is the only operation to retrieve the rows from an Excel file.
Could you please list down the steps that you are following? and followed by expected and actual output.
I have viewed the following article:
Same issue occurs. There is no way to upload an Excel file with 450 rows or more.
Again, is this a limitation? If it is, when is it going to be fixed?
Is there precise instructions on how this should work?
If I select on "Excel - Get rows" or "Excel - Insert row" the same issue occurs. Any ideas?
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.