I have an MS Form feeding an excel sheet. I have one column called "Theatre" where the region choices in the form are Americas, APAC or EMEA.
I added a column in the excel called "Flow Triggered" where the choice is Yes or No to avoid a loop scenario.
The aim:
- If cell = Americas, send email to person A and change Flow Triggered cell to Yes.
- If cell = APAC, send email to person B and change Flow Triggered cell to Yes.
- If cell = EMEA, send email to person C and change Flow Triggered cell to Yes.
Added a delay before calling a "list rows in a table" action.
Then added a "Apply to each" control
The "Update a row" above in the "If Yes" based on condition should change the row cell to "Yes" for the column "Flow Triggered".
Issues: The update a row works, but it did not deliver the flow adaptive cards........
Can someone please advise my logic so I can avoid any loops and so it works properly!
