Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

"Delay Until" functionality question & workaround request

(2) ShareShare
ReportReport
Posted on by 5
Hello Microsoft Power Platform Users,
 
I have a request for guidance. The end goal of this power automate flow is for any time there is an entry on a MS list, collect that information and send an email.
 
The complexity of my request comes from the fact that I want to delay sending this email based on the user response, AND the the fact that these will be notifications in 1+ year. It is my understanding that the "delay until" function has a capacity of 28 days (*PLEASE CORRECT ME IF I AM WRONG*), but the time lengths laid out in this automation will exceed that value. Essentially we are automating contract renewal notification. 
 
Currently, I have a trigger for when an item is added to the list (a user uploads the vendor name, the contract renewal date, and how long the contract is valid for)
Following that, I have an approval request, where the owner of the process (me for now) will click "approve" or "deny", and by clicking approve, the next part of the automation runs. This is just a quality check step / a notification to the process owner, and to prevent instances where we have an evergreen / no renewal contract and the contract owner gets blasted by notification emails
 
After approval, there are some branches off of the process.
 
I have a calculated column created in the MS list that take the (user generated) contract renewal date and adds the length of the contract (as described as the user who completes the entry.) For example, +365 if the renewal period is annual, +730 if the renewal period is every 2 years), etc. This value is called "Contract Renewal Date"
 
I have 6 columns that take the previously calculated "Contract Renewal Date" and subtract X number of days from it (i.e. 60 days before the contract is due, sending a notification that says that), with the logic being that by having the email notification occur after this delay until action, the email(s) will be sent in relation to the contract renewal date, giving the contract owner adequate time to prepare negotiations and ensuring none of them slip thru the cracks.
 
Please help me by either denying my understanding of how the "delay until" function works, or providing a workaround. I am grateful for your help!
  • FLMike Profile Picture
    FLMike 31,242 on at
    "Delay Until" functionality question & workaround request
    Hi,
     
    You didn't say what the problem was. You laid it all out nicely, but what is the issue?
     
    Please explain the problem you need help with.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard