I cannot seem to get an Email Notification when a record's due date is reached

[Navaneeth1]

I wish to receive an email when that particular date and time arrive in real-time. 

So far I have created a Notification in System Notification>Email>Notifications with the following condition as shown in the below image.

Email sending is enabled in Email properties and the notification is working for record updation or insertion. 

Can anyone please help me?

Thank you.

[Ankur Bawiskar]

@Navaneeth 

You cannot trigger notification based on schedule unless you attach event to it and then trigger that event

You can use Flow Designer which would run Daily and check if today's date is same as Due Date

If yes then send the email to your recipients, subject and email body

1) Flow Trigger Daily 23:00:00

2) Use Lookup Records action on your table to check if due date is today

3) Then use For Each to iterate over those records

4) then use Send Email action

Regards
Ankur

[Ankur Bawiskar]

@Navaneeth 

Did you get a chance to check on the flow designer approach?

Regards
Ankur

[Navaneeth1]

I'm still checking on it. I shall let you know if it works or not as soon as possible. T

Thank you so much for the help!

[Navaneeth1]

The proposed solution has worked! 

Thank you so much for your help!

[Navaneeth1]

Hello,

This solution only works when the due date field type is "Date/time".

This is not working if the due date field type is "Date".

However, when a "Test" is given to check the flow it works.

But for the regular runs records are not matched

Could you please also provide a solution for this?

Thank you so much in advance!