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

Announcements

Welcome to the Power Platform Communities
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / What Power Automate pl...
Power Automate
Answered

What Power Automate plan do I need to list rows present in a table with over 5000 rows in a scheduled flow

(0) ShareShare
ReportReport
Posted on by gbarnholtz

I'm having this problem. For instant/manually triggered flows, the amount of Team members I am allowed to read in is up to 50,000. For scheduled flows, that number maxes out at only 5,000. 

 

The error I'm getting is "Flow save failed with code 'InvalidPaginationPolicy' and message 'The pagination policy of workflow run action 'List_group_members' of type 'OpenApiConnection' at line '1' and column '5047' is not valid. The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '15000'. Maximum: '5000'.'.". 

 

 

It seems that you need a plan for power automate to do this. Which one?

Categories:
General topics
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    v-bofeng-msft Microsoft Employee on at

    HI @gbarnholtz ,

     

    The paginated items limit is '5000 for low , 100000 for all others'.

    vbofengmsft_0-1718326189962.png

    Please check this link:

    Limits of automated, scheduled, and instant flows - Power Automate | Microsoft Learn

    vbofengmsft_1-1718326253914.png

    Best Regards,

    Bof

     

  • Suggested answer
    Ellis Karim Profile Picture
    Ellis Karim 11,816 Super User 2026 Season 1 on at

    @gbarnholtz,

    A reliable workaround seems to be to use a scheduled parent flow to trigger an instant child flow, then return the results back to the parent.

    See Power Automate Scheduled Flows WON’T SAVE if Excel Pagination is over 5,000

    Ellis

     

    Ellis Karim
    Ellis Karim
    elliskarim.com  |  LinkedIn  |  Bluesky
    If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the January Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 124 Super User 2026 Season 1

#2
Ellis Karim Profile Picture

Ellis Karim 52 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 47 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans