I have 4 flows which are all setup the same: a MS Form submission triggers the flow and after a get response details step, I have a simple action to add a new row to an Excel table.
2/4 flows are working fine, typically taking 5-30 seconds to add the row and then move on in the flow. However the other 2 are very problematic. They either fail and never add the row with "BadGateway (504)" errors. Or, they take 30+ min to add the row. Sometimes, the flow will even fail, but then 2h later or so, several duplicate rows will all get added in bulk. 😕
I am almost certain that the issue is related to the Excel tables themselves. This is because I've run many tests and if I keep everything the same but change the Excel table to a new one, it works. However, it's not a permanent fix. The issue keeps coming back.
It's quite odd to me that 2/4 of my flows are working. Each is connected to a unique Excel file/table, however, the build is all structurally the same.
Does anyone have any solutions?
