Reminder emails: Add to an existing triggered email flow, or start a new flow?

[OneWinPlease]

I have an existing simple flow that triggers an email when a SharePoint list item's status has been modified. The email goes out instantly when one of my team changes the item status from New to Waiting. Once my team gets what they are waiting for, the internal staff changes status to Complete.

I would like to send reminder emails one and two weeks later. I tried a parallel branch flow with two delays after the first triggered email. It seemed to work in testing, but when I had to change the connected data source (a new but identical SP list), the reminders continued even after status was changed to Closed.  I'm not sure what went awry. I have some ideas but really, I'm thinking this was not a good flow. So I'm checking my thinking here. Should I amend my simple, initial flow to add the follow up reminders and if so, how? Or, should I create a new flow just for the reminders, and if so, how do I make it understand the date the item's status originally changed to Waiting? 

[creativeopinion]

@OneWinPlease Instead of a delay, I would recommend creating a flow with a recurrence trigger so you can set how often it runs. It should then check the date the initial email was sent and send a reminder one and two weeks later. 

You may find these YT Tutorials linked below helpful. If you run into any issues after reviewing these tutorials and still need help—post screenshots of your flow. If you are using the New Designer ensure that you've toggled it off and click on each action to expand it. Upload a screenshot of your full flow in edit mode.

How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate.

I’ll cover some common use cases and concepts that can help you to build better Power Automate flows. Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

IN THIS VIDEO:

✅ 4 Date Functions You Need to Know

✅ How to use the Convert Time Zone Action

✅ How to Get a Future Date

✅ How to Get a Past Date

✅ How to Return SharePoint Items Due in a Number of Days

✅ How to Return SharePoint Items Due within a Date Range

✅ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days

✅ How to Calculate the Number of Days between Two Dates

✅ How to Check for a Birthdate and Anniversary Date

✅ How to work with Dates and Times in Excel

✅ How to use a Manual Trigger with Date Input

✅ How to Output Dynamic Text with an Expression

✅ How to Check if a Date Falls on a Weekend

----

Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate

In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.

This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:

📅 Student Birthdays

📅 Project Due Dates

📅 Contract/Membership Renewals

📅 License Expirations

📅 Client Anniversaries

---

IN THIS VIDEO:

✅ How to Send an Email based on a Date Column in SharePoint

✅ Using the Recurrence Trigger in Power Automate

✅How to Use the Filter Array Action with multiple conditions

✅ How to Get Dynamic Content from a Filter Array Action

✅How to Get a Date Three Days from Today

✅ How to Create a Dynamic Date Based on utcNow()

✅ How to Return a Count of Items

✅ How to initialize and set a variable

✅ How to use the Send an Email (V2) action

✅ How to send test emails

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

[FLMike]

Hi @OneWinPlease 

I really recommend that you use a separate flow. Have it trigger every day.

Have it do a Get Items and filter on whatever you can to only get the ones you want to remind on.

Then you can calculate how many days has passed since your first triggered instant email.

and if, the MOD of those days / 2 is 0 then you know its another 2 days later and send another reminder.

You should however also take into account weekends and possibly holidays so you dont spam them on those days.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[OneWinPlease]

@FLMike  - thanks, I'm not sure what you mean by "if the MOD of those days / 2 is 0 then you know its another 2 days later"?