Reminder Workflow Pause for Specific Duration in SharePoint 2013

This article explains how can we use SharePoint Designer to create Reminder workflow on SharePoint List & send email notification to specific user if ReminderDate equals Today's Date.

Workflow

We can create SharePoint workflow using SharePoint Designer as well as Visual Studio.

SharePoint Designer

Using SharePoint Designer, we can Access SharePoint site content like List & Libraries, Workflows, Site Pages, Content Types, Master Pages etc.

Steps:

1. Create SharePoint Custom List - EventReminder List

EventRemainder List

2. List Column

Create list columns Named - EventCreationDate & EventReminderDate

EventCreationDate -

select datetime

EventReminderDate - As per requirement we can create calculated column in List. For Example, i want to send event Reminder after 10 days of created date. so below process is used to create calculated column in SharePoint.

create calculated column in List

EventRemainderDate

For testing purpose, I updated "EventReminderDate " formula, EventReminderDate = EventCreationDate, so both column values are same.

2. Create List Workflow -

Open SharePoint Designer -> Click workflow tab -> you will see options for workflow creation.

Click Workflow

Now click List workflow & select "EventReminder" List for workflow creation.

Click workflow tab

Workflow creation dialog box appears on the screen.

Give appropriate workflow name and select Platform type = SharePoint 2013 Workflow.

EventRemainder

3. Workflow Stages

SharePoint 2013 do not have state machine workflow because of workflow stage concept. Stage act like workflow container. For simplicity, we can divide workflow into stages & do transition form 1 stage to another using Action -> Go to Stage.

Workflow Stages

Let's start by creating our Workflow stages as follow.

creating our Workflow stages

4. Workflow Variables

Create workflow variable Today of type Date/Time.

Workflow Variables

String Builder: We can use String Builder to create string object for user-friendly messages.

String Builder

5. Stage - Workflow Initialization

We can do variable Initialization in this stage.

Workflow Initialization

6. Stage - Reminder Email

At this stage, we first do check like for current list item "Send Reminder " is set to Yes/No. if send Reminder is set to " Yes" then go next. check todays date match with EventReminderDate.

Remainder Email

Notice that we are ignoring time here and matching the only date.

define message

7. Stage - Workflow Finish

Set workflow status here as Finish.

8. Workflow

Workflow

9. Output

workflow history

When new item added to a list, workflow starts automatically as per workflow settings. when date matched it pause for 1 minute & send an email notification to the user.

Email CC field, we can add SharePoint group name also as shown in step 6.