Hi @Danny,
Welcome to the Microsoft Q&A forum.
Thank you very much for reaching out regarding the Outlook rule you set up to notify you when a renewal date is approaching. I appreciate your patience and the details you provided.
To clarify, Outlook rules only trigger on messages that arrive or are sent not on future dates and desktop alerts are client‑side (requiring Outlook to be open and not suppressed by Focus Assist/Do Not Disturb), a rule will only fire when an incoming message precisely matches your specified conditions (e.g., Subject/Body/From); otherwise, it won’t run.
Recommended approach for date‑based reminders, you may choose the option that fits best:
1/ Calendar event + reminder (Classic Outlook)
- You can drag the email from Inbox and drop it into the Calendar section (bottom-left).
- Fill in the title and renewal date, set a reminder X days before.
- Click Save & Close.
More info here: Add or delete notifications or reminders in Outlook - Microsoft Support
2/ Task / Microsoft To Do + due date
Option A - Flag an email
When you flag an email in Outlook (Classic or New), it syncs to Microsoft To Do and appears as a task with the email subject as the task title.
You can open the task to view the email preview, add notes, set reminders, assign a due date, or move it to another list.
Option B - Create a manual task
If you prefer creating a task yourself
- Add a new task in Microsoft To Do, name it “Renewal - <contract>,”
- Set the due date to the renewal date and add a reminder a certain number of days before.
- You can also add subtasks, repeat settings, or attach related documents.
Notifications sync across devices if To Do notifications are enabled.
More info here: Using Microsoft To Do with flagged email from Outlook - Microsoft Support
3/ Power Automate (Optional)
If your renewal dates are stored in email, Excel, or SharePoint, you can build an automated flow that runs daily, checks which items are within N days of their renewal date, and then automatically sends a reminder email, creates a task, or updates a list.
This method does not rely on new messages arriving and is useful when managing a large number of renewals or when reminders need to be sent to multiple people.
In case you require more in-depth guidance or support for these steps, I’d recommend posting your query in the Microsoft Power Automate Community. This is a dedicated channel for Power Automate discussions. The reason I suggest posting a new topic there is that in the general Q&A Forum, resources and expertise on Power Automate are limited. In the Microsoft Power Platform Community Forum, you’ll find the most qualified group of respondents, and other partners who regularly read the forums can share their knowledge or learn from your interaction.
I hope this information is helpful. Should you have any further questions or need additional assistance, feel free to reach out.
Thank you again for your understanding and cooperation.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".
Note: Follow the steps in our documentation to enable email notifications if you want to receive email notifications related to this topic.