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.5) 2 reviews

39 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
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

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

2,632

Learners

294

Reviews

165

Answers

4.6

Rating

47

Courses

Nice to meet you! We are "Omas", Microsoft 365 experts.
As Microsoft 365 experts, we will help you work more easily and smartly.

Introducing Omas's instructors!!

Instructor Hyunjung Ko
Microsoft MVP (Microsoft 365 Apps & Services, 2016 – Present)

 

Official Blog & Café

 

YouTube

 

Books 

  • Microsoft 365 Business for Users & Admins

  • OMAS: My Smart Work using Office 365

  • Office 365 Quick Guide Series 1. Creating a SharePoint Site for Collaboration

  • Office 365 Quick & Easy Series 2. BI that business users can apply to work immediately without expert help

  • Office 365 Quick & Easy Series 3. From Basics to Advanced All at Once! OneDrive for Business

  • Office 365 Quick Series 4. Creating mobile apps your company needs: PowerApps

  • Office 365 in SMBs: My Smart Work using Office 365

  • Using OneNote 2016! - Basic Edition

  • OneNote 2016 Utilization! - Advanced Guide

  • Female office workers, never do this! A cheerful look at how to succeed in your professional life by thinking outside the box.

 

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 - MS 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 1st  Level

Other Qualifications

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

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

  • e-Learning Senior Consultant (Korea U-Learning Association)

  • e-Learning Instructor Level 2 (Korea U-Learning Association)

  • Computer Science Teacher Certificate (Minister of Education)

  • Lifelong Education Specialist Level 2 (Seoul University of Buddhism and Culture)

More

Curriculum

All

18 lectures ∙ (2hr 35min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

2 reviews

4.5

2 reviews

omas's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

$42.90