Create a Leave Request Approval Workflow using SharePoint Designer 2013

In this SharePoint workflow tutorial, I will demonstrate how to create a leave request approval workflow using SharePoint designer 2013 in SharePoint Online Office 365.

In every organization, there is a need to follow a process to track leave history for employees. So here I am using a workflow to send approval to the manager for taking a leave.

For designing this SharePoint designer workflow, I am going to includes three things here.

  • SharePoint List ( Requesting for leave)
  • Task list ( Create a task for approving or reject)
  • Workflow History List (track all history of the workflow)

SharePoint designer 2013 leave request workflow

Below is how the leave request approval flow will work in SharePoint.

First, an employee creates a leave request in the SharePoint list. Then the request will go to her/his manager for approval. Then if the Manager Approves the leave request, then an Email is triggered to all stakeholders required. Workflow closes.

Steps to create leave request workflow in SharePoint designer 2013

Step 1 : Here I have created a list called “Leave request” in my SharePoint Online site. The list looks like below:

sharepoint designer leave request workflow
SharePoint designer leave request workflow

Step 2: Open SharePoint Designer 2013 and create a list workflow for the same SharePoint Online list.

sharepoint designer 2013 leave request workflow
sharepoint designer 2013 leave request workflow

Step 3: Enter the name of the workflow and choose SharePoint 2013 workflow platform type and click on the OK button to go ahead.

leave request sharepoint designer workflow
leave request sharepoint designer workflow

Step 4: Next it will appear a empty page where you can start designing your SharePoint workflow.

how to create leave request workflow in SharePoint designer 2013
how to create leave request workflow in SharePoint designer 2013

Step 5: In this step, we need to edit the Stage 1 to “Required Manager Approval” and set the approval status to click on the Action menu in a tab.

sharepoint designer leave request approval workflow
sharepoint designer leave request approval workflow

Step 6: Next set the message to “Pending manager approval” in message section in the action.

sharepoint designer 2013 leave request approval workflow
sharepoint designer 2013 leave request approval workflow

Step 7: Next add a log history to track your workflow logs so that we can audit it later.

sharepoint designer leave request workflow
sharepoint designer leave request workflow

Step 8: Next set due date of the approval by using action “Add time and date“.

Create a Leave Request Approval Workflow using SharePoint Designer 2013
Create a Leave Request Approval Workflow using SharePoint Designer 2013

Step 9: Create a workflow variable Due Date and add an action in order to add 5 days from the current date to the due date.

sharepoint online leave request workflow
sharepoint online leave request workflow

Step 10: Create a task where we will assign a task to specific person for approval.

sharepoint online leave request approval workflow
sharepoint online leave request approval workflow

Step 11: Click the current item in the steps and add the manager name to approve the task in participant section.

SharePoint designer 2013 leave request workflow
SharePoint designer 2013 leave request workflow

Step 12: Next click on task title to add the request name as below screenshot.

sharepoint designer leave request workflow
sharepoint designer leave request workflow

Step 13:in description section add the details as per below image.

sharepoint designer 2013 leave request workflow
sharepoint designer 2013 leave request workflow

Step 14: Add the due date of task which we have set in previous step.

leave request sharepoint designer 2013 workflow
leave request sharepoint designer workflow

Step 15: Next go to Email option and edit the email section in task creation section.

how to create leave request workflow in SharePoint designer 2013
how to create leave request workflow in SharePoint designer 2013

Step 16:Next click on OK to go next step.

how to create leave request workflow in SharePoint designer 2013
how to create leave request workflow in SharePoint designer 2013

Step 17: Add a condition in the next step, check if outcome of the task is Approved or Rejected.

create leave request workflow in SharePoint online
create leave request workflow in SharePoint Online

Step 18: Net Set the workflow variable and value as approved in the step.

create leave request workflow in SharePoint
create leave request workflow in SharePoint

Step 19: Next log to the history list after task got approved and set the workflow status as approved and send an email to user as your leave is approved.

create leave request workflow using sharepoint designer 2013
create leave request workflow using sharepoint designer 2013

Step 20: Set the condition if your leave get rejected by your manager.

create leave request workflow using sharepoint designer
create leave request workflow using sharepoint designer

Step 21: Next end the workflow and publish it .

sharepoint designer leave request approval workflow
sharepoint designer leave request approval workflow

Step 22: Now the workflow is complete, click on the save button and then click on Publish.

sharepoint designer 2013 leave request approval workflow
sharepoint designer 2013 leave request approval workflow

You can get task list in Assign task list and by default history will save in Workflow history list but we can able to change the task list name and history list.

Step 23: Here I send an request myself as a manager and I got an email for approval.

sharepoint designer 2013 leave request approval workflow
sharepoint designer 2013 leave request approval workflow

Step 24: When the manager clicks on the link, the task will open where the manager can Approve or Reject the leave request.

sharepoint 2016 leave request approval workflow
sharepoint 2016 leave request approval workflow

Step 25: Once the user will click on the Approve button, Requester will get an approved email. The same for task rejection.

sharepoint 2013 leave request approval workflow
sharepoint 2013 leave request approval workflow

Step 26: you can also find the task details and workflow history details in below image.

sharepoint online leave request approval workflow
sharepoint online leave request approval workflow

Now the SharePoint Leave request approval workflow is ready. Then you can deploy SharePoint designer workflow to other production sites.

You may like following SharePoint designer 2013 workflow:

Hope this SharePoint designer workflow explains how to create a leave request approval workflow using SharePoint designer in SharePoint Online or SharePoint 2013/2016/2019.

free sharepoint training

SharePoint Online FREE Training

JOIN a FREE SharePoint Video Course (3 Part Video Series)

envelope
envelope

Rajkiran Swain

Rajkiran is currently working as a SharePoint Consultant in QATAR . Rajkiran having 6 + years of experience in Microsoft Technologies such as SharePoint 2019/2016/2013/2010, MOSS 2007,WSS 3.0, Migration, Asp.Net, C#.Net, Sql Server, Ajax, jQuery etc.He is C#Corner MVP (2 Times).

>