In this article, I will provide information on how to retrieve more than the default number of rows (256) of data from an Excel using Power Automate.
Below are the components used in this document.
- Power Automate
Introduction
Usually Power Automate provides a way for us to retrieve data from Excel. But the max limit of rows which we can retrieve is limited by default at 256. In order to increase this limit and retrieve more rows we can enable the pagination and then retrieve the next batch in Power Automate. Below is the step by step way to increase the limit and retrieve more than 256 rows of data.
Open Power Automate and create a new Flow
NOTE
In case you already have a Power Automate created, you can ignore this step.
Step 1
Browse to
here and provide your Office 365 account details to login,
Step 2
Select either “Templates” to start your Flow or you can search for the specific template. For my example I am selecting “Templates” from the left navigation highlighted with yellow in the below image and then selecting Power Apps button, as a trigger point for my Flow is a button click from Power Apps. You can select the template based on your requirements.
Step 3
Empty Flow will be opened.
Power Automate to increase the limit of rows
Step 1
Name your Flow with an appropriate meaning. Add a new Step “List rows present in a table”. Then go to the “Settings” of the action as shown in the below screen shot.
Step 2
Now we will set the paging and then mention the limit to 5000 and finally click on “Done”. You can decide the count (5000) as per your requirements.
Step 3
Save your flow and test it, we should see more than 256 rows of data have been retrieved from Excel.
That is it. I hope you have learned something new from this article and will utilize this in your work.