cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnjohn123
Super User
Super User

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

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 ?

3 REPLIES 3
ekarim2020
Super User
Super User

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

 

@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-langua... .. can you have a look and advice?

 

Thanks

ekarim2020
Super User
Super User

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...

ekarim2020_1-1632264747006.png

Hope this helps!

Ellis

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,949)