Member - Blog

Leave Approval App Using PowerApps And Microsoft Flow

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 “Leave Request” which contains the columns mentioned below.

  • Leave Type Choice
  • Leave Status Single line of text
  • Email Single line of text

From these Email and Leave Type columns are required field. 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. 

Create an app for Office365 Custom List using PowerApps

 In this section, we will discuss how to create an app for our office 365 custom list using PowerApps.

  • We will navigate to the custom list (Leave Request) in Office365 site. For example, https://softreetechnology.sharepoint.com/Lists/Leave%20Request/AllItems.aspx
  • We will click PowerApps and then click “Create an app”.
  • We will enter the app name and then click “Create”.
  • 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 “Leave Status” field will not be shown to users.
  • Save and publish the app.

Create the leave approval process using Flow

 In this section, we will discuss how to create the leave approval process using Flow. 

Navigate to the custom list (Leave Request) in SharePoint Online site. For example, https://softreetechnology.sharepoint.com/Lists/Leave%20Request/AllItems.aspx 

  1. We will Click Flow and then click Create a flow.
  2. We will Click See more templates.
  3. We will Search for SharePoint and select SharePoint – When an item is created.
  4. We will Enter the URL and select the list name from drop down. Click New Step.

We will Click New Step and then click Add an action.

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.

Then we will Click Next step and then click Add a Condition according to the response from the approver.

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. 

For the above step, we will select Office 365 Outlook – email. 

We will Fill in all the required details.
We will add an action to update the Status field to Approved.
We will Search for Update Item and then select SharePoint – Update item.

If the condition is not satisfied, add an action to update the Status field value to Rejected. Enter the name for the flow and click Create flow. Flow created successfully. Click Done. 

Testing the app and leave approval process

 Open the Leave Request App which we have created

Click the “+” icon to create a new item. Enter the details and click the tick icon. Item is created successfully. Approver (I have added myself) will receive an email to approve or reject in Office 365 Outlook. Click “Approve”. Navigate to list and you could see the Status field got updated to Approved. You can log in to the email given by the user and able to see the status of the leave in the email. 

Result

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

  • Oct 24, 2019
Become a Member to post Articles

Comments - 0

Share Your Thoughts

Verify you're Human*

Just check on this box below to verify

Search In blog :

Categories :

Education Services (Schools, Tutors) (44)

Tips For Students To Improve Their Writing This Semester

Benefits of Smart Cities

Best Event Management Institutes Mumbai

You're Losing Grades by Not Using Essay Assistance

4 Tips To Make Yourself Prince2 Certification Ready

5 Skills To Be Pinned In Your DevOps-Engineer Journal

Kindergarten Readiness - What Teachers Can Do

A Sneak Peak To The Learning Carnival - Get Latest Technology Insights

NEET 2020 Exam Details

How to Make Your Students Listen to You

Advance Your Career with an Early Childhood Education Certification

6 Main Differences Between IGCSE And CBSE

What Can You Expect For NEET 2020?

A Guide To Online Learning During The COVID 19 Pandemic

NEET Chapter Wise Weightage For Subjects

Why Is Social Development an Important Part of Early Education?

New JEE And NEET Dates For 2020

Effective ‘Learn From Home’ During The Corona Crisis

Ways to Keep Your Little One Engaged at Home

Sports – An Integral Part of School Life

How to Effectively Home School your children during the Covid-19 Pandemic

Boarding School – Why It Is the Best Option

Simple Strategies to Help You Improve Your Exam Scores

Why ICSE Could Be the Right Option for Your Child

Career Options After an Early Education Program

Online Schooling: A Perspective In The Current Scenario

What Are Your Career Options in the Early Education Field?

Top 10 IBDP Terms Parents Need To Know

Child Care Center Director - Qualification and Responsibilities

How To Stay Focused During The AP Exams 2021

Tips for Effective Online Learning

Are SAT Subject Tests Required For College Admission?

Making Possible Effective Career Advancement as an Educator

Early Childhood Education Program - What You Need to Know

8 Interesting Facts About ACT

Why Students Should Take AP Courses?

Importance of Curriculum Planning in Education

10 Reasons To Choose Cambridge Curriculum For Your Child

What Is The Difference Between AI And AA In IB Math?

ECE Training and School Management

Differences Between IGCSE And IB Curriculum

What Is IGCSE And Is It The Right Choice For My Child?

How Do Early Childhood Educators Impact Children’s Emotional Development?

What Is Theory Of Knowledge - TOK In IB Curriculum

Health Care Treatment (55)

Ayurvedic treatment of skin diseases

Common Reasons Behind Chronic Abdominal Pain in Adults

Travelling for Surgery – Doing It the Right Way

Treating Cough and Cold with Homeopathy

What causes excessive burping?

Acid Reflux Should Not Be Ignored March 2020

Say Goodbye to Chronic Digestive Problems!

How to make your home safe for Elders

How to achieve Affordable Healthcare in India

The Importance of Regular Health Check-Ups April 2020

Diseases related to Gastroenterology and Hepatology

Do not ignore these signs of a cardiac emergency

Recognize the warning signs of brain tumour, save a life

Holistic Approach to Raising Immunity!

The Effect of Coronavirus on Mental Health

Homeopathy Can Set You on the Path to Holistic Wellness

How to deal with Traumatic Brain Injury

Healthcare in the Post COVID-19 World

Homeopathy’s Role in the History of Epidemics

A South Indian Diet Plan For Heart Patients

Peptic Ulcers: Causes and Prevention

Fever Awareness and Remedies

The Importance of Boosting Your Immunity the Natural Way

Never Ignore Head Injuries

Positive Patient Experience with Kauvery Hospital

Traumatic Brain Injury - Causes, Symptoms and Treatments

Advantages of Treating Childhood Illness with Homeopathy

Congenital Spine Defect Cured After Surgery

Managing Arthritis with Homeopathy

Health Risks While Returning to Work after the Lockdown

Cardiac Surgery During COVID Times – Restoring Hope

Urological Diseases that affect Youngsters and Elders

How to Find the Best Gynecologist

Homeopathy Can Ease Winter Illnesses

Life after COVID19 for Senior Citizens

Orthopaedic Precautions For Seniors In Cold Weather

Health tips for Elderly during COVID-19

Vaccines for New Born Babies

Gastroenteritis

Masterstroke Against Stroke

Tips to take care of the heart

Why is breast self-examination important?

Kauvery Hospital’s excellent liver transplant program

Why is a regular health checkup important?

Save Your Knees

Understanding Chemotherapy

Kidney Stones - Treatment Methods

Knowing When to Go to the Hospital

How are homeopathic medicines prepared?

Tips for Managing Spring Allergies

Ankle Sprain: Causes, Symptoms, and Treatment

Heart Disease Awareness in Kauvery Hospital

Diabetic Kidney Disease

A Knock on the Head and There Goes your Memory

Coronary Heart Disease Awareness

Do You Have Questions?

Feel free to contact us by email. We usually respond within 24-48 hours.

Sign In LocalbizNetwork