I have a Power Automate flow that is collating a fair bit of financial data and then passing this information as JSON into an Excel Script action. The Excel script is laying in this data and also setting up a number of calculations as it goes. This is pretty important to me, as the end user would want to see the math that's going into different cells. Whenever I have a particularly large JSON object to pass into the script, I get the following:
{
"error": {
"code": 504,
"source": "unitedstates-002.azure-apim.net",
"clientRequestId": "23bf5646-e701-4037-8b1a-766296ce4064",
"message": "BadGateway",
"innerError": {
"status": 504,
"message": "Request to Graph API has timed out.\r\nclientRequestId: 23bf5646-e701-4037-8b1a-766296ce4064",
"error": {
"message": "Request to Graph API has timed out."
},
"source": "excelonline-eus2.azconn-eus2.p.azurewebsites.net"
}
}
}
My understanding is that the formula cells are what makes all this time out. I'd really like to try and keep these formulas in the Excel. Is there any other workaround to this issue, like extending the timout for the Excel script action? It's extremely frustrating to have spent so much time getting this Excel script to sing with my Power Automate flow just to see it fail as soon as it has a little bit of real data.
