Triggering notification emails from dates in a Sharepoint list

(0) Share

Report

Posted on by CU03101618-0

I have a list of active items with expiration dates and need to automate sending emails to the owners (also in the same list pulling from a person or group) to remind them 30 days before expiration, 7 days before expiration and on the expiration date. I have been struggling with this for a week and none of the copilot recommended flows work. Has anyone been able to accomplish this, and if so, how? Please share and save me from Power Automate insanity! Thank you

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Tomac 2,346 Moderator on at

Like (1)

Report
Triggering notification emails from dates in a Sharepoint list

Recurrence trigger that runs once every day.

SharePoint Get Items action to get all of the relevant items (probably an ODATA filter looking for Expiration date less than today plus 30 days and greater than today).

Filter Array on Expiration Date formatted as yyyy-MM-dd equals today plus 30 days formatted as yyyy-MM-dd

Apply To Each loop on the filtered array

Send An Email action to the relevant person

Filter Array on Expiration Date formatted as yyyy-MM-dd equals today plus 7 days formatted as yyyy-MM-dd

Apply To Each loop on the filtered array

Send An Email action to the relevant person

Filter Array on Expiration Date formatted as yyyy-MM-dd equals today formatted as yyyy-MM-dd

Apply To Each loop on the filtered array

Send An Email action to the relevant person

This flow structure will accomplish your goals.

Was this reply helpful? Yes No