Share via

Bad Gateway on Excel Script Using Power Automate

Anonymous
2023-12-13T20:11:45+00:00

Hello,

I have a Power Automate Flow where I would like to take the details from a SharePoint list and have some of them populate into an Excel file that is copied into a folder on the same SharePoint. I have seen videos of people doing this and have followed along. However, I keep getting a Bad Gateway error and cannot figure out why. Some of the code has a "null" next to it which I assumed might be the problem. However, every data field has an entry so nothing should be empty. Below is my Excel Script Code, flow, and error. Is there a way to fix this? Again, I have seen many others accomplish this task so I know it is possible. Just need some expertise. Thanks!

"error": {"code": 502,"source": "flow-apim-msmanaged-na-centralus-01.azure-apim.net","clientRequestId": "b53bc385-3a44-483f-935e-93cc4e48d282","message": "BadGateway","innerError": {"message": "We were unable to run the script. Please try again.\r\nclientRequestId: b53bc385-3a44-483f-935e-93cc4e48d282","logs": null

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-14T03:46:32+00:00

    Based on the error message you provided, it seems that there might be an issue with the script that you're using.

    To troubleshoot this issue, I would recommend checking the script for any syntax errors or missing values. You mentioned that some of the code has a "null" next to it, which could be causing the problem. Make sure that all data fields have a valid entry and that there are no empty values.

    We’d suggest you go to Office Development - Microsoft Q&A to create a new thread which is special channel for handle script issue.

    Here is the Community for Power Automate.

    Microsoft Power Automate Community - Power Platform Community

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more