Hello I am working on a Flow that was working correctly, but no longer seems to be, and I have not been able to get it to work again. I have re-created it from scratch, with no success.
The basic Idea of the flow is to have people submit an answer on a MS FORM. That answer gets appended to a table in Excel online, where it is evaluated on that same table, by several columns with formulas. About 2 minutes later, FLOW is supposed to look at the cells containing the formulas, and send emails based on the formula results. 4 situations, 4 emails. (Approved, 2 rejected emails, or 1 "Doesn't exist) email.
In the excel file I am working with One tab is a Table connected to MS Forms. contains about 20 rows. 5 come from MS Form, the other 15 are formulas (Vlookup, Concat, if), and they exist to evaluate the response submitted from the form. The table containing the Lookup data is LARGE (About 3500 rows (and growing) and about 40 columns).
When I first built this flow, I was able to produce an email for each of the 4 scenarios I built below. I also got several other users to test and have a similar results. Then all of a sudden, it seems like the Table stopped automatically calculating/evaluating the submissions. You will see this in 2 screen shots below where one of them has valid data, the other has #n/a.
Does anyone have any idea how to get this to work?
Flow
Not Calculating/Not Working
Calculating/Working
Table/Formulas (partial)
