web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Creating a flow to gen...

Power Automate

Answered

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

(0) Share

Report

Report

Posted on by Resh1

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?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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:

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,

Was this reply helpful? Yes No

Join the conversation