inflearn logo

Power Automate Level 4 - Creating a Vacation Request/Management System

Are you using Excel to apply for and manage vacation/annual leave? 🤔 Stop asking your manager about your annual leave every time! Create a vacation application and management system for your company through this lecture.

(4.0) 3 reviews

45 learners

Level Basic

Course period 3 months

Power Automate
Power Automate
SharePoint
SharePoint
Power Apps
Power Apps
Teams
Teams
MS-Office
MS-Office
Power Automate
Power Automate
SharePoint
SharePoint
Power Apps
Power Apps
Teams
Teams
MS-Office
MS-Office

What you will gain after the course

  • Power Automate Web (Cloud) / Approvals

  • Developing a vacation and annual leave application/management system

  • Business Process Automation

  • SharePoint + List + Power Automate + Power Apps

Convenient for both managers and users
Developing a vacation management system and annual leave application app!

Apply for annual leave/vacation by email, and the person in charge organizes it in Excel.

When you return from your annual leave/vacation, deduct the number of days you went back in Excel and subtract them.

Employees keep asking me how many vacation days I have left... 😭


If there is a system,
it is not a big deal, but if there is not and the person in charge manages it using Excel or manually, it is not only inconvenient for the user, but also requires the person in charge to spend a lot of time.

It is ambiguous to develop a system like this, so the lecture was designed to help managers spend time on repetitive tasks by creating a system with SharePoint and List, connecting it to Teams for convenient use, and automating it with Power Automate to reduce repetitive tasks and allow managers to focus on important tasks.


I recommend this to these people 😀

If you do not have a vacation/annual leave application system and need to apply by email or payment!
If the person in charge is organizing annual leave/vacation in Excel!
If you're wondering if there's a system for requesting annual leave/vacation!
If you need approval but it is difficult to build a system!


"If there was a system, it wouldn't be a big deal... It's a repetitive task that anyone can do...

If you are wondering, "Is there any way to automate this...?"

This course will help you build and automate systems to reduce repetitive tasks and focus on what matters!

Lecture Features ✨

  • The course proceeds step by step from beginning to end.

  • Let's follow along while taking the class 😁

🎯 Follow along as we create, configure, and automate together.

1️⃣ An annual leave/vacation request management system is created and the process is automated.
2️⃣ The mobile app for applying for annual leave/vacation is now available and can be used immediately.
3️⃣ You can automatically process approval/rejection and manage the results in an organized manner.


What you'll learn 📚

[Get Started]

Team Approvals
Understanding the system production flow

[SharePoint Site, List]

Creating a vacation request/management site

Creating an Employee Information Table

Creating an annual leave information table

Create an annual leave application/management list

Modifying the application form with PowerApps

[Power Automate Automation]

Understanding the Approvals Flow

Automated Step 1 Approval

Automated two-step approval process

Automation of annual leave deduction

[Power Apps Mobile App]

Creating a Mobile App for Annual Leave Applications - (1) Automating from Lists

Creating a Mobile App for Annual Leave Applications - (2) Creating a Mobile App in Power Apps

Verify and test your mobile app

[Sharing and Utilization]

Using the List App

Sharing and Teams Connection

Expected Questions Q&A 💬

Q. Do I need to buy any tools to take the course?

No, if you already have a Microsoft 365 Business Standard license or higher, you can use that.
If you are not subscribed, you can sign up for a one-month free trial and proceed for free before subscribing.

Q. Do I need any IT development or programming knowledge to take this course?

No! Even if you're not a developer or a specialist, you can easily follow the lectures. Anyone can do it in no time, even without any programming knowledge.

🌀 Notes before taking the course

  • Microsoft 365 services required to attend lectures

    • Power Automate (Web)
    • SharePoint Online
    • Lists
    • Power Apps
    • Lists
    • Outlook
    • Teams


Related Lectures 📢

Recommended for
these people

Who is this course right for?

  • Anyone who manages vacation and annual leave with Excel

  • People who do not have a vacation or annual leave system within the company

  • Anyone who wants to automate their work

  • Anyone who wants to learn Power Automate Cloud

  • Anyone who wants to get ideas for automating their work

Hello
This is omas

Career Verified

2,974

Learners

354

Reviews

167

Answers

4.6

Rating

47

Courses

Nice to meet you! We are Microsoft 365 experts, “Omas.”
Our Microsoft 365 experts will help you work more easily and efficiently.

Meet the instructor, Omas!!

Instructor Ko Hyun-jung
Microsoft Certified Trainer
Microsoft MVP (Microsoft 365 Apps&Services, 2016–present)

 

Official Blog & Café

YouTube

Books

  • Microsoft 365 Business for Users & Admins

  • My Smart Work with Office 365 by Omas

  • Office 365 in a Flash Series 1: Building a SharePoint Site for Collaboration

  • Office 365 in a Flash Series 2. BI that business users can put to work right away without expert help

  • Office 365 Made Easy Series 3. OneDrive for Business, from basics to practical use!

  • Office 365 Made Easy Series 4: Build the Mobile App Your Company Needs with PowerApps

  • Office 365 in Small and Medium-Sized Businesses: My Smart Work Using Office 365

  • OneNote 2016 in Action! - Basics 

  • Using OneNote 2016! - Advanced Edition

  • Working Women, Never Do These Things! A Fun, Fresh Take on How to Succeed at Work

     

Recognitions

  • MS-102 - Microsoft 365 Certified: Administrator Expert

  • MS-100 - Microsoft 365 Identity and Services

  • Teams Meetings and Meeting Rooms Technical Assessment

  • MS-700 - Microsoft 365 Certified: Teams Administrator Associate

  • MS-900 - Microsoft 365 Certified: Fundamentals

  • AZ-104 - Microsoft Azure Administrator Associate

  • AZ-900 - Microsoft Certified: Azure Fundamentals

  • SC-900 - Microsoft Certified: Security, Compliance, and Identity Fundamentals

  • PL-900 - Microsoft Certified: Power Platform Fundamentals

  • Exam 347: Enabling Office 365 Services

  • Microsoft Office Specialist Word 2016 Expert

  • Microsoft Office Specialist PowerPoint 2016 Core

  • Certificate of Qualification. Presentation Speech Level 1

Other Qualifications

  • Presentation Speech Level 1 (Korea Vocational Competency Testing Association, Ministry of Employment and Labor)

  • Level 1 CS Instructor (Korea Vocational Competency Testing Association, Ministry of Trade, Industry and Energy)

  • Top E-Learning Consultant (Korea U-Learning Association)

  • E-Learning Instructor Level 1 (Korea U-Learning Association)

  • Computer Science Teacher Certification (Minister of Education)

  • Lifelong Education Specialist Level 2 (Seoul Culture Arts University)

More

Curriculum

All

18 lectures ∙ (2hr 35min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

3 reviews

4.0

3 reviews

  • smcho128945님의 프로필 이미지
    smcho128945

    Reviews 7

    ∙

    Average Rating 3.9

    3

    33% enrolled

    • omas
      Instructor

      Thank you for your valuable feedback. It would be a great help if you could share any areas where you felt we fell short. We will carefully reflect on your comments to improve our future lectures.

    • I watched Level 3 and 4 consecutively. It was generally easy, but I was a bit confused due to differences with the latest version. Switching between multiple apps caused some synchronization issues. I'm struggling with problems using the lookup columns and user columns in the list. It's consuming too much time. The lectures are easy to follow step-by-step, but I feel the price is a bit expensive.

  • kawaiistraw5563님의 프로필 이미지
    kawaiistraw5563

    Reviews 1

    ∙

    Average Rating 5.0

    5

    33% enrolled

    • zzzzzknock3501님의 프로필 이미지
      zzzzzknock3501

      Reviews 2

      ∙

      Average Rating 4.0

      4

      61% enrolled

      omas's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!

      25% off for new members

      $32.90

      25%

      $42.90