Hi,
I'm trying to create a flow that takes information submitted in a Microsoft Form and adds it to an Excel table. The formulae in the table lookup the 'Manager Name' value and return the manager's email address. The flow then gets this value and sends an email with information from the table.
Whenever I test the flow manually by submitting the form, the 'List rows present in a table' action has an empty output and the email is not sent, although the flow is flagged as successful. If I delete the row in the excel table added during the test and then run the test using the same trigger, it works perfectly. Obviously I need the email to be sent when the form is submitted rather than manually re-running the trigger.
When manually submitting the form (list rows output is empty):
After deleting the row that has just been added and testing again by re-running the trigger (flow runs as intended):
I'm at a loss for why it only works after re-running the trigger. If anyone can help I'd really appreciate it.
