Excel List Table Rows Preview, "Bad Gateway" Error

(0) Share

Report

Posted on by Community Power Pla...

The List Table Rows action under Excel Online (OneDrive) is returning an Error 502 "Bad Gateway" in a flow.

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Can you try and renew the connection?

Was this reply helpful? Yes No
v-zhos-msft on at

Like (0)

Report

Hi @Anonymous

If the error code 500 or 502 appears, the failure is temporary or transient. Click or tap Resubmit to try the flow again.

Best Regards,

Zhongys

Was this reply helpful? Yes No
hjaf 486 on at

Like (0)

Report
I'm having a similar issue with the business connector as well. Useless error appears after the flow is stuck for about 15 minutes:

Edit: (similar issue as this is a 504 and not a 502 response)

{ "error": { "code": 504, "source": "flow-apim-europe-001-westeurope-01.azure-apim.net", "clientRequestId": "xxxxxx", "message": "BadGateway", "innerError": { "status": 504, "message": "Request to Graph API has timed out.\r\nclientRequestId: dfghfdgh\r\nserviceRequestId: sdfdsfsdfs;dfsdfsfsd;dfghdfghgfd", "error": { "message": "Request to Graph API has timed out." }, "source": "excelonline-we.azconn-we.p.azurewebsites.net" } } }

I guess there is something up with the table in that file, another file with the same table works fine, so there is probably the content of a cell that is causing this. But I can't do much when all I have is the rather useless error above 😕

Any suggestions?

Was this reply helpful? Yes No
RaySCook 4 on at

Like (0)

Report

I just had this same behavior occur out of the blue for a spreadsheet I've been writing a flow around. Do you also have external data sources feeding the tables in the sheet?

Was this reply helpful? Yes No