web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Receiving an email ale...

Power Automate

Answered

Receiving an email alert when a review date is due

(1) Share

Report

Report

Posted on by PB-04020944-0

142

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? I am assuming that I will need to add in an email column so that when the flow runs daily, it will pick up on the due date and email the relevant person.

Can you provide me with step-by-step instructions so that I can achieve this using Power Automate? Thank you.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @PB-04020944-0,

If you want to send an email to a specific person, you need to create a ‘Person or Group’ type column to store that person’s details.

Please follow below steps:

#1.Create a scheduled automation in Power Automate, set the frequency to run daily, and select the appropriate time zone so the automation triggers according to that time zone.

#2. Add Get Items (SharePoint) Action and apply filter using Due Date column.

Expression:

addDays(utcNow(),7,'yyyy-MM-dd')

#3. Add a ‘Send an email’ action to send the reminder email. Then select the Email field from the dynamic content panel. Once selected, it will automatically be wrapped inside an ‘Apply to each’ loop

Reference Link:

https://community.powerplatform.com/blogs/post/?postid=cd7eb394-43fd-4050-ad2c-1ad461eaa921

https://www.c-sharpcorner.com/article/send-reminder-email-using-power-automate-flow/

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
Haque 3,653 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @PB-04020944-0,

The steps demonstrated by @Kalathiya is great to work.

I want to add just one point

Ensure Single Email per Line Item: Since the flow runs daily (probably), to avoid duplicate emails, you can add a flag Yes/No or true/false column in your list called "ReminderSent". After sending the email, update the list item to set "ReminderSent" to Yes/True. Modify the filter to only include items where "ReminderSent" is No/False - Adding an an condition in Filter query in step #2

References: PA one email only to all recipients when CAR due date

Was this reply helpful? Yes No

Join the conversation