Send an email notification after 90 days and after this send daily reminders

(0) Share

Report

Posted on by Steph04

Hi! I need help with a flow that sounds easy but I haven´t been able to figure it out since I don't work with Power Automate often.

I have a Status column called "Campo27", I need the flow to wait for the Status Value to turn to "Boss", then when the value in this field is "Boss" I need the flow to wait 90 days to send an email notification to the Boss, after this I would like the flow to send daily reminders to the Boss until the status value changes to "Completed".

Right now the flow is waiting for the 90 days delay, sends the email notification to the boss, and sends only 1 reminder, the flow is not sending the daily reminders until the status value changes to "completed". Please help.

All responses (2)

Answers (1)

Steph04 79 on at

Like (1)

Report

Re: Send an email notification after 90 days and after this send daily reminders

Thank you very much @schwibach , I did what you recommended and works perfectly 🙂
Verified answer

schwibach Super User 2025 Season 1 on at

Like (1)

Report

Re: Send an email notification after 90 days and after this send daily reminders

Flows can only run for 30 days.
I'd recommend using a SharePoint list.
Write the date when the email should be sent in a column.
And having a recurring trigger checking if there is a row with a date older than the current date and then send out the emails.