create notifications when an item is 1 day, 5 day, 15 days and 30 days to due date

(0) Share

Report

Posted on by Kalungi A

With Power Automate, how can I create notifications when an item is 1 day, 5 day, 15 days and 30 days to due date.

Then a daily reminder after the due date until the record is closed.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

David_MA 14,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
You can do this:

Create a flow that is scheduled to run daily at the time of day you want the notifications to be sent.

Add a filter query to get items meeting your due date criteria. Something like this: (DueDate ge addDays(startOfDay(utcNow()), 1) and DueDate lt addDays(startOfDay(utcNow()), 2)) or (DueDate ge addDays(startOfDay(utcNow()), 5) and DueDate lt addDays(startOfDay(utcNow()), 6)) or (DueDate ge addDays(startOfDay(utcNow()), 15) and DueDate lt addDays(startOfDay(utcNow()), 16)) or (DueDate ge addDays(startOfDay(utcNow()), 30) and DueDate lt addDays(startOfDay(utcNow()), 31))

Add an Apply to each action pointed to the items returned from the get items action.

You may need to put all of the above in () so it gets items for your different date criteria and and and Status eq 'Open' as well.

Inside the Apply to each, send the e-mail reminder.

Create a second flow for the daily reminders.

Use a get items action with a query filter where the DueDate lt startOfDay(utcNow()) and whatever field you use to designate that the item is still open.

Then like above, use an apply to each on the items retrieved with an e-mail action to send the e-mail.

Be sure to put the expressions for the dates within single quotes in the filter queries.

Was this reply helpful? Yes No
Kalungi A 10 on at

Like (0)

Report
Copy link

Link copied!

Hi David,

Thank you for your solution but its not very clear. Could you please confirm the expressions I need to enter.

Thanks

Andrew

Was this reply helpful? Yes No
Vahid Ghafarpour 781 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You can calculate days inside a apply to each loop:

days(diffDays(utcNow(), items('Apply_to_each')?['DueDate']))

And use Condition block to check it

Was this reply helpful? Yes No
David_MA 14,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
What are you having trouble with? Do you not know what a filter query is? If so, you can learn about filter queries at How to Use Power Automate Get Items Filter Query + 8 Examples - Enjoy SharePoint. As for the expressions, what I wrote below is accurate, however, you will need to replace DueDate with the actual internal name of the field in your list, which is something I have no way of knowing.

I am not going to take the time to write an explanation of every detail of the expression, so below is one from Copilot.

Certainly! This filter query in Power Automate is designed to retrieve items from a SharePoint list based on their DueDate field. Here's a breakdown of what each part of the query does:

First Condition:
(DueDate ge addDays(startOfDay(utcNow()), 1) and DueDate lt addDays(startOfDay(utcNow()), 2))

This condition checks if the DueDate is greater than or equal to the start of the day tomorrow and less than the start of the day after tomorrow. Essentially, it filters items that are due tomorrow.

Second Condition:

(DueDate ge addDays(startOfDay(utcNow()), 5) and DueDate lt addDays(startOfDay(utcNow()), 6))

This condition checks if the DueDate is greater than or equal to the start of the day five days from now and less than the start of the day six days from now. This filters items that are due in five days.

Third Condition:

(DueDate ge addDays(startOfDay(utcNow()), 15) and DueDate lt addDays(startOfDay(utcNow()), 16))

This condition checks if the DueDate is greater than or equal to the start of the day fifteen days from now and less than the start of the day sixteen days from now. This filters items that are due in fifteen days.

Fourth Condition:

(DueDate ge addDays(startOfDay(utcNow()), 30) and DueDate lt addDays(startOfDay(utcNow()), 31))

This condition checks if the DueDate is greater than or equal to the start of the day thirty days from now and less than the start of the day thirty-one days from now. This filters items that are due in thirty days.

Summary:
The filter query is designed to retrieve items from the SharePoint list that have DueDate values falling on specific future dates: tomorrow, in five days, in fifteen days, and in thirty days. This can be useful for creating reminders or notifications for upcoming due dates at these intervals.

Was this reply helpful? Yes No
Kalungi A 10 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I'm still experiencing issues configuring email notifications in Power Automate. I've attached a PDF containing screenshots of my current setup. Could someone please take a look and let me know which sections (A, B, C, D) need to be updated to ensure the configuration works properly?

As additional context, I previously used the out-of-the-box template for email notifications, but it seems to be outdated now that I'm working in the 'New Designer' interface.

Where should I add your suggested configuration please?

Thank you in advance.

Andrew

Was this reply helpful? Yes No
David_MA 14,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
What are the issues you are having? It is hard to provide guidance without knowing the problem. Some notes:

A - I would set the hours and minutes that you want the flow to run. Even though they don't show as required, I have seen the flow not trigger if it doesn't know when it is supposed to run.

B - what expression are you using in your addDays() expression. I see you have top count set to 200. This indicates that you may have a large list. If so, be sure that the reviewer outcome date is indexed as that is required for the filters in large lists.

C - I don't see any issues.

D - you can do it this way, but I am not sure since I don know the process. Is there more than one person in hte Person Reporting field? If so, the way you have it set up will send an individual e-mail to each person instead of to everyone in one e-mail.

E - I don't see any issues.

2 people found this reply helpful.

Was this reply helpful? Yes No
Kalungi A 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for the responses. I have made some updates based on your advice. Please see below for the other questions and advice accordingly. Right now I am trying to get at least one notification sent 5 days before due date. Please advice.

A - Updated

B - I have addDays(utcNow(),5) set up in the addDays and reduced the count to 20, I dont have a large list.

C- Thanks

D - Sending email notification to only one person in the Person Reporting field

E - Thanks

Was this reply helpful? Yes No
David_MA 14,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Based on your last post, I am not sure what you are having an issue with and need assistance with. Please explain what you need or what is not working with your flow. Also please include a screen shot of your flow and how you have configured the actions. Since we cannot see your flow, it is hard to diagnosis.

1 people found this reply helpful.

Was this reply helpful? Yes No