Excel List Table Rows Preview, "Bad Gateway" Error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Can you try and renew the connection?

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

Like (0)

Report
Copy link

Link copied!

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 487 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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