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.
This course is prepared for Basic Learners.
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 & annual leave application app!
.png)
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 and subtract them from your Excel account.
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 costs the person in charge a lot of time.
This lecture was designed to reduce repetitive tasks for those in charge and focus on important tasks by creating a system with SharePoint and List, connecting it to Teams for convenient use, and automating it with Power Automate, since it is ambiguous to develop a system like this.
I recommend this to these people 😀
If you do not have a vacation/annual leave application system and are applying by mail or payment!
If the person in charge is organizing annual leave/vacation in Excel!
If you are wondering if there is a system for requesting annual leave/vacation!
If you need approval but the system is difficult to build!
"If there was a system, it wouldn't be a big deal... It's a repetitive task that anyone can do...
In this course, you will create 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]
Create a vacation request/management site
Create an employee information table
Create a table of annual information
Create an annual leave application/management list
Change the application form with PowerApps
[Power Automate Automation]
Understanding the Approvals Flow
Automation of Step 1 of Approval
Automated 2-step approval process
Annual leave deduction automation
[Power Apps Mobile App]
Creating an Annual Leave Application Mobile App - (1) Creating from List to Automation
Creating an Annual Leave Application Mobile App - (2) Creating in Power Apps
Verify and test your mobile app
[Share and Use]
Using the List App
Sharing and Teams Connections
Expected Questions Q&A 💬
Q. Do I need to buy 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 1-month free trial and proceed for free, then subscribe.
Q. Do I need to have IT development or programming knowledge to take the course?
No! Even if you are not a developer or a specialist, you can easily follow the lecture content. Anyone can do it in no time even without programming knowledge.
🌀 Things to note before taking the class
- 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
1,973
Students
185
Reviews
153
Answers
4.4
Rating
42
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-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: