Flow stop as error Bad gateway 402 occured. Please help

(0) Share

Report

Posted on by Jo9

Hi,

My flow unable to run normally as it will stop due to bad gateway error. Please advise how to resolve this issues?

The whole documentation approval flow stuck.

"error": {

"code": 502,

"source": "asia-001.azure-apim.net",

"clientRequestId": "7d7d7440-a8bb-4ec3-867b-2a018c08b8c8",

"message": "BadGateway",

"innerError": {

"status": 502,

"message": "We're sorry, but something went wrong with this file.\r\nclientRequestId: 7d7d7440-a8bb-4ec3-867b-2a018c08b8c8\r\nserviceRequestId: bbfd6b20-6283-4f6f-ae9e-b4d02a58e1d6",

"error": {

"message": "We're sorry, but something went wrong with this file."

"source": "excelonline-ea.azconn-ea-001.p.azurewebsites.net"

}

Thank you.

Best regards,

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Manish Solanki 15,099 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Jo9

Could you pls show the configurations (input parameters) for "Get tables" action in edit mode?

Was this reply helpful? Yes No
Jo9 57 on at

Like (0)

Report
Copy link

Link copied!

Please find the following edit mode

Was this reply helpful? Yes No
Jo9 57 on at

Like (0)

Report
Copy link

Link copied!

or code view?
{
    "inputs": {
        "host": {
            "connectionName": "shared_excelonlinebusiness",
            "operationId": "GetTables",
            "apiId": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness"
        },
        "parameters": {
            "source": "sites/company.sharepoint.com,23723899-832a-4051-897f-388dbe2ca2ed,5c92e17f-6fb5-42ef-b65f-72e3872b2749",
            "drive": "b!mThyIyqDUUCJfziNviyi7X_hkly1b-9Ctl9y44crJ0nRHm_TYClMTqAXi9bawS8M",
            "file": "@outputs('Get_file_metadata')?['body/Id']"
        },
        "authentication": {
            "type": "Raw",
            "value": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"
        }
    },
    "metadata": {
        "operationMetadataId": "ab5258db-f10e-446d-b1b7-f053c234758b",
        "tableId": null
    }
}

Was this reply helpful? Yes No
Manish Solanki 15,099 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Jo9

You need to pass the file path in the "File" input parameter instead of ID. It would be helpful if you could share the screenshots of previous actions or overall flow.

Was this reply helpful? Yes No
Manish Solanki 15,099 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Jo9

Pls pass "Path" from the "Get file metadata" action as shown below:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Jo9 57 on at

Like (0)

Report
Copy link

Link copied!

it works for all the members except one member who encountered this issues when initiate the power automate.

Was this reply helpful? Yes No
Jo9 57 on at

Like (0)

Report
Copy link

Link copied!

Hi, I tried changing to path instead of using id.
But the bad gateway still occur.
{
  "error": {
    "code": 502,
    "source": "asia-001.azure-apim.net",
    "clientRequestId": "b35057d5-cde2-4d1f-b03f-e63007f86954",
    "message": "BadGateway",
    "innerError": {
      "status": 502,
      "message": "We're sorry, but something went wrong with this file.\r\nclientRequestId: b35057d5-cde2-4d1f-b03f-e63007f86954\r\nserviceRequestId: a61b98d4-8cf4-4a5b-8995-a6fafbe49fd1",
      "error": {
        "message": "We're sorry, but something went wrong with this file."
      },
      "source": "excelonline-ea.azconn-ea-001.p.azurewebsites.net"
    }
  }
}

Was this reply helpful? Yes No
Verified answer

Jo9 57 on at

Like (0)

Report
Copy link

Link copied!

Hi,
I have found out the root cause. It is because my working file has been corrupted after changing to a new working file. It works fine. Anyway, thanks for your prompt reply.
Best regards,
Jo

Was this reply helpful? Yes No