Unanswered

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

(0) Share

Report

Posted on by johnjohn123

3,504

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

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

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

I have the same question (0)

All responses (3)

Answers (0)

Ellis Karim 11,473 Super User 2025 Season 2 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
johnjohn123 3,504 on at

Like (0)

Report

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

@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

Was this reply helpful? Yes No
Ellis Karim 11,473 Super User 2025 Season 2 on at

Like (0)

Report

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

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
Requests limits and allocations:
https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations

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
Hope this helps!
Ellis

Was this reply helpful? Yes No