My flow is getting throttled and I don't believe I should be exceeding any limits.
Here's a summary of my flow:
My flow runs the first of every month. By my count there are 40 total actions being taken. How am I going over any limit with 40 actions once per month?
I reviewed the data in step 4a and only 293 rows of data were written to Excel before the Flow got throttled. This doesn't make sense to me.
I just tested my flow and I got this error message:
Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code '429'. This may indicate invalid input parameters. Error response: { "status": 429, "message": "Too many requests to Graph API. Please try again later.\r\nclientRequestId: REDACTED\r\nserviceRequestId: REDACTED", "error": { "message": "Too many requests to Graph API. Please try again later." }, "source": "excelonline-wus.azconn-wus.p.azurewebsites.net" }'.
Mark your own response as the Solution so others can see.
Found the answer to the 429 error here: https://powerusers.microsoft.com/t5/Building-Flows/Status-code-429-quote-rate-limit-is-exceeded-try-again-in-59/td-p/1120387 and here https://powerusers.microsoft.com/t5/General-Power-Automate/Excel-errors/td-p/581006
I ended up doing Fixed Interval - 50 Count - PT10S Interval to fix mine.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2