cancel
Showing results for 
Search instead for 
Did you mean: 
rampprakash

How to Retrieve More than 256 Rows from Excel using Microsoft Flow

Implementation Steps:

 

1. Create an Excel or Upload the Existing Excel in OneDrive.

 

2. Open the Excel and Check How Many Rows Available. in my case i have 373 Rows Available

 

rampprakash_0-1650869401774.png

 

3. I Uploaded it in OneDrive

 

rampprakash_1-1650869425619.png

 

4. Once Done ---> Navigate to https://flow.microsoft.com

 

5. Click Instant Cloud Flow and Select PowerAutomate and Input Name for the Flow

 

rampprakash_2-1650869494356.png

 

6. Once Clicked On Create --> Select Excel Online (Business) --> Then Choose List Rows Present in Table

 

rampprakash_3-1650869629504.png

 

7. Then Select the location Where the Excel is Available

 

rampprakash_4-1650869741699.png

 

8. Now for Testing Purpose i will Add a Apply For Each to Check How Many Rows its Retrieving.

 

rampprakash_5-1650870506453.png

9. Now We are done --> Click Test --> And Expand Apply to Each 

 

rampprakash_6-1650870708019.png

 

10. Now you can see only 256 Record Retrieved

 

11. Let's See how we can change this

 

12. Click On Three Dots in Excel (List Rows Present in the Table) and select Settings

 

rampprakash_7-1650870804833.png

 

13. Turn On Pagination and Select Threshold Value to 1000(it Depends) and Click DONE

 

rampprakash_8-1650870859381.png

 

 15. Now --> Save the Workflow and Test Again

 

16.  Now you can see all the Rows from Excel.

 

rampprakash_9-1650870963609.png

 

That's it 🙂