Send reminder email after 1 year

SR VSP 1,231 Reputation points
2020-08-25T06:41:10.397+00:00

Hi Guys,

I've a SP lib. I need to send a reminder email to the owner based on the "Review Date" When an item is created with document review schedule as "Annual" it will add 365 days to the Released date and update review date column field.

Ex: If schedule is Annual the owner should get an email 14 days before the review date. And another email 10 days before the review date.
(Similarly for Every2Years . )

Please advise.

20105-sharepoint.jpg

20125-flow.jpg

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,211 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Itch Sun-MSFT 2,556 Reputation points
    2020-08-26T09:16:02.567+00:00

    Based on your description, I recommend that you first determine whether the schedule belongs to the "Annual" or "Every2Years".

    Then we delay the operation of flow, and if it belongs to Every2Years, then flow will delay sending mail for 716 days (send an email 14 days before the review date), and then delay sending a second message for 4 days(send an email 10 days before the review date).

    If it belongs to Annual, flow will delay sending the email by 351 days and then send the second email 4 days later.

    For specific steps you can view the screenshot below:

    20476-capture.png

    20531-capture2.png

    If the response is helpful, please click "Accept Answer" and upvote it. 😊

    0 comments No comments

  2. SR VSP 1,231 Reputation points
    2020-08-30T05:13:41.787+00:00

    Thanks for your response. You cannot delay a flow for 716 days. Single flow is active till 30 days only.

    I figured out using a recurrence procedure.