SharePoint Training- How to create a Time Off Approval Workflow using Microsoft Flow

Microsoft flow, is the new service provided by Microsoft. Flow is basically a type of trigger That we can associate with the objects (SharePoint List/Library, Google Sheets, Twitter, Salesforce and many more). There are certain pre-defined templates that are ready to use. We can just configure that templates and they are ready to go, with less efforts and less development time. In the context of SharePoint, if we need to apply a basic trigger on creation of new item in the list. We can either go for SharePoint Designer Workflow or Microsoft Flow, the major advantage of Microsoft flow over SharePoint Designer workflow: 1. We do not need any designer to be installed on the system. 2. Microsoft flow, provides a console/dashboard where it shows, the no of success/failure instances of flow. 3. In SharePoint Designer, we have options limited to the SharePoint. But Microsoft Flow, provides a variety of options, we can interact with different services it provides. In this example, we are going to create a simple Time Off Approval flow, whenever a new item has been created in the SharePoint list, it will send the approver email to the approver, from where he can either approve/reject the request and then the response will be provided to the requestor. Below are the main steps for creating the Microsoft Flow: 1. Logged in with your office 365 account on 2. Select the template “When a new item is created” (SharePoint List). 3. In the next window, authenticate with SharePoint. 4. Configure the Site URL, List name. 5. Add a new action “Office 365 - Send Approver Email”. 6. Configure the Action with the “Subject, User Options, Approver Email & Body”. This action will send a mail to approver with the “Approve/Reject” options. 7. Add a new condition action, Select the “Selected Option” data element from the previous approver step. 8. Based on the “Selection Option” value either Yes/No, send an email to the requestor and update the list item. Please visit for free consulting & support on SharePoint development projects.

Video Owner : Paragyte