Flow designer issue for sending reminder emails
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 08:01 PM
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?
Thanks,
Rocky.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-27-2023 08:47 PM - edited 04-27-2023 09:34 PM
@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.
Hope this helps.