Hello, I'm stuck with this issue:
The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScript' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "brazil-001.azure-apim.net", "clientRequestId": id, "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: id, "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-bs.azconn-bs-001.p.azurewebsites.net" } } }
When I tried to save the flow despite the error message, that's what I got:
Flow save failed with code 'MultipleErrorsOccurred' and message 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScript' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "brazil-001.azure-apim.net", "clientRequestId": "id", "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: id", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-bs.azconn-bs-001.p.azurewebsites.net" } } };The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScript' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "brazil-001.azure-apim.net", "clientRequestId": "id", "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: id", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-bs.azconn-bs-001.p.azurewebsites.net" } } }'.
The part where it gets weird: I have access to another power platform of a different company and I was able to run the same script without trouble. What could that be? If its something internal, can someone from Microsoft help?
--------------------------------------------------------------------------------------------
SOLUTION:
I was creating the script with my personal account logged on excel. And then I copied the .osts file and pasted on the onedrive of another account, the one that was running the flow.
The solution is: The same account you log into Excel and create the script must be the same account that will run the flow.
