Jul 02 2021 02:51 AM
Hello,
I am looking to set up a formula so that when I enter a date in one column (1), the next column (2) adds a date 3 years in the future.
I then would like a notification email, 1 month before the date in column 2.
Jul 02 2021 04:41 AM - edited Jul 02 2021 04:45 AM
@jonna1973 To answer your first question, create a caclulated column for column 2 with a formula similar to "=DATE(YEAR([Column1])+3,MONTH([Column1]),DAY([Column1]))"
See other formula options at https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b...
For the second part, create a Power Automate Flow the runs daily (reoccurrence) that gets the list items where column 2 equals today PLUS 30 days and set the action on the results to send the email.
Read through the following article for some examples: https://powerusers.microsoft.com/t5/Building-Flows/Trigger-a-flow-on-a-date-value-from-a-Sharepoint-...
Other Reference: https://docs.microsoft.com/en-us/power-automate/run-scheduled-tasks
This should get you started down the right path. If this helps, please consider marking it as the solution. -Don
Jul 05 2021 02:41 AM
Jul 07 2021 12:23 AM