I have already created a flow yesterday and had successful runs. But when I tried running the same without any modifications faced the error status code 429 where it mentioned as below:
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. clientRequestId: *********** serviceRequestId: *************", "error": { "message": "Too many requests to Graph API. Please try again later." }, "source": "*************" }
now I am unable to select the table in the file due to this issue. I hope it is not for me alone.
The status code 429 indicates "Too Many Requests" and this typically happens when the flow has exceeded the rate limit for API calls or requests to a service. In other words, you are making too many requests in a short period, and the Power Automate service is protecting itself from overload. You are probably rerunning the flow again and again, which is making too many calls (actions) in a short period of time,
You could try:
Don't use Concurrency
Reduce unnecessary API calls
Implement Retry Policies
Retry Policies
Configure exponential backoff retry policies for actions:
Set "Type" to "Exponential Interval" and adjust "Count", "Interval", and "Maximum Interval" settings.
Retry Policy Components
Type: Exponential Interval
Count: 20
Interval: PT10S (10 seconds)
Minimum Interval: PT10S (10 seconds)
Maximum Interval: PT40S (40 seconds)
The "Exponential Interval" type means that the time between retry attempts increases exponentially.
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.