Sending weekly reminder sharepoint designer workflow

Padmanabhan, Venkatesh 241 Reputation points
2021-08-01T11:49:57.893+00:00

Hi.

I am trying to create a weekly reminder email using sharepoint list and designer workflow. I have tried using this : https://threewill.com/sending-reminder-emails-using-sharepoint-designer-workflows

I have created both the lists as mentioned in the site. For the column in listA- the "NextReminderTime" column has the forumla
as :

=DATE(YEAR(LastReminderTime),IF(DAY(LastReminderTime)>6,MONTH(LastReminderTime)+1,MONTH(LastReminderTime)),7)

I want this workflow to be trigerred on every monday.
LastReminderTime in List A has - 7/26/2021

NextReminderTime in List A is showing as : 8/7/2021

The NextReminderTime should be 8/1/2021 . what should be fixed in the calculated column?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
23,844 questions
No comments
{count} votes

Accepted answer
  1. JoyZ 17,901 Reputation points
    2021-08-02T07:44:33.43+00:00

    @Padmanabhan, Venkatesh ,

    Change the calcualted column as shown below:

    IF(WEEKDAY(LastReminderTime)<2,LastReminderTime+(2-WEEKDAY(LastReminderTime)),LastReminderTime+9-WEEKDAY(LastReminderTime))  
    

    My test result for your reference:

    119749-image.png


    If an Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful