SharePoint column dates

%3CLINGO-SUB%20id%3D%22lingo-sub-2510072%22%20slang%3D%22en-US%22%3ESharePoint%20column%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2510072%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20set%20up%20a%20formula%20so%20that%20when%20I%20enter%20a%20date%20in%20one%20column%20(1)%2C%20the%20next%20column%20(2)%20adds%20a%20date%203%20years%20in%20the%20future.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20then%20would%20like%20a%20notification%20email%2C%201%20month%20before%20the%20date%20in%20column%202.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2510072%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2510224%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20column%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2510224%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F961354%22%20target%3D%22_blank%22%3E%40jonna1973%3C%2FA%3E%26nbsp%3BTo%20answer%20your%20first%20question%2C%20create%20a%20caclulated%20column%20for%20column%202%20with%20a%20formula%20similar%20to%20%22%3CSPAN%3E%3DDATE(YEAR(%5BColumn1%5D)%2B3%2CMONTH(%5BColumn1%5D)%2CDAY(%5BColumn1%5D))%3C%2FSPAN%3E%22%3C%2FP%3E%0A%3CP%3ESee%20other%20formula%20options%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fexamples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fexamples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20second%20part%2C%20create%20a%20Power%20Automate%20Flow%20the%20runs%20daily%20(reoccurrence)%20that%20gets%20the%20list%20items%20where%20column%202%20equals%20today%20minus%2030%20and%20set%20the%20action%20on%20the%20results%20to%20send%20the%20email.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERead%20through%20the%20following%20article%20for%20some%20examples%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FTrigger-a-flow-on-a-date-value-from-a-Sharepoint-list%2Ftd-p%2F30305%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Flows%2FTrigger-a-flow-on-a-date-value-from-a-Sharepoint-list%2Ftd-p%2F30305%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOther%20Reference%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-automate%2Frun-scheduled-tasks%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-automate%2Frun-scheduled-tasks%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20should%20get%20you%20started%20down%20the%20right%20path%26gt%3B%20If%20this%20helps%2C%20please%20consider%20marking%20it%20as%20the%20solution.%20-Don%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

3 Replies

@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

 

Hi Don,

thank you for the reponse - I am new to this. Could you provide a step by step process to help? :)
Hi Don,

Managed to get the first part set up - struggling with the 2nd part. Anymore assistance?