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!