cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ReaperCushion
New Member

Different results when testing manually vs testing using a recent trigger

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):

ReaperCushion_2-1657810665976.png

 

After deleting the row that has just been added and testing again by re-running the trigger (flow runs as intended):

ReaperCushion_3-1657810778809.png

 

I'm at a loss for why it only works after re-running the trigger. If anyone can help I'd really appreciate it.

1 ACCEPTED SOLUTION

Accepted Solutions
Hardesh15
Super User
Super User

@ReaperCushion  Add a delay of 1 or 2 min in between add row and list row action. Use delay action.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

View solution in original post

2 REPLIES 2
Hardesh15
Super User
Super User

@ReaperCushion  Add a delay of 1 or 2 min in between add row and list row action. Use delay action.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Hi Hardesh,

 

This worked perfectly. I previously tried a delay of 30 seconds but all it needed was a little longer. Thank you!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,393)