Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

BadGateway GetSingleScript failure Office Script run on Excel File

(0) ShareShare
ReportReport
Posted on by

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": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx", "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: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-eus.azconn-eus-003.p.azurewebsites.net" } } }'

 

Above is the error I am receiving consistently when trying to run a script in Power Automate using Excel for Business. I have tried running different scripts including the one provided by the Microsoft tutorial and others found online (with and without script params) to ensure the script functions properly. The retrieval of my Excel file works as I have tested it with a single Get Worksheet action, and it succeeds, but when I integrate the script, it fails. I have tried saving and pulling it from OneDrive and SharePoint using the Run Script from SharePoint Library action, and I have tried pulling it from my OneDrive using the simple Run Script action with the file in my /Documents/Office Script/. It is allowing me to select the file properly (I am not custom filling out the boxes), so the connection must be somewhat correct. It also seems I have permissions to execute the script from a file properties standpoint (User, SYSTEM, and Admin). I am not sure what the problem is or what to do next; I would appreciate any and all help I can receive. Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics