Skip to main content

Notifications

Power Automate - General Discussion
Answered

Excel Business Connection

(0) ShareShare
ReportReport
Posted on by 2

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:
  • Verified answer
    ClintRB Profile Picture
    ClintRB 91 on at
    Excel Business Connection
    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.
  • Suggested answer
    Ellis Karim Profile Picture
    Ellis Karim 10,511 on at
    Excel Business Connection
    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

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard