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!