web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Bad Gateway in the las...
Power Automate
Unanswered

Bad Gateway in the last 4 days

(0) ShareShare
ReportReport
Posted on by 37
Hi, anyone has been experiencing bad gateway error in flow "add a row into a table"?
 
{
  "error": {
    "code"504,
    "source""flow-apim-europe-001-northeurope-01.azure-apim.net",
    "clientRequestId""42756a0d-69a6-48c2-919a-7ccfa14ca8fd",
    "message""BadGateway",
    "innerError": {
      "status"504,
      "message""Request to Graph API has timed out.\r\nclientRequestId: 42756a0d-69a6-48c2-919a-7ccfa14ca8fd\r\nserviceRequestId: bd1a1ee0-6efe-42d3-a7ac-bf995a5eccf2;e5c2a927-6b4a-4d14-8fa3-61705688e934;037e1c3e-1ec1-4c92-844d-3be2f1b1684f;a0f1b448-1c2a-4031-a4f9-e3c36e70b7cf;be5cde54-6b8f-4172-ba15-d5a26a3215ba;bbd12033-2e7c-4b65-b3e3-a876c51b4fb8",
      "error": {
        "message""Request to Graph API has timed out."
      },
      "source""excelonline-ne.azconn-ne-002.p.azurewebsites.net"
    }
  }
}
 
Its weird because this flow works more than 2 years without errors, i already tryed to update my connections in Automate Interface, create a new flow to test create rows into that table (same error).
 
In this Excel File i have 2 tables connected to 2 flows, and the flow for the other table in the same file is running perfectly...
 
Im trying to understand if its related to my row qtd, because this have 4913 rows, and the other that works ok have 960...
Categories:
I have the same question (0)
  • Micky Profile Picture
    365 Moderator on at
    Hello,
     
    It's most likely related to how much rows you have and also for the default timeout setting for Power Automate actions.
    You can set fix this by extending the Timeout of that action, for example in the image below, i set the actions timeout to 1 day.
     
     
    Happy Power Automating
     
    Regards,
    Micky
  • MJ-03020935-0 Profile Picture
    2 on at
    Hi, I've got the same error from the Automate action "Run script" running an Excel Office Script. It has worked without issues for a month but now suddenly we gets BadGateway Code:504 every time the flow runs. (See the error message further below)
     
    Have tested the following. None of them had any effect, the error remains.
     - Added a new Action "Run Script" with without variables
     - Changed the Excel Office Script to a very simple one
     - Changed the Excel Online (Business) connection for the action to a new one
     
    Note: When I exported the flow, including the Excel Office scripts to another organizations tenant, It ran without errors!
     
     
    Error message:
    {
      "error": {
        "code": 504,
        "source": "flow-apim-msmanaged-na-centralus-01.azure-apim.net",
        "clientRequestId": "f83aaabb-1b29-4cdd-902d-a2e126d00697",
        "message": "BadGateway",
        "innerError": {
          "status": 504,
          "message": "Your Office Script has timed out. Please try again.\r\nclientRequestId: f83aaabb-1b29-4cdd-902d-a2e126d00697",
          "error": {
            "message": "Your Office Script has timed out. Please try again."
          },
          "source": "excelonline-scus.azconn-scus-001.p.azurewebsites.net"
        }
      }
    }
     
  • Igarsaba Profile Picture
    37 on at
     
     
    I tried to extend Action Timeout, but the error remains...  In 31-32 seconds, the flow trows GatewayTimeout
  • Igarsaba Profile Picture
    37 on at
     
    Error persists... Is there a way to increase the "Duration" of the attempt to connect in Gateway?
    I noticed that the flow never lasts longer than 50 seconds, if theres a way to force to increase that time, maybe works...
     
     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard