Flow Failure after Extended wait time

(1) Share

Report

Posted on by CM-08051928-0

Halito (hello), I have been building a flow that takes a form response and inputs it into an excel sheet adding the responses to a Table. For some reason yesterday at about 2:00 PM CST the flow stopped working. I made no changes to the flow during testing as most of my work was in the excel sheet setting that up. I will say the excel sheet is fairly intense with all the formulas and automation that I have included into it. But for the life of me I cant seem to get the Flow working again. I have rebuilt it from the ground up, reset all connections, and it still fails at adding the data to the table. I am wondering if there is an alternative method for capturing form data and inputting into excel. this is all being done through Office 365 and teams

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

AndrianaO 219 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi! Can you please share the screenshot of error message that your flow gives you?

Was this reply helpful? Yes No
CM-08051928-0 8 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
MS.Ragavendar 7,162 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CM-08051928-0,

Please provide the flow run history and error message or error screenshot to provide solutions.

Was this reply helpful? Yes No
CM-08051928-0 8 on at

Like (0)

Report
Copy link

Link copied!

I'm not exactly sure what error message is needed so I have attached the failed Flows raw output above. Aside from that the only error message I get is the Bad Gateway found in the original image.

Was this reply helpful? Yes No
Suggested answer

ninihen 149 on at

Like (0)

Report
Copy link

Link copied!

It seems the issue is with the excel, not the flow. The error is a 504 timeout from Excel Online connector talking to Graph API.

As you said the excel is formula heavy, my guess is that when a row is added to the table by the flow, the excel recalculates the whole workbook before Graph returns success. That's the part taking time if you have heavy calculation that grows with the size of the table.

Maybe try flatten the data table sheet? So for the sheet that the connector writes into, try not to use formulas? Try avoid conditional formatting, arrayformula and anything that spills in the sheet with the data table, and move the calculation to a seperate sheet.

Was this reply helpful? Yes No
CM-08051928-0 8 on at

Like (0)

Report
Copy link

Link copied!

Just to Clarify, By Sheet you mean Workbook? I ask because I have already used Separate sheets to limit the load on the workbook and to provide a backup of information in case there is a failure point somewhere down the road.

Was this reply helpful? Yes No