Power Automate flow which can runs 6 months to send email on 4th month

[Audi86]

Hi,

I am new to power automate and learning it now days to create a requirement for file upload email notification. I am looking for option to create a flow which run for 6 months time period. When a file is uploaded, the flow starts for 6 month due date and on 45 days before due date it will send email to user to send a notification. I came to now that, flow can only be run for 30 days. Any ideas to keep it active for 6 months?

Thanks

[Mira_Ghaly · Accepted solution]

@Audi86 

There is no way to keep the flow active for 6 months, so what you need to do this as 2 separate flows:

1. A flow triggered on file upload to a document library

2. Calculate the notification date using an expression 

3. Save this date calculated from step 2 in a  new  column in your document library

The second flow will be scheduled to run daily:

1. Get Items with a filter criteria given the today date and the notification date

2. Loop and send your reminders

Hope this gives you an idea!

[Audi86]

Thanks for response,

Is there any link or article with almost same requirement you might know of, which I can follow for my reference?

Regards,

[Mira_Ghaly]

@Audi86 

The below video can help you with the reminder

https://youtu.be/bqfLXiEypXM 

[Audi86]

@Mira_Ghaly Looks like I cant use "set a reminder" on calculated columns?