강의

멘토링

로드맵

Inflearn brand logo image
Productivity

/

Task Automation

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.

34 learners are taking this course

  • omas
3시간 만에 완강할 수 있는 강의 ⏰
자동화
Power Automate
SharePoint
Power Apps
Teams
MS-Office

What you will learn!

  • 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

2,361

Learners

241

Reviews

161

Answers

4.5

Rating

43

Courses

반갑습니다! Microsoft 365 전문가 "오마스"입니다.
Microsoft 365 전문가가 여러분이 보다 쉽게 스마트하게 업무를 할 수 있도록 돕겠습니다. 

오마스의 강사를 소개합니다!!
 

고현정 강사
Microsoft MVP (Microsoft 365 Apps&Services, 2016 ~ 현재)

 

운영 Blog & Café

 

YouTube

 

저서 

  • Microsoft 365 Business for Users & Admins

  • Office 365를 활용한 My Smart Work 오마스

  • Office 365 뚝딱 시리즈 1. 협업을 위한 SharePoint Site 만들기

  • Office 365 뚝딱 시리즈 2. 전문가 도움 없이 현업 담당자가 바로 업무에 적용하는 BI  

  • Office 365 뚝딱 시리즈 3. 기초부터 활용까지 한 번에! 비즈니스용 OneDrive

  • Office 365 뚝딱 시리즈 4. 우리 회사에서 필요한 모바일 앱 만들기 PowerApps

  • Office 365 in 중소기업 오피스 365를 활용한 마이 스마트워크

  • 원노트 2016 활용! - 기본편 

  • 원노트 2016 활용! - 활용편

  • 여자 직장인, 이것만은 절대 하지 마라! 유쾌하게 뒤집어 생각해보는 직장생활 성공법

 

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

그 외 자격

  • 프레젠테이션 스피치 1급 (한국직업능력검정협회, 고용노동부)

  • CS 강사 1급 (한국직업능력검정협회, 산업통상자원부)

  • 이러닝 최고 컨설턴트 (한국U러닝연합회)

  • e러닝 지도사 2급 (한국U러닝 연합회)

  • 전자계산 교원자격증 (교육부장관)

  • 평생교육사 2급 (서울문화예술대학교)

Curriculum

All

18 lectures ∙ (2hr 35min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

$42.90

omas's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!