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
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Max Quota during flow
Power Automate
Suggested Answer

Max Quota during flow

(0) ShareShare
ReportReport
Posted on by WC-16031614-0
Amateur powerflow user.  I have to rely on Copilot ALOT.  I wrote a flow that updates a table on a spreadsheet with about 100 items per day.  During testing, it's slow and I think I'm chewing through my quota.  I often get max quota flow fails.  I think I have my flow refined and not making so many calls but now am unable to test it due to the max quota.  I assume my admin has to get involved and up my quota through MS, correct?
 
Categories:
General topics
I have the same question (0)
  • Suggested answer
    Vahid Ghafarpour Profile Picture
    Vahid Ghafarpour 817 on at
    I believe that your admin typically needs to get involved to check usage, allocate more capacity, or purchase add-ons if you've hit Power Platform request limits (e.g., 40,000 per user per 24 hours for Premium licenses). Quotas are sliding windows over 24 hours or 5 minutes, so they'll naturally recover as older runs age out, but testing a 100-item daily flow can quickly consume them during repeated runs.
  • Suggested answer
    11manish Profile Picture
    11manish 3,333 on at
    You are correct that your Admin can increase your limits, but there are several ways you can fix this yourself by changing how the flow "thinks," which will also make it run much faster.
     
    1. Understanding the "Quota"
    You are likely hitting Power Platform Request (PPR) limits. Every single card in your flow (even a "Compose" or "Initialize Variable") counts as 1 request.
    • The Loop Trap: If you have an "Apply to each" loop for 100 items and 5 actions inside it, that single run uses 500+ requests.
    • The License Factor: If you are on a standard Office 365 license, your limit is usually around 6,000–10,000 requests per 24 hours. Running a 500-request flow just 12 times a day can max you out.
    2. How to Fix it Without an Admin
    Excel is notoriously slow in Power Automate because it treats every row update as a separate network call. To stop "chewing through quota," you need to batch your work.
    Solution A: Use Office Scripts (The Pro Way)
    Instead of a loop that says "Update Row" 100 times, write a simple Office Script in Excel that takes an array of data and updates the table all at once.
    • Quota Impact: This turns 100 "Update Row" actions (100 requests) into 1 "Run Script" action (1 request).
    • Speed: An Office Script can update 100 rows in 2 seconds, whereas a loop might take 2 minutes.
    Solution B: Filter at the Source
    If your flow "Gets rows" and then uses a Condition to decide what to update, you are wasting requests.
    • Use OData Filter Queries in the "List rows present in a table" action (e.g., Status eq 'Pending').
    • This ensures the flow only pulls the specific 10 items that need work, rather than all 100.
    3. When to Involve Your Admin
    If you have optimized the flow and still hit limits, your Admin has three main levers:
    • Assign a "Process" License: This is a per-flow license that gives that specific flow a massive quota (up to 250,000 requests/day) regardless of who owns it.
    • Power Platform Request Add-ons: They can purchase "capacity packs" (50,000 extra requests per day) and assign them to your user account.
    • Pay-As-You-Go: They can link the environment to an Azure subscription so you simply pay for what you use over the limit.
     
    for more reference :
     

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
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
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans