web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Use Power Automate to ...
Power Automate
Suggested Answer

Use Power Automate to "Send an Email to myself based on Due Date"

(1) ShareShare
ReportReport
Posted on by CU07052008-0 2
Hello All,
 
Can someone help me with sending an email to myself one (1) week before the Due Date, meaning dates are in this Due Date column and when its one week before that date, I want an email sent.
 
Thanks in advance!
Dani
Categories:
Building flows
I have the same question (0)
  • WillPage Profile Picture
    WillPage 2,339 Super User 2026 Season 1 on at
    If you due date column is date only (not date and time), and assuming its SharePoint and the internal column name is DueDate (it could be Due_x0020_Date if you added it in the list settings rather than modern view) then you need to do a Get items with a filter condition like DueDate eq '2026-05-15'

    Obviously hardcoding a date like that will only work for one day, so replace it with an expression such as addDays(utcNow(),7,'yyyy-MM-dd').

    Run the flow every day and the Get items will only show the rows with the due date 7 days in the future (of UTC). If you're significantly far from UTC then add or subtract an extra day - you don't need to be super accurate for something like a reminder email.

    Then after the Get items, just do an Apply to each loop with an email action inside addressed to yourself with whatever dynamic content from the SharePoint list you need in the email subject or body.
     
    A word of advice - don't be scared to get stuck in and try stuff - google what you want to do, watch videos etc then ask specific questions about things you're stuck on. A lot of people don't like to respond when the question is basically asking for the whole solution.
  • Suggested answer
    sumit_artesian Profile Picture
    sumit_artesian 261 on at
     
    I am assuming your Due Date column is in SharePoint. But even if they are somewhere else, the underlying approach would still be the same.
     
    This is how you can set up the flow:
    • Create a flow with a recurring trigger. You can configure it to run every day at a specific time. This will ensure your flow runs every day.
    • Fetch your items. If your data is in SharePoint, use the Get Items action of the SharePoint connector. There are similar actions for other connectors like Dataverse, QuickBooks, etc. You need to fetch your data on the Due Date column.
    • Add a filter to only fetch records where the due date is in 7 days. You can add an OData filter like: DueDate eq @{addDays(utcNow(), 7)}
    • Optionally, I would suggest formatting the Due Date data returned to get a consistent result every time. You can format it using this expression: formatDateTime(<your-Due-Date-column-value>, 'yyyy-MM-dd')
    • Finally, add an Apply to Each action and add a Send an Email action from the Outlook connector to send a reminder email to yourself.
     
    Let me know if you face any issues, I will try to elaborate with example screenshots.
     
    Please âœ… Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item.
    If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like! 🩷

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans