Receiving an email alert when a review date is due

(1) Share

Report

Posted on by PB-04020944-0

108

I am looking to set up up an email alert to advise me that a review is due on an item. All of the items are on a Microsoft List and there is a review due date column. How do I set up an alert using Power Automate to tell me a week before the due date, that I need to attend to this? Thanks

Categories:

Building flows

I have the same question (0)

All responses (23)

Answers (0)

Sort by

Haque 3,217 on at

Like (2)

Report
Copy link

Link copied!
Hi @PB-04020944-0,

You can follow these steps:

Fire up a Scheduled cloud flow in Power Automate, please configure to run it daily (or at your preferred frequency).

Retrieve the record, add a Get items action to retrieve all items from the List.

Use a Filter array action to filter items where the review due date is exactly 7 days from the current date. You can build expression with the due date column: expression: addDays(utcNow(),7,'yyyy-MM-dd')

With the filtered item, add a Send an email (V2) action to send yourself a notification about the upcoming review.

Hence, this flow will check daily for items with a review due date one week ahead and send you an alert accordingly.

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,151 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hello @PB-04020944-0,

Yes, you can follow the below steps to achieve this:

#1. Create a scheduled automation that triggers daily.
#2. Add the Get items action and apply a filter on the Due Date column (use the internal column name without spaces).
#3. Add the Send an email action to notify you about items that are due in 7 days..

Filter Query in Get Items Action:

DueDateColumnName eq 'addDays(utcNow(),7,'yyy-MM-dd')' //DueDateColumnName - Replace with your column name - Make sure column name you need to write without space.

You need to write addDays(utcNow(),7,'yyy-MM-dd') in a expression.

This checks for items due exactly 7 days from today.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
PB-04020944-0 108 on at

Like (0)

Report
Copy link

Link copied!

Thank you both. Will give it a go now.

Was this reply helpful? Yes No
PB-04020944-0 108 on at

Like (0)

Report
Copy link

Link copied!

Haque Can you please advise which info I am required to enter at the undernoted stage? Thanks.

Was this reply helpful? Yes No
Haque 3,217 on at

Like (0)

Report
Copy link

Link copied!

Hi @PB-04020944-0

If I understood your question - please fill the From field using the O/P of Get Items and then and then in the "Filter Query" use the addDays(utcNow(),7,'yyyy-MM-dd') expression like this: "ColumnName eq addDays(utcNow(),7,'yyyy-MM-dd')".

Please note that ColumnName is your ReviewDueDate column.

Can you please post me the screenshot of the entire WF if it is not that private?

Was this reply helpful? Yes No
PB-04020944-0 108 on at

Like (0)

Report
Copy link

Link copied!

Hello again Haque is the above correct? Still having issues, I'm afraid.

Thank you.

Was this reply helpful? Yes No
Haque 3,217 on at

Like (1)

Report
Copy link

Link copied!

Hi @PB-04020944-0,

Why are you afraid? Is this something you are receiving error?

I believe correct, just the condition should be Equal (eq) not "is less than or equal to":

Next-6monthly reviewdatecolum eq addDays(utcNow(),7,'yyyy-MM-dd')"

Was this reply helpful? Yes No
PB-04020944-0 108 on at

Like (0)

Report
Copy link

Link copied!

Hello Haque. That is just an English expression meaning "I am sorry to say" meaning "I have bad news".

Still having an error with this....

Was this reply helpful? Yes No
Haque 3,217 on at

Like (1)

Report
Copy link

Link copied!

Can you please post me the error?

Was this reply helpful? Yes No
PB-04020944-0 108 on at

Like (0)

Report
Copy link

Link copied!

Yes, of course, apologies,Haque. It is as follows:-

The input parameter(s) of operation 'Filter_array' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Filter_array'.

Problem summary

This message means that the "Filter array" step in your flow is using a condition that Power Automate doesn't understand. This usually happens if the condition is written incorrectly or uses the wrong format.

To fix this:

1.Click on the "Filter array" step in your flow. 2.Check the condition under "From" and "Where". 3.Make sure you are selecting fields and values using the dynamic content picker, not typing formulas. 4.For date comparisons, use the "Expression" tab to insert functions like addDays(utcNow(),7,'yyyy-MM-dd') correctly. 5.Save and test your flow again.

Was this reply helpful? Yes No