Flow designer issue for sending reminder emails

Rocky5
Kilo Sage

Hello Experts,

 

For all change requests that past 2 days the planned end date we need to send a reminder email to assigned to user, And then wait for 5 days and check if change request is closed or not. If it is not closed then send second reminder email.

 

I have built the below flow (which triggers daily) but the second reminder is still sent even after change request is closed because since flow triggers every day. let's say if change request is closed 2 days after first reminder email is sent, since the flow was triggered 2 days before first reminder email is sent the triggered flow is considering the change request is not closed and sending second reminder email even after change is closed.

 

How do I fix this? what changes I need to make to the flow?

 

Rocky5_1-1682650509970.png

 

Thanks,

Rocky.

 

 

1 REPLY 1

Sandeep Rajput
Tera Patron
Tera Patron

@Rocky5 Instead of using the stale values (values which were fetched during the flow trigger) in if condition, do another look up of Change Request records just before the if condition and after the wait for condition. Use values of Lookup fetched in this stage to check the state in if condition and the issue which you are facing right now would not occur again.

Rocky5_1-1682650509970.png

Hope this helps.