Create a Leave request approval workflow using Microsoft Flow in SharePoint Online

In this Microsoft Flow tutorial, I will demonstrate how to create a leave request approval workflow using Microsoft flow in SharePoint Online.

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

In my previous post, we discussed how to create a leave request approval workflow using Microsoft SharePoint designer 2013 workflow in SharePoint Online Office 365.

Create a Leave request approval workflow using Microsoft Flow in SharePoint Online

Here we will first create a leave request list where users will submit the leave request in SharePoint Online.

Here first, the Employee creates a leave request in the SharePoint list. The leave request goes to her/his manager for approval. If the Manager Approves the request, an email is triggered to all stakeholders required. And then Workflow closes.

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

microsoft flow leave request
Microsoft flow leave request

Step 2: Next click on Flow in top of the list and create a flow like below:

microsoft flow examples
microsoft flow examples

Step 3: Next, you will get a popup where you have to choose which type of workflow you want. Here we can choose Start approval when new item added.

microsoft flow vacation request
microsoft flow vacation request

Step 4: Make sure you successfully configure outlook and full permission to the site because SharePoint will verify it before creating a new flow. Next click on Continue.

leave request microsoft flow
leave request microsoft flow

Step 5: Next enter your site name where you have already created your list. Once you do connect your site, It will show you all list name inside that site.

leave request flow
leave request flow

Step 6: Next approval will start so we need to configure the assign name and Title of the task.

leave request microsoft flow
leave request microsoft flow

Step 7: Next set the condition if approved else rejected the task based on user input value.

leave request microsoft flow example
leave request microsoft flow example

Step 8: Next add action if task got approved.

microsoft flow leave request
microsoft flow leave request

Step 9: If task got rejected then flow would be like as below image.

request manager approval for leave requests
request manager approval for leave requests

Step 10: The full image of the Microsoft flow would be as below screenshot.

microsoft flow examples
microsoft flow examples

Step 11: Next click on Save to go ahead and test the flow once done. Manager will receive an email if someone will apply for a leave.

leave request microsoft flow
leave request microsoft flow

When manager will click on this link, It will redirect the approval page. Please look into the below screenshot.

Create a Leave request approval workflow using Microsoft Flow in SharePoint Online
Create a Leave request approval workflow using Microsoft Flow in SharePoint Online

Step 12: If your manager approved then the requester will receive an email confirmation.

Create a Leave request approval workflow using Microsoft Flow in SharePoint Online
Create a Leave request approval workflow using Microsoft Flow in SharePoint Online

The same behavior for managers will be rejecting the workflow.

You may like the following Microsoft flow examples:

We can also track the history of the Microsoft flow in the admin page of the flow. This is all about leave approval workflow using Microsoft flow in SharePoint Online.

  • I was hoping you could help me.

    I have a SharePoint list with the following columns:
    Department (Choice): IT, HR, Sales, Finance
    Project Completed (Date)
    Program Completed (Date)

    I want to get an email notification if the following requirements are met.
    If Department equals HR
    Or if Department equals Finance
    And if Project Completed is not equal to null
    Or Program Completed is not equal to null

  • >