Large error message while saving Power Automate Flow

[PMAutomation]

I have several Power Automate flows online that I have been using. Just this morning I tried to make some small changes to them, but I got a unique error message. I tested it again by not making any changes and just saving it, but it gave me the same error (formatted for better visual interpretation):

Flow save failed with code 'MultipleErrorsOccurred' and message

'The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScriptV2' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "power-apis-usgov001-public.azure-apihub.us", "clientRequestId": "587fdaf4-20ce-46b3-b1f6-e3eeb4af7f43", "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: 587fdaf4-20ce-46b3-b1f6-e3eeb4af7f43", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-usgv.azconn-gcc-usgv-001.p.azurewebsites.us" } } };

The dynamic ...

It repeats the same message 9 more times...

What is this error? What causes it? How can it be fixed?

[ManishSolanki]

Hi @PMAutomation 

We had also faced the same issue. It looks like some issue with services. The same issue occurred few days back but I am not sure from where I could see the services outage or subscribe to get alerts.

@v-mengmli-msft  Pls suggest.

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

[Motti77]

Hi there,

has this problem been solved already?

today this error started to emerge here as well and it is very annoying

[Motti77]

@PMAutomation here is an update, maybe it helps you as well.

after looking through my files, i found that one of the excel files i used in my flow was somehow damaged. (i did not touch it though).

after i opend the file, excel asked me to "fix it". i let excel fix the file and after that the flow worked again.

however, i do not know what damaged the file in the first place... i guess the microsoft gods do not know either...

[PMAutomation]

I don't know if it was just a temporary issue, but after a few hours I was able to save and update the flow. Sometimes it gave the error message on other flows, but now the messages have all disappeared.

Also, I was initially using the old designer to edit the flow (since it was too large for the new designer), but now the new designer also works with this large of a flow (I don't know if the new designer made a difference).

Lastly, when I opened it in the new designer, there were three dynamic values that no longer appeared in the places they should have been (maybe the error was somehow caused by that).

Thanks anyways for all the suggestions!