web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : n+98QMOyGOMPtSNfWpi+95
Power Automate - Using Flows
Answered

How to get more than 256 rows from excel using Pagination in each Iteration

Like (0) ShareShare
ReportReport
Posted on 15 Jun 2020 12:09:35 by

Hi Mates,

It seems like limitation on getting rows from Excel, i can not get more than 256 rows, 

yes i tried to set 1000 at Maximum Get Count but still i can get only 256 items from excel, by any chance can we get/set with other options ..?

1. By any chance can we get 1000 or 500 at a time with help of Pagination option ...? where each time it can retrieve specified or 256 items in each loop, but it has to loop all the items and update.

yes i have googled but no luck.

Your help would be really appreciated.

 

  • Verified answer
    v-litu-msft Profile Picture
    on 16 Jun 2020 at 10:04:57
    Re: How to get more than 256 rows from excel using Pagination in each Iteration

    Hi @Anonymous,

     

    "Flow run timed out. Please try again" is temporarily alert, if you negative to Flow details then click Flow runs, it will disappear.

    There is no time limit when the Apply to each action runs, I tested on my side to insert 2400 rows into an Excel table and successful.

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • MJain Profile Picture
    2,450 on 15 Jun 2020 at 13:53:04
    Re: How to get more than 256 rows from excel using Pagination in each Iteration

    Hi @Anonymous ,

     

    Can you please share your flow screenshot. In Apply to Each you can set the concurrency to perform operations much faster. 

     

    Thanks

  • Community Power Platform Member Profile Picture
    on 15 Jun 2020 at 13:36:05
    Re: How to get more than 256 rows from excel using Pagination in each Iteration

    Hi On top of that i turned on Pagination, updated with item threshold  5000,

    from excel no issue looping items,

    but during writing/inserting it throws error like "Flow run timed out. Please try again" at 1060 item means its updated till 1059 items around.

    How can get rid out of this time out  issue during inserting.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete