502 bad gateway when trying to execute an excel script

[Anonymous]

Hi, I am getting a 502 bad gateway error when trying to execute a script. Tried both the Excel Run Script action as well as the Sharepoint Run Script one, same result. Here is the error:

The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScriptV2' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "europe-002.azure-apim.net", "clientRequestId": "c4db4595-ddc9-4b2b-a7ac-aacdb4478beb", "message": "BadGateway", "innerError": { "status": 502, "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments. clientRequestId: c4db4595-ddc9-4b2b-a7ac-aacdb4478beb", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-we.azconn-we-003.p.azurewebsites.net" } } }

[GeoffRen]

Can you try recreating the script from scratch from the Automate tab in Excel? I'm seeing that your file may have been corrupted.

[pwanderson]

I'm quite new to power automate. I'm trying to run a script in an excel document in onde drive for business. The script runs fine in the spreadsheet, 

I have created a flow that is triggered by "For this Row" in another spreadsheet. but when I try to run the script I get a bad gateway. Is this the same issue that others are reporting in this thread?

{

  "error": {

    "code": 502,

    "source": "flow-apim-msmanaged-na-westus-01.azure-apim.net",

    "clientRequestId": "8a710076-d3df-43dc-b7c7-5dcc2b156d95",

    "message": "BadGateway",

    "innerError": {

      "message": "We were unable to run the script. Please try again.\r\nclientRequestId: 8a710076-d3df-43dc-b7c7-5dcc2b156d95",

      "logs": null

    }

[Sahil0511]

Hi @GeoffRen,

I'm also facing the same error for "uk-001.azure-apim.net"

I tried recreating the excel scripts from scratch but it is still giving the same issue.

Please look into this.

Thanks

[bfreeman0]

Having the same issue, is there a service issue?

[erikrene97]

Same here except for "europe-002.azure-apim.net", I have also tried recreating the excel scripts from scratch but it is still giving the same issue.

Any update would great.

[erikrene97]

Cache Clear, Restart, Rewriting the script, deletion and the reconfiguration of the connector didn't work either.

[schmitzr]

Error 502 bad gateway with sharepoint script on excel online (business). Where can issues/tickets be opened to MS? The support page is fricking useless.

[tomkeysers]

I'm having the same all of a sudden since today... Any news on a service outage?

[GeoffRen]

Sorry to hear you're experiencing this problem. It might be an issue on our side and we have been actively investigating the root cause. Will let you know once it's been addressed. Thanks for your patience!

It would also be helpful for us to help investigate your issue if you post the error you are receiving with any pertinent information (in particular, the clientRequestId) as the OP did.

[joellasotaPF]

Hi @GeoffRen  

Please see few clientRequestIds below:

2902b008-13ad-45f4-a2c6-72ff63ca17cd

44abbca1-0725-41ee-a089-856c1d281278

aa9518c9-6301-4314-80fb-775e01f115e9

All showing 401 Unauthorized

[GeoffRen]

The issue should be mitigated, there was an issue with some certificate. Can you try again?

[schmitzr]

Hello @GeoffRen , I can confirm that the Error message in my Flow editor is gone, and that the flow is running as expected again. Thank you for the help and the update on the situation.

[FelipeLB]

Hi Team, Is this error back? I'm trying to run an office script in my flow and getting the Following message.

Failed to retrieve dynamic inputs. Error details: 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScriptV2' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "msmanaged-na.azure-apim.net", "clientRequestId": "150c0485-bc70-44c3-9929-65b2fb0edd85", "message": "BadGateway", "innerError": { "status": 502, "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments.\r\nclientRequestId: 150c0485-bc70-44c3-9929-65b2fb0edd85", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-wus.azconn-wus-001.p.azurewebsites.net" } } }'

[Lucid]

@FelipeLB  I'm also seeing this issue today. clientRequestId b43be39d-c5ed-4c4f-9525-6b253fbbaf57

[GeoffRen]

The error message could be much better but this looks like an unrelated error. It looks like your script is malformed. Was it modified manually at all? If you create a new script does the error persist?

[Lucid]

This is my script. I'm looking into a potential network issue.

function main(workbook: ExcelScript.Workbook) {
  // Get the first worksheet 
  const selectedSheet = workbook.getFirstWorksheet();
  //get active range of WorkSheet
  let range = workbook.getActiveWorksheet().getUsedRange();
  // Get last used row of WorkSheet
  let lastrow = range.getRowCount();
  // Find first reference of ID in selectedSheet i.e. header row
  let IDCell = selectedSheet.getRange("A1").find("FY", { completeMatch: true, matchCase: true, searchDirection: ExcelScript.SearchDirection.forward });
  // Get the current active cell in the workbook.
  //and format current cell without Sheet1! reference
  let activeCell = IDCell.getAddress().replace("Sheet1!", "");
  //get table range  
  const TableRange = `${activeCell}:F${lastrow}`;
  // Create a table using the data range.
  let newTable = workbook.addTable(selectedSheet.getRange(TableRange), true);
  newTable.setName("NewTableInExcel");
  // Get the first (and only) table in the worksheet.
  let table = selectedSheet.getTables()[0];
  // Get the data from the table.
  let tableValues = table.getRange().getValues();
  //Return a response to the Cloud Flow
  return tableValues
}

[GeoffRen]

Could you supply a different clientRequestId with a screenshot of the failure? I can't find your requestId (which would make sense if it is a network issue)

[Lucid]

Sorry @GeoffRen I can't, but thank you for the help.

[am_oc]

Receiving this error this morning on two different flows:

The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScriptV2' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "power-apis-usgov001-public.azure-apihub.us", "clientRequestId": "53e3a935-3a88-4d78-8d83-4641d0bbee81", "message": "BadGateway", "innerError": { "status": 502, "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments. clientRequestId: 53e3a935-3a88-4d78-8d83-4641d0bbee81", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-usgv.azconn-gcc-usgv-001.p.azurewebsites.us" } } }

The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScriptV2' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "power-apis-usgov001-public.azure-apihub.us", "clientRequestId": "a3e1e6ae-8fd7-4505-b300-09a240ac8e7a", "message": "BadGateway", "innerError": { "status": 502, "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments. clientRequestId: a3e1e6ae-8fd7-4505-b300-09a240ac8e7a", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-usgv.azconn-gcc-usgv-001.p.azurewebsites.us" } } }