cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wsalling
Helper III
Helper III

BadGateway and OneDrive Business excel

i have a flow that opens an excel file on Onedrive and adds a couple of rows to the table.  Works under my account. others cannot. they have same setup as me. We can see the file on their onedrive folder and the desktop link.  they can edit the file on the desktop and save it.  but when the flow runs it gets the Bad Gateway error.  Ideas?  i have also logged onto this machine and ran it and it works fine.

Am is missing a permission somewhere in the flow.

 

{
  "error": {
    "code"502,
    "source""unitedstates-002.azure-apim.net",
    "clientRequestId""3700623e-d930-4d01-b2b6-7ef76b1c3a19",
    "message""BadGateway",
    "innerError": {
      "status"502,
      "message""Graph API is currently unavailable.\r\nclientRequestId: 3700623e-d930-4d01-b2b6-7ef76b1c3a19\r\nserviceRequestId: 98a766e0-cdf1-428a-9320-9e6bb1c39953",
      "error": {
        "message""Graph API is currently unavailable."
      },
      "source""excelonline-wus.azconn-wus.p.azurewebsites.net"
    }
  }
5 REPLIES 5
wsalling
Helper III
Helper III

Forgot to mention, i know the OneDrive account is working because i have another flow that writes out a CSV file to the same folder and it works just fine.  Excel is the issue here.  it appears not to either find the file or the table from other users.  why is that?

The issue is it was trying to edit my excel file on my one drive and not there one drive.  i do not want to create a separate flow for every export Flow per project per user.  how do you get around the dynamic file issue?  is sharepoint the same way?

Anonymous
Not applicable

I have the same issue. Someone please help.

Give them access to your one drive account.  when others use the app it is looking at their folders not yours.

Anonymous
Not applicable

In my case, the flows, the Forms, and Excel online file are all sitting in the same account. And the same setup works for other tables in the same file where data from other forms are being populated, it just fails for two specific Forms. 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,490)