Need to send Email on the basis of Last modified date in SP list

(0) Share

Report

Posted on by rsinha

Hi Folks,

We have a SP list where we are defining tasks. Following are the columns in that list.

Task Name

Task Owner

Task Status

Last Updated Date

I have a requirement where an email needs to be triggered to task owner (Person type) exactly after 30 days of Last Updated Date, and then every 15 days until Task status value is "Completed".

Can anyone help me to achieve this, what will be the triggering point of that flow and how I'll achieve to send an email every 15 days after first email gets sent.

Thank you in advance!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can build a flow that runs every day and looks for items that have been updated 30 days back, or multiple of 15 there after. You could tweak this one.

Powering your Apps - Sending reminder emails 30, 60, 90 days before expiration (sudeepghatak.com)

Was this reply helpful? Yes No
rsinha 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @SudeepGhatakNZ
Thank you for sharing the solution. But my issue is little bit different here. On the basis of Task status, flow should send the first email after 30 days of Last updated date, and in every 15 days until Tasks status is not Completed. It's not hard coded that I can use today's date in a variable and define other variables on the basis of utcnow().

Was this reply helpful? Yes No
rsinha 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Folks,
Can anyone help me on how to setup email reminders in every 15 days.
First email will be sent after 30 days of Last action date (which I have already setup), and email reminders after every 15 days until that task status in Completed.

Thank you!

Was this reply helpful? Yes No