Share via

Power Automate flow which can runs 6 months to send email on 45 days prior to deadline

Audi86 781 Reputation points
2022-06-06T18:35:44.647+00:00

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?

I am suggested to

First flow:

  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

Second flow:

  1. Get Items with a filter criteria given the today date and the notification date
  2. Loop and send the reminders.

Can i get an example flow just to understand my starting point.

Thanks alot

Microsoft 365 and Office | SharePoint | For business | Windows
Accepted answer
  1. Jinwei Li-MSFT 4,736 Reputation points Microsoft External Staff
    2022-06-08T07:36:53.77+00:00

    Hi @Audi86 ,

    You could try to do this.

    Create two columns for test flows.
    209289-image.png

    Add Recurrence and fill in the time zone you want.
    209411-image.png

    Add Update item.
    209384-image.png
    209339-image.png

    Add Update item2.
    209781-image.png

    Add Condition.
    209395-image.png

    Explaination: Here you need to create two Number columns (Num1 and Num2), when you create an item you need to fill "0" into Num1, we use Num1 to count the elapsed days, use Num2 to add 1 day to Num1 everyday so that when it comes to 135 (6 months -45 ), it will send an email.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jinwei Li-MSFT 4,736 Reputation points Microsoft External Staff
    2022-06-13T07:04:37.917+00:00

    Hi @Audi86 ,

    As this is more related to Power Automate, it is not supported in the Q&A forum. I would suggest you to start a new thread in Microsoft Power Automate Community for further help.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.