cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AmirBakht
Helper IV
Helper IV

Power Automate Daily Limits

Hi,

 

So I'm aware of Power Automate's daily limits listed below. However, as we are becoming more and more dependent on Flows to run our automations, the action counts are increasing quite rapidly. Specifically, scheduled flows that run a lot of data manipulation eat up a big chunk of the action quota. I'm sure we are not the only ones out there preferring Flows over windows services and the likes for such purposes. 

 

Usually flows run under a single service account with the appropriate permissions and accesses for manageability, which would limit us somewhere from 5'000 to 20'000 actions per day depending on licenses. 

 

How is every one coping with the limits? Best practices? Recommendations? Alternate approaches? We are touching limits already and I would hate to have to start moving away from flow for these complications.

 

https://docs.microsoft.com/en-us/power-automate/limits-and-config 

 

AmirBakht_0-1604495479794.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

@Jronash that would be a good solution but I think that was not possible. According to what I have been searching, there has been no such capability till a little while ago. However, I just came across an article today which may be very new or recently updated (wasn't showing up in my searches before) that says we may be looking at something similar sometime soon "will be supported once the transition period ends, during 2020 Release Wave 2"

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

 

Capacity add-ons may be the solution to our problem but the information seems to be a bit limited. 

 

Capture.PNG

 

 

 

I will keep this topic open for now to get more suggestions and maybe more information on this upcoming support.

View solution in original post

16 REPLIES 16
Jronash
Impactful Individual
Impactful Individual

It is something we've run into as well.  It would be nice if there were an affordable way to add extra actions to an account.  Like you, we use a single service account to perform a lot of automated tasks behind the scenes.  We were brushing up against our daily limits on a regular basis.

 

Our options appear to be to purchase a per-flow license, which wouldn't really help in our situation because the actions are spread across many different flow, or to license a second service account, which defeats the purpose of a single service account with all the right licenses and permissions.

 

We ended up deleting one of our most action-heavy flows and recreating it with a Python script.  I'm not happy that we had to go in that direction, as it was nice to have all of the automation running in one place, and in a form that could be understood by everyone on our team, even those without a programming background.  But it has bought us some time as we decide how to handle this.

Ketver
Regular Visitor

Comically, I was coming on here to post this exact problem, but you fortunately beat me to it. I've created about a dozen flows, with 15 actions each, running every 5 mins. This is because the flows are crucial for updating data, so that we can address any and all issues as soon as they occur. As you can see with just this handful of flows, the licensing limits are quickly impractical.

 

I suppose my only option at this point is to purchase a second license for the 20,000/day limit.  Each flow only runs about 1,500 actions/day (counting office hours only), so purchasing the per flow plan is just silly and excessive. I understand the Power Platform is relatively new, but it seems a bit ridiculous that we are limited to only a couple bad options. 

@Jronash I develop myself as well, but still prefer uncoded over coded where business requirements dictate the requirements. I can understand moving integrations and such to coded, but where business requirements keep dictating changes in the solution, you need something like Flow to not only give quick changes turnaround but also be (as you mentioned) adoptable by the variety of the teams.

@Ketver the problem is, just throwing money at it doesn't solve the issue. Yes, you get extra actions per day and increase your limit, but consider this,

  • You will need to split your extensive flows into multiple to split the action count
  • You will need to manage permissions for each of the new licensed accounts 
  • You will have to manage security and risk for the new accounts
  • You will have to manage access for each of the new accounts, who owns them and who can access them
  • You will have to manage how each account is spread out between flows and any other solution they may be used in
  • You are spending more and now suddenly have even more tasks and risks added to your plate 
AmirBakht
Helper IV
Helper IV

Anyone else with any other ideas? No one here seem to be happy with their current situation.

Jronash
Impactful Individual
Impactful Individual

Is it possible to purchase multiple 'Power Apps and Power Automate capacity add-on' licenses and apply all of them to a single user?

@Jronash @AmirBakht this may sound like a really stupid question, but how do you check how close you are to your daily usage limit?

@Jronash that would be a good solution but I think that was not possible. According to what I have been searching, there has been no such capability till a little while ago. However, I just came across an article today which may be very new or recently updated (wasn't showing up in my searches before) that says we may be looking at something similar sometime soon "will be supported once the transition period ends, during 2020 Release Wave 2"

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

 

Capacity add-ons may be the solution to our problem but the information seems to be a bit limited. 

 

Capture.PNG

 

 

 

I will keep this topic open for now to get more suggestions and maybe more information on this upcoming support.

@Paulie78 this should get you the information https://docs.microsoft.com/en-us/power-automate/billing-questions but for me it only shows activity.

 

Instead, you could click on a flow and go to its analytics to see its usage, that is premium though.

 

If you go to the power automate admin center and click usage, you should be able to see more flow analytics https://admin.powerplatform.microsoft.com/analytics/flow 

Jon7
Frequent Visitor

Hi-

 

We purchased the "Power Apps and Power Automate capacity add-on" through the O365 admin portal.

 

Does anyone know how to apply these new licenses to a user?

 

Thanks!

 

Anonymous
Not applicable

Would it maybe be an idea to use Power Automate Desktop. I am quite sure the "action" starting PAD flow will be only 1 action, and then in the PAD you can have all the actions running and only count for 1. Just an idea, I have not tried this myself. 🙂

takolota
Multi Super User
Multi Super User

For anyone facing similar issues, before buying too many capacity add-ons, you may want to check the design of your flows.

 

-If you are creating, updating, or deleting large numbers of SQL, SharePoint, or Excel records in loops, one by one, review these resources:

SQL Batch CRUD: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/...

 

SharePoint Batch Create: https://youtu.be/2dV7fI4GUYU

 

SharePoint Batch Update: https://youtu.be/l0NuYtXdcrQ

 

SharePoint Batch Delete: https://youtu.be/2ImkuGpEeoo


Excel Batch Actions

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Create-Update-and-Upsert-Excel/td-...


https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Delete/m-p/1634375#M735

 

-If you have any loops running many times that include conditionals, consider using two Filter array actions, one for the true case and one for the false case. This means instead of running a conditional for every record or every instance, the flow filters the data into a true batch and into a false batch in just 2 actions.

 

-If you have many frequent flows that require initializing many variables before the rest of the flow run, consider consolidating many of those variables into 1 or 2 actions like in this video: https://youtu.be/TCIr7Bc3Oko

 

-If you have flows that don’t need to trigger for every instance of a trigger event, use trigger conditions.

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Power-Automate-Trigger-Conditions-...

 

I cut more than half the actions per day used in my entire organization using more efficient flow techniques like these.

Thank you for these useful tips! I'll review some of my old flows to make them more 'lean'.

Thank you very much, this is a great solution.
I have an additional problem. I want to limit the access of the data in sharepoint list. In my case I have an excel spreadsheet which should be transferred to sharepoint list. In the excel spreadsheet in the last column are listed the users (max1.mustermann@web.de, max2.mustermann@web.de, etc) who are allowed to access the record. How can I change the flow so that all records are uploaded with associated access permissions?

@MaxMustermann 

I don’t currently know of any way to batch apply any item level permissions setting. That may still require looping one by one.

slx299
Helper III
Helper III

Hi

 

how to count the actions in a flow? What count as an action? I am running trivial business logic and still get message contains too many actions

 

thank you

Helpful resources

Announcements

Celebrating the May Super User of the Month: Laurens Martens

  @LaurensM  is an exceptional contributor to the Power Platform Community. Super Users like Laurens inspire others through their example, encouragement, and active participation. We are excited to celebrated Laurens as our Super User of the Month for May 2024.   Consistent Engagement:  He consistently engages with the community by answering forum questions, sharing insights, and providing solutions. Laurens dedication helps other users find answers and overcome challenges.   Community Expertise: As a Super User, Laurens plays a crucial role in maintaining a knowledge sharing environment. Always ensuring a positive experience for everyone.   Leadership: He shares valuable insights on community growth, engagement, and future trends. Their contributions help shape the Power Platform Community.   Congratulations, Laurens Martens, for your outstanding work! Keep inspiring others and making a difference in the community!   Keep up the fantastic work!        

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!    

Welcome to the Power Automate Community

You are now a part of a fast-growing vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun.   Now that you are a member, you can enjoy the following resources:   Welcome to the Community   News & Announcements: The is your place to get all the latest news around community events and announcements. This is where we share with the community what is going on and how to participate.  Be sure to subscribe to this board and not miss an announcement.   Get Help with Power Automate Forums: If you're looking for support with any part of Power Automate, our forums are the place to go. From General Power Automate forums to Using Connectors, Building Flows and Using Flows.  You will find thousands of technical professionals, and Super Users with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Power Automate community forums. Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered. Galleries: The galleries are full of content and can assist you with information on creating a flow in our Webinars and Video Gallery, and the ability to share the flows you have created in the Power Automate Cookbook.  Stay connected with the Community Connections & How-To Videos from the Microsoft Community Team. Check out the awesome content being shared there today.   Power Automate Community Blog: Over the years, more than 700 Power Automate Community Blog articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on the future of process automation. In the Power Automate Community Blog, you can read the latest Power Automate-related posts from our community blog authors around the world. Let us know if you'd like to become an author and contribute your own writing — everything Power Automate-related is welcome.   Community Support: Check out and learn more about Using the Community for tips & tricks. Let us know in the Community Feedback  board if you have any questions or comments about your community experience. Again, we are so excited to welcome you to the Microsoft Power Automate community family. Whether you are brand new to the world of process automation or you are a seasoned Power Automate veteran - our goal is to shape the community to be your 'go to' for support, networking, education, inspiration and encouragement as we enjoy this adventure together.     Power Automate Community Team

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Users online (5,101)