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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Which licesne inside P...
Power Automate
Unanswered

Which licesne inside Power automate allow the service account to run more than 5000 items inside Apply to each

(0) ShareShare
ReportReport
Posted on by 3,514

currently our service account has this free license for power automate, and hence inside any Apply to each we can not process more than 5,000 items:-

 

 

accoutns.png

 

also here are the available license offered inside our tenant:-

 

lic2.pnglic1.png

 

so what is the minimum license needed to be able to handle more than 5,000 items inside Apply to each ?

Categories:
  • Ellis Karim Profile Picture
    12,377 Super User 2026 Season 2 on at

    Please see: Solutions to the SharePoint 5000 item limit using Power Automate by @Paulie78 

    "If you need to get more than 5000 items from a SharePoint list, there are a number of different approaches. I’ve written up three different ways to solve the problem, which return exactly the same result, but have very different execution times...

    My requirement is to return 17,000 SharePoint list items to a PowerApp. I used Power Automate to get the data but found the standard “Get Items” action to be too slow. A good user experience is essential for application acceptance.

     

    Ellis

     

  • johnjohn123 Profile Picture
    3,514 on at

    @ekarim2020  thanks for the reply.. but this did not answer my question about the licesne.. also in my case i am getting around 6000 results inside the "Search for users V2" action and not inside Get items action.. here is my original issue @ https://powerusers.microsoft.com/t5/Building-Flows/InvalidTemplate-Unable-to-process-template-language-expressions/m-p/1279837#M145736 .. can you have a look and advice?

     

    Thanks

  • Ellis Karim Profile Picture
    12,377 Super User 2026 Season 2 on at

    This is really then a licensing question, which can be quite complex and we could talk to our Microsoft solutions partner in our organisation for advice.

     

    Having said that, take a look at the following links that may help you make a decision:

    Power Automate Limits for automated, scheduled, and instant flows:
    https://docs.microsoft.com/en-us/power-automate/limits-and-config#performance-profiles

    ekarim2020_2-1632264967661.png

    Requests limits and allocations:
    https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations

    ekarim2020_3-1632265029105.png

     

    Blog: Power of Power Automate and a Big Limitation!
    https://www.anupams.net/power-of-power-automate-and-a-big-limitation/

    Troubleshooting Slow Running Flows:
    https://support.microsoft.com/en-us/topic/troubleshooting-slow-running-flows-2a51dcd6-0b21-33da-5ce8-1e908b1540ef

    ekarim2020_1-1632264747006.png

    Hope this helps!

    Ellis

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 377

#2
11manish Profile Picture

11manish 292 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 128

Last 30 days Overall leaderboard