Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Excel List Table Rows Preview, "Bad Gateway" Error

(0) ShareShare
ReportReport
Posted on by

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

  • RaySCook Profile Picture
    RaySCook 4 on at
    Re: Excel List Table Rows Preview, "Bad Gateway" Error

    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?

  • hjaf Profile Picture
    hjaf 486 on at
    Re: Excel List Table Rows Preview, "Bad Gateway" Error

    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?

  • v-zhos-msft Profile Picture
    v-zhos-msft on at
    Re: Excel List Table Rows Preview, "Bad Gateway" Error

    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

  • Re: Excel List Table Rows Preview, "Bad Gateway" Error

    Can you try and renew the connection? 

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics