Flow Sending Reminder Emails Every Day After the 15th Day Instead of Only on 15th and 22nd Day

[Rahuf Sayyad]

Hello,

I’ve created a flow in ServiceNow to send reminder emails on the 15th and 22nd day if the request is still in the "waiting for approval" state based on the RITM table. However, while the flow is correctly sending the email on the 15th day, it is also sending emails every day after the 15th, which is not the intended behavior.

Flow Setup:

• The flow is supposed to trigger only on the 15th and 22nd day after the request is created.

• I have conditions in place to check if the request is still in the "waiting for approval" state.

• The reminder email is being sent on the 15th day, but after that, it continues to send the reminder every day, rather than just on the 22nd day.

Additionally, if the request is not approved, the record should be automatically closed on the 30th day after creation, and this condition is working as expected.

Problem:

The flow continues to send reminder emails every day after the 15th day, which shouldn't happen. The email should only be sent on the 15th and 22nd day.

Request:

Can anyone help me identify why the flow is sending emails every day after the 15th? Any suggestions for modifying the flow logic to ensure it only sends the email on the 15th and 22nd day would be greatly appreciated!

Note: The flow is already in production, and the issue needs to be fixed as soon as possible to ensure only the 15th and 22nd-day reminders are sent.

Thank you!

[Ankur Bawiskar]

@Rahuf Sayyad 

I already shared the exact filter condition 4hours ago which should work for you

Did you check that response?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Rahuf Sayyad 

Was this not tested in DEV and UAT?

to look for records created exact 15 days you can use this

It worked for me

similar thing can be done for 22 days

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Rahuf Sayyad]

Hi @Ankur Bawiskar ,

In DEV and UAT, for testing, I had kept the condition in minutes.

So I didn't face the issue.

I tried the condition, but it is not fetching the records.

[Ankur Bawiskar]

@Rahuf Sayyad 

did you try to apply that on table filter condition and see if any matching record comes?

do you have any records which are created exact 15 days ago?

share screenshots.

[Rahuf Sayyad]

@Ankur Bawiskar 

If i am trying single condition, it is showing records, but if if I am adding both it is not showing any records.