Announcements
Hi,
One of the best ways to do this is at the bottom of your current flow is write the email address and the time (6-10 days) to a SharePoint list with the status. So your list will have at least 3 columms: email, status, sendemaildate.
You can calculate the sendemaildate (6 to 10 days) by using the addDays() expression to get your desired future date.
In a separate flow, you have a scheduled flow the runs every morning at 5 AM. It simply checks if the item sendemaildate is equal to today's date, if true, send 'in progress email'.
This is one easy-to-implement approach. So I like to break up the flows into specific actions, your first flow creates the task and sends the acknowledgement. The 2nd flow sends the follow-up email on a daily schedule.
You could even implement a 3rd flow for the completion email, when the status is changed to completed, it sends your completed task email. This flow could run using the trigger when an item is changed (with a trigger that only fires when the status is 'completed').
I hope that helps you keep going!
------------------------------------------------
⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!
Always glad to help! 💯💯💯💯💯
Tom
Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn
WarrenBelz
146,508
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,442
Most Valuable Professional