Answered

Excel Business Connection

(0) Share

Report

Posted on by HA-25100931-0

Error:

Failed to retrieve dynamic outputs. As a result, this operation's outputs might not be visible in subsequent actions. Error details: 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: 03a435e1-6ad1-45cf-96e4-69743f8adf7d", "error": { "message": "Too many requests to Graph API. Please try again later." }, "source": "excelonline-ea.azconn-ea-001.p.azurewebsites.net" }

I'm experiencing an issue with several of my flows, all of which use the Excel Business Connector. They were all working perfectly yesterday (Oct 24, 2024), but as of today (Oct 25, 2024) it starts giving me errors above.

Could anyone help help me if this is a Microsoft issue or something on my end? Thanks!

Categories:

General topics

image (3).png

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Ellis Karim 11,695 Super User 2025 Season 2 on at

Like (0)

Report
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"
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.

see: Configure Retry Policy to resolve Rate limit exceeded-429 error code in Power Automate | by Pooja Bhardwaj | Medium

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No
Verified answer

ClintRB 91 on at

Like (2)

Report

Hi, This appears to be an issue with microsoft. I have flows that have been runing for years and on the 25th same problem. My flows are set to run concurrently, this issue with "too many requests" looks to me due to the connection failing with excel so the flow kept trying to connect. Today the flows run without any changes at all, I just resubmitted the failed runs and all is good. The seems to have accured in the late afternood EST AUSTRALIA.

Was this reply helpful? Yes No