Answered

Unable to save Flow - 429 error

(0) Share

Report

Posted on by DuncanIVH

115

I have an existing Flow which I'm trying to make a change to but I get various errors including 429 and 'the requested resource doesn't exist'.
This seems to be on an Excel Get Tables step.

"Too many requests to Graph API. Please try again later. Error code is 'TooManyConsecutiveFailures'. Error message is 'The request has been throttled due to too many consecutive API failures in the session. "

This Flow only runs once a day, and only makes one request to get the table so I'm surprised it's hitting a limit. I've also had the issue over a few different days.
The file that I'm getting the table from is dynamic data from the previous step, but I get the error if I select a specific, existing file.

When the Flow actually runs, it runs without issue.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

MS.Ragavendar 6,955 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@DuncanIVH,

Pause and retry after a few minutes, as Microsoft’s Graph API typically resets rate limits shortly after excessive requests, Run fewer requests against SharePoint. Use the SharePoint Batch API to bundle requests.

I suspect the cause of this problem is a service or network issue that temporarily prevents the connector from reaching the data storage (eg, OneDrive/SharePoint). The connector then retries until it exceeds the Graph API limit .I assume there is no fix to this error that you mentioning, it will automatically refresh after waiting some time. This could be 30 minutes or so.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

Was this reply helpful? Yes No
DuncanIVH 115 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have tried multiple times over multiple days. I feel like if we were actually hitting the rate limit, all other live Flows which use this Connector would be having issues when they run. But it is only this Flow, when it is saved.

I have also created a separate Flow, using the same steps (create Excel file, get tables) which saves fine.
I can save the existing Flow and get the error. Then immediately save the new Flow without error. So that suggests it isn't really hitting a limit.

Was this reply helpful? Yes No
MS.Ragavendar 6,955 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@DuncanIVH,

Are you using any degree of parallelism under Concurrency Control, if yes reduce the parallelism and try saving the flow once.

How many actions that you are using in the flow?

https://learn.microsoft.com/en-us/troubleshoot/power-platform/ai-builder/power-automate/too-many-requests-error-in-power-automate

https://sharepains.com/2024/03/14/429-errors-trigger-flow-power-automate/

Was this reply helpful? Yes No
DuncanIVH 115 on at

Like (0)

Report
Copy link

Link copied!

It is an email triggered Flow, however it only triggers once per day at 3am. The 'Get Tables' is within an 'Apply to Each'. However this will only run once per Flow, as there is only ever one attachment on the email.
Both the Flow itself and the loop have their concurrency set to 1.

I feel like the rate limit error may be misleading and the actual error is this:

Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "Graph API request failed. Error code is 'ItemNotFound'. Error message is 'The requested resource doesn't exist.'.

As per the screenshot in the first post, Get Tables is using the ID of the file from the Create File step.
In another Flow, I can do 'Get Tables' on a hardcoded file in the same document library.

Was this reply helpful? Yes No
Verified answer

DuncanIVH 115 on at

Like (0)

Report
Copy link

Link copied!

Ahaa! A table in a different step had been deleted by the users!

Was this reply helpful? Yes No