You’re offline. This is a read only version of the page.
6
Hi!
I have a flow that adds a row to an excel sheet when a new email arrives in a shared mailbox. It was working well last week (when I made it) but suddenly it stopped working. The error that comes back is "Bad Gateway" and I've tried troubleshooting but can't figure it out. I've tried:
Neither of these have worked, but a separate flow which updates a column in a row that was created by the previous flow does work. So it seems like the issue is with the "Add row" action and not the Excel connector.
Does anyone have any ideas of how to fix this, or how to find out if it's a general outage?
I tried a new Excel, tried a new table in a new tab, no luck...
However, when I reduced the line items from approx. 500 to 100, it worked.
Everyone seems to find a non-standard way of making this work. Microsoft should get on top of this.
@v-peijunz-msft Do you have any ideas for how to solve this? 🙏
Hi!
Absolutely! The message I receive is:
Share
Report
All responses (
Answers (
{
"statusCode": 504,
"headers": {
"Pragma": "no-cache",
"x-ms-datasourceerror": "True",
"x-ms-request-id": "4d28aaf2-db05-468b-9470-46d6cc5bb46a;8db97a1d-fb0c-49fe-a2dc-262413f2fffb;d68ab1b7-c27c-4ed4-9b14-22d3805bb9fb;794abb33-90d2-4e8a-928a-1035ace86632;f2617e83-b7cb-46d6-9327-1227161f5298",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Cache-Control": "no-store, no-cache",
"Date": "Wed, 26 Apr 2023 06:53:43 GMT",
"Content-Length": "727",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"error": {
"code": 504,
"source": "flow-apim-europe-002-westeurope-01.azure-apim.net",
"clientRequestId": "57687a7f-bf0a-464f-b320-06c6355133f1",
"message": "BadGateway",
"innerError": {
"status": 504,
"message": "Request to Graph API has timed out.\r\nclientRequestId: 57687a7f-bf0a-464f-b320-06c6355133f1\r\nserviceRequestId: 4d28aaf2-db05-468b-9470-46d6cc5bb46a;8db97a1d-fb0c-49fe-a2dc-262413f2fffb;d68ab1b7-c27c-4ed4-9b14-22d3805bb9fb;794abb33-90d2-4e8a-928a-1035ace86632;f2617e83-b7cb-46d6-9327-1227161f5298",
"error": {
"message": "Request to Graph API has timed out."
},
"source": "excelonline-we.azconn-we-002.p.azurewebsites.net"
}
}
}
}
Error message
And the flow looks like this:
Flow
Thank you!
Hi @zvc
To better to clarify your issue, could you please share the screenshot of your flow, and also the error message you received?
Thank you.
Best regards,
Sylvia
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
