cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Unable to edit Excel Online file in SharePoint

Hi,

 

I have an Excel file saved to the Documents folder in a SharePoint site. I am trying to use Flow to add/delete rows from a table within the Excel file. I have been unable to edit the file at all, however the action "Get Tables" works properly...

I keep getting a 502- BadGateway error.

Capture.PNGCapture2.PNG

Error log: {
  "error": {
    "code": 502,
    "source": "msmanaged-na.azure-apim.net",
    "clientRequestId": "d3f77287-c113-458a-91c7-77213f781f7b",
    "message": "BadGateway",
    "innerError": {
      "status": 502,
      "message": "Graph API is currently unavailable.\r\nclientRequestId: d3f77287-c113-458a-91c7-77213f781f7b",
      "source": "excelonline-cus.azconn-cus.p.azurewebsites.net"
    }
  }
}

 

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Unable to edit Excel Online file in SharePoint

Hi @Anonymous,

 

I have made a test on my side and don't have the issue that you mentioned.

 

The screenshot of my flow as below:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

 

Please take a try to run the flow again to see if the problem still exists.

Also please take a try to create the new flow to see if the problem still exists.

 

Best regards,

Alice

 

Highlighted
Administrator
Administrator

Re: Unable to edit Excel Online file in SharePoint

Hello, @Anonymous!

Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!


Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

-Gabriel
Microsoft Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!
Highlighted
Anonymous
Not applicable

Re: Unable to edit Excel Online file in SharePoint

I still get a BadGateway error (502). Not sure why!

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,027)