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 include 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.

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 an 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 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 a 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 the Email option and edit the email section in the 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 the 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.

Create a Leave request approval workflow in SharePoint using Out of box workflow

Now, let us see, how to create a leave request approval workflow using SharePoint out-of-box workflow.

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

For designing this workflow, I am going to include 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)

Leave request approval workflow in SharePoint using Out of box workflow

  1. Employee creates a leave request in the SharePoint list.
  2. Request goes to her/his manager for approval.
  3. Manager Approves the request.
  4. Mail is triggered to all stakeholders required. Workflow closes.

Steps for creating a Workflow

Step 1: In this step, I have created a list called “Leave request” in SharePoint Online.

sharepoint leave request approval out of box workflow
sharepoint leave request approval out of box workflow

Step 2: For enabling content approval workflow, we need to follow the below steps.

  • Click the Settings menu and choose the Site settings option.
  • Click the Site collection features link in the Site Collection Administration group on the Site Settings page.
  • Click the Activate button for the Workflows feature.
sharepoint leave request approval workflow
sharepoint leave request approval out of box workflow

Step 3: Next go to the list properties and click on Workflow settings and add a workflow as per the below screenshot.

sharepoint leave request
sharepoint leave request

Step 4: Next choose the Approval- SharePoint 2010 workflow and choose the content type as this List. Next, provide your workflow name and task list where you keep your task. You can give a default task list or you can create your own task list to keep the information.

sharepoint leave request approval workflow
sharepoint leave request approval workflow

Step 5: Next choose the history list. As we know History list default it stored in the Workflow history list but we can also give our own list. Next Start the workflow automatically.

Note: Microsoft will disconnect the link between the task list and history list after 180 days of your workflow start date. As we know much organization they want to keep all information for audit purpose so here it would be better we will keep our task and workflow history in our different list as Microsoft only target to default task and history list which will not be creating any impact to our solution.

sharepoint 2013 leave request workflow
sharepoint 2013 leave request workflow

Step 6: Next provide your manager name whom you need the approval for leave. Next, you can also write the requested email inside the Request field. Next, give the Due date of your task. suppose your manager forget to approve it so SharePoint will remind through email till approval.

If you want to loop your HR in this flow then you can also provide HR email in the CC field. Next to Enable content approval.

sharepoint leave request approval workflow
sharepoint leave request approval workflow

Step 7: Most important things need to do here, before creating workflow we need to enable the Require content approval for submitted item to enable Yes. Otherwise, you will get an error while the workflow complete stage.

sharepoint 2013 leave request form
sharepoint 2013 leave request form

Step 8: Once you click on OK, it will redirect to your workflow settings page where you can able to see your newly created workflow.

sharepoint leave request approval out of box workflow
sharepoint leave request approval out of box workflow

Step 9: Next go to your List and send one new leave request to your manager.

sharepoint leave request approval workflow
sharepoint leave request approval workflow

Step 10: So that one approval request will go to your manager for leave approval.

sharepoint leave request
sharepoint leave request

Step 11: If you check the Workflow health, the status will show you as in progress because your manager not yet approved your leave.

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

Step 12: If your manager trying to approve your leave, then it will appear an Approve or Reject option as below image.

sharepoint 2013 leave request form
sharepoint 2013 leave request form

Step 13: Suppose your manager approved your leave, then you will notify through email.

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

Step 14: Next if you will check the Workflow history then it will show you all steps which has already been done in your Workflow.

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

You can also check the task list which is created after the workflow got approved. This is all about out-of-box leave approval workflow.

You may like the following SharePoint tutorials:

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.

Also, we saw how to create a leave request approval workflow in SharePoint using Out of box workflow.

>