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"
}
}
}