Retrieve More Than The Default Number Of Rows Of Data From Excel Using Power Automate

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.
  1. 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,
 
Retrieve More Than Default Number Of Rows Of Data From Excel Using Power Automate
 
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.
 
Retrieve More Than Default Number Of Rows Of Data From Excel Using Power Automate
 
Step 3
 
Empty Flow will be opened.
 
Retrieve More Than Default Number Of Rows Of Data From Excel Using Power Automate
 

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.
 
Retrieve More Than Default Number Of Rows Of Data From Excel Using Power Automate
 
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.
 
Retrieve More Than Default Number Of Rows Of Data From Excel Using Power Automate
 
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.