cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resh1
New Member

Creating a flow to generate an email alert 30 days prior to a calculated date in SharePoint

I have a SharePoint List where I record training dates for employees.

I have created a column for each type of training and a calculated column which gives the expiry date of that training

What I want to be able to do is get an email alert 30 days prior to the expiry date to remind me to book the training.

Is this possible?

1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

Hi @Resh1 ,

 

You can schedule a flow that runs everyday, get all items from the list and use a Filter array operator to get the items by checking on this calculated date column. Be aware that the date format need in "yyyy-MM-dd".

 

I made a simple date calculated column in my list:

vjefferni_0-1662540667995.png

vjefferni_1-1662540864090.png

Then I get the only item in the list which matches the criteria.

 

For your case, the expression would be:

formatDateTime(addDays(utcNow(), 30),'yyyy-MM-dd')

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

1 REPLY 1
v-jefferni
Community Support
Community Support

Hi @Resh1 ,

 

You can schedule a flow that runs everyday, get all items from the list and use a Filter array operator to get the items by checking on this calculated date column. Be aware that the date format need in "yyyy-MM-dd".

 

I made a simple date calculated column in my list:

vjefferni_0-1662540667995.png

vjefferni_1-1662540864090.png

Then I get the only item in the list which matches the criteria.

 

For your case, the expression would be:

formatDateTime(addDays(utcNow(), 30),'yyyy-MM-dd')

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,426)