How to set auto email notification from lists

Question

I have created a training due date tracker in Microsoft lists, and I want to receive notification (to Employee and Approval) 60 days before DUE DATE and another notification when DUE DATE is passed. Tried referring to many posts here but couldn't find suitable one as per my need. could someone please help me with set up this workflow?
In below screenshot - NEXT DUE DATE is auto calculated (Last Done Date + Interval) and DUE WITHIN column is auto calculated as well. Please advise.

Answer 1

Hi @Anonymous ,

This is my test list: (I set myself as recipient to display test results)

1.New flow->Build your own->Choose a connector:Scheduled->Skip to building your own flow

2.Set Intervals->Get items:select the list

3.Apply to each->Set Condition: formatDateTime(item()['Due_x0020_Date'],'yyyy-MM-dd') is less than addDays(utcNow(),60,'yyyy-MM-dd') AND formatDateTime(item()['Due_x0020_Date'],'yyyy-MM-dd') is greater than or equal to addDays(utcNow(),-1,'yyyy-MM-dd')
note:

• Due Date is greater than or equal to utcNow()-1 to ensure that you only receive an email one day after the expiration date, instead of receiving expired email reminders every day. You can also set corresponding conditions according to your needs.
• Since your DUE DATE column is a calculated column, you should adjust the ['Due_x0020_Date'] value to the column internal field value of the column in the formula. The format is usually [OData_field value]. If you are not clear, you can check it through Format data by examples,and I also give an example in the figure below.

4.If yes, set an email notification.
note: If you need to send two different emails, you can set two flows or nest them in loops, I am just giving an example here.

Test result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Dear @Xuyan Ding - MSFT ,

thank you very much for your response. I did set up work flow as you advised and all tests are running successfully but I am not receiving email notifications.
please see below set up I have done as per your advice.

Answer 3

Hello, @Xuyan Ding - MSFT ,
thanks for your response again.

I changed email id in notification setup section to my personal gmail id and I do receive emails now but emails not coming to my official id. that's what the real problem is. I can confirm that your code working perfectly.
Tried by putting another staff email id and still the same situation. I have my IT administrators to check why emails from microsoft@Loris .com are not coming through.
I would update you once sorted. thank you again.