{"id":5391,"date":"2019-09-02T07:37:18","date_gmt":"2019-09-02T07:37:18","guid":{"rendered":"https:\/\/www.softreetechnology.com\/?p=5391"},"modified":"2019-09-02T07:37:18","modified_gmt":"2019-09-02T07:37:18","slug":"leave-approval-app-using-powerapps-and-microsoft-flow","status":"publish","type":"post","link":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/","title":{"rendered":"Leave Approval App Using PowerApps And Microsoft Flow"},"content":{"rendered":"\n<p>\n\nIn this blog, I will discuss how to create a leave request approval app using PowerApps and Flow in office365. I have created a generic\/custom list in office365 named &#8220;Leave Request&#8221; which contains the columns mentioned below.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Description Multiple lines of text<\/li><li>Leave Type Choice<\/li><li>Leave Status Single line of text<\/li><li>Email Single line of text<\/li><\/ul>\n\n\n\n<p>From these Email and Leave Type columns are required field.&nbsp;Now we will discuss how to create an app using PowerApps Studio and an approval process using Flow. The Leave Status column will be updated as Approved or Rejected after the completion of the approval process by the approver also an email of the leave status will be sent to the mentioned email in the email column.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Create an app for Office365 Custom List using PowerApps<\/h4>\n\n\n\n<p>&nbsp;In this section, we will discuss how to create an app for our office 365 custom list using PowerApps.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>We will navigate to the custom list (Leave Request) in Office365 site. For example,&nbsp;<em>https:\/\/softreetechnology.sharepoint.com\/Lists\/Leave%20Request\/AllItems.aspx<br><\/em><\/li><li>We will click PowerApps and then click &#8220;Create an app&#8221;.<\/li><li>We will enter the app name and then click &#8220;Create&#8221;.<\/li><li>By default, the generated app contains Browse, Detail, and Edit screen. We will Navigate to the Edit screen, select Leave status card and then select a visible property in the property box. Set visible property value to false in the formula bar so that &#8220;Leave Status&#8221; field will not be shown to users.<\/li><li>Save and publish the app.<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\">Create the leave approval process using Flow<\/h4>\n\n\n\n<p>\u00a0In this section, we will discuss how to create the leave approval process using Flow.\u00a0<\/p>\n\n\n\n<p>Navigate to the custom list (Leave Request) in SharePoint Online site. For example,<em> https:\/\/softreetechnology.sharepoint.com\/Lists\/Leave%20Request\/AllItems.aspx<\/em>\u00a0<\/p>\n\n\n\n<p> <\/p>\n\n\n\n<p>We will Click Flow and then click Create a flow.<\/p>\n\n\n\n<p>We will Click See more templates.<\/p>\n\n\n\n<p>We will Search for SharePoint and select SharePoint \u2013 When an item is created.<\/p>\n\n\n\n<p>We will Enter the URL and select the list name from drop down. Click New Step.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2019\/09\/1.jpg\" alt=\"\" class=\"wp-image-5392\"\/><\/figure><\/div>\n\n\n\n<p>\n\nWe will Click New Step and then click Add an action.<\/p>\n\n\n\n<p>We will Search for Start and wait for the approval. Then assign any user email from the organization and also provide the item link and item description.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2019\/09\/2.jpg\" alt=\"\" class=\"wp-image-5393\"\/><\/figure><\/div>\n\n\n\n<p> Then we will Click Next step and then click Add a Condition according to the response from the approver. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2019\/09\/3.jpg\" alt=\"\" class=\"wp-image-5394\"\/><\/figure><\/div>\n\n\n\n<p> If yes then we will send the leave status and the message to the user who applied for leave and also updates the leave status field in the leave request list.\u00a0 <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2019\/09\/4-1024x316.jpg\" alt=\"\" class=\"wp-image-5395\"\/><\/figure><\/div>\n\n\n\n<p> For the above step, we will select Office 365 Outlook \u2013 email.\u00a0<\/p>\n\n\n\n<p>We will Fill in all the required details.<br>We will add an action to update the Status field to Approved.<br>We will Search for Update Item and then select SharePoint \u2013 Update item. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2019\/09\/5-1024x463.jpg\" alt=\"\" class=\"wp-image-5396\"\/><\/figure><\/div>\n\n\n\n<p>\n\nIf the condition is not satisfied, add an action to update the Status field value to Rejected.&nbsp;Enter the name for the flow and click Create flow.&nbsp;Flow created successfully. Click Done.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Testing the app and leave approval process<\/h3>\n\n\n\n<p>\u00a0Open the Leave Request App which we have created <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.softreetechnology.com\/wp-content\/uploads\/2019\/09\/6-1024x576.jpg\" alt=\"\" class=\"wp-image-5397\"\/><\/figure><\/div>\n\n\n\n<p>\n\nClick \u201c+\u201d icon to create new item.&nbsp;Enter the details and click tick icon.&nbsp;Item is created successfully. Approver (I have added myself) will receive an email to approve or reject in Office 365 Outlook.&nbsp;Click &#8220;Approve&#8221;.&nbsp;Navigate to list and you could see the Status field got updated to Approved.&nbsp;You can log in to the email given by the user and able to see the status of the leave in the email.&nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Result<\/h4>\n\n\n\n<p>\u00a0In this article, we saw how to create a leave request form app using PowerApps and also an approval flow using Microsoft Flow in Office 365. <\/p>\n\n\n\n<p><strong>This solution is brought to you by our SharePoint professionals.<\/strong><\/p>\n\n\n\n<p><strong><a href=\"https:\/\/www.softreetechnology.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Softree Technology<\/a><\/strong>&nbsp;employs SharePoint consultants; we are a technology services provider with the aim to help companies achieve exceptional performance through SharePoint. Our dedicated team of SharePoint consultants has the right bent of mind to understand and execute customer requirements.<\/p>\n\n\n\n<p>Be it SPFx or SharePoint add-in developments,&nbsp;<strong><a href=\"https:\/\/www.softreetechnology.com\/sharepoint-2019-developments\/\" target=\"_blank\" rel=\"noreferrer noopener\">SharePoint 2019 developments<\/a><\/strong>, web part developments, migrating from SharePoint 2010\/2013 to SharePoint 2013\/2016\/Office 365, Office 365, SharePoint hosted apps development or something else in SharePoint, we strive to deliver the best<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, I will discuss how to create a leave request approval app using PowerApps and Flow in office365. I have created a generic\/custom list in office365 named &#8220;Leave Request&#8221; which contains the columns mentioned below. Description Multiple lines of text Leave Type Choice Leave Status Single line of text Email Single line of text From these Email and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5399,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[306],"tags":[302,303,304,305,168],"class_list":["post-5391","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powerapps","tag-beginners-in-microsoft-flow","tag-how-to-create-microsoft-flow","tag-leave-approval-microsoft-flow","tag-leave-approval-using-power-apps","tag-office-365"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Leave Approval App Using PowerApps And Microsoft Flow - Softree Technology<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Leave Approval App Using PowerApps And Microsoft Flow - Softree Technology\" \/>\n<meta property=\"og:description\" content=\"In this blog, I will discuss how to create a leave request approval app using PowerApps and Flow in office365. I have created a generic\/custom list in office365 named &#8220;Leave Request&#8221; which contains the columns mentioned below. Description Multiple lines of text Leave Type Choice Leave Status Single line of text Email Single line of text From these Email and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/\" \/>\n<meta property=\"og:site_name\" content=\"Softree Technology\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-02T07:37:18+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Leave Approval App Using PowerApps And Microsoft Flow - Softree Technology","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/","og_locale":"en_US","og_type":"article","og_title":"Leave Approval App Using PowerApps And Microsoft Flow - Softree Technology","og_description":"In this blog, I will discuss how to create a leave request approval app using PowerApps and Flow in office365. I have created a generic\/custom list in office365 named &#8220;Leave Request&#8221; which contains the columns mentioned below. Description Multiple lines of text Leave Type Choice Leave Status Single line of text Email Single line of text From these Email and [&hellip;]","og_url":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/","og_site_name":"Softree Technology","article_published_time":"2019-09-02T07:37:18+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/#article","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/"},"author":{"name":"admin","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b"},"headline":"Leave Approval App Using PowerApps And Microsoft Flow","datePublished":"2019-09-02T07:37:18+00:00","mainEntityOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/"},"wordCount":724,"commentCount":0,"publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/#primaryimage"},"thumbnailUrl":"","keywords":["Beginners in Microsoft Flow","How to create Microsoft Flow","Leave Approval Microsoft Flow","Leave approval using Power Apps","office 365"],"articleSection":["PowerApps"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/","url":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/","name":"Leave Approval App Using PowerApps And Microsoft Flow - Softree Technology","isPartOf":{"@id":"https:\/\/softreetechnology.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/#primaryimage"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/#primaryimage"},"thumbnailUrl":"","datePublished":"2019-09-02T07:37:18+00:00","breadcrumb":{"@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/softreetechnology.com\/blog\/powerapps\/leave-approval-app-using-powerapps-and-microsoft-flow\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/softreetechnology.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Leave Approval App Using PowerApps And Microsoft Flow"}]},{"@type":"WebSite","@id":"https:\/\/softreetechnology.com\/blog\/#website","url":"https:\/\/softreetechnology.com\/blog\/","name":"Softree Technology","description":"Celebrating 10+ Years in SharePoint Consulting !","publisher":{"@id":"https:\/\/softreetechnology.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/softreetechnology.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/softreetechnology.com\/blog\/#organization","name":"Softree Technology","url":"https:\/\/softreetechnology.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","contentUrl":"https:\/\/softreetechnology.com\/blog\/wp-content\/uploads\/2023\/03\/cropped-white-logo-soft.png","width":844,"height":230,"caption":"Softree Technology"},"image":{"@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/98740297642f06debccdcee2de84086b","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/softreetechnology.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fc78c8a7aa3fb0bf43c3b9a2e3962d7?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/softreeconsulting.com"],"url":"https:\/\/softreetechnology.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/5391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/comments?post=5391"}],"version-history":[{"count":0,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/posts\/5391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/media?parent=5391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/categories?post=5391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/softreetechnology.com\/blog\/wp-json\/wp\/v2\/tags?post=5391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}