Power Platform Community Forum Thread Details

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

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.