Inflearn brand logo image
Inflearn brand logo image
Productivity

/

Task Automation

Automating tasks Level 2 - Power Automate

If you have understood the basics of Power Automate through the Power Automate Level 1 lecture, now let's take it up a level and try automating it.

(4.5) 10 reviews

108 students

Power Automate
MS-Office

What you will learn!

  • Power Automate

  • Flow

  • Automation of business

  • Automate schedule registration (outlook ↔ group/team schedule)

  • Automatically save Excel backup when adding a SharePoint List

  • Automatically send notification emails when adding/modifying SharePoint List items

  • Automatically send notification emails when SharePoint List items are deleted

  • Automation from event registration to guidance

Automate your work with Power Automate
Let's become a profiler!

Since both Power Automate and SharePoint are conducted on an online screen, the coding screen is not visible, so the lecture will proceed with the coding screen by capturing the screen so that the students can see it well. If you need live coding, please note that this lecture will proceed with a captured screen.

Lecture Introduction 📝

If you have taken the Power Automate Level 1 lecture, “Automating My Repetitive Tasks - Power Automate (Flow)” and automated tasks by applying simple Flows, now let’s automate tasks in more steps in the Level 2 lecture!

I want to automatically copy my calendar and group calendars in Outlook, automatically save SharePoint List items to an Excel file, receive emails with the information I want when SharePoint List items are added/edited/deleted, and automate everything from event registration to participation guidance!

Through this course, you will automate repetitive tasks and focus on more important tasks to become a professional.


What I learned in class ✏️

So, let's figure out what tasks we can automate.

  1. If you register a schedule in your calendar in Outlook, the schedule is automatically copied to the desired group schedule.
  2.  Automatically save to a specified Excel file when new items are added to a SharePoint list


  3.  Automatically notify you via email when items are added/modified in a SharePoint list


  4. Automatically send email notifications with the required information when an item is deleted from a SharePoint list


  5. Receive event registrations in the form, automatically save them as a SharePoint list, and send an email with information on the participation schedule.

What you need to attend the lecture 💡

  1. Power Automate
  2. SharePoint Online
  3. OneDrive Business
  4. Forms
  5. A PC with internet access

Tools covered here 💡

  1. Power Automate paid or free trial ( https://asia.flow.microsoft.com/ko-kr/)
    Or, if you are an Office 365 or Dynamics 365 subscriber, you can use the free Power Automate
    However, it is not provided free of charge to Business Apps or Enterprise Apps subscribers.
  2. Of Office 365 (Outlook, OneDrive, SharePoint, OneNote, Forms)

Expected Questions Q&A 🙋🏻‍♂️

Q. Do I need to buy tools to take the course?
A. No~~~!! You can take the course with the free trial version!

Q. Do I need to have IT development or programming knowledge to take the course?
A. No~~~!! Just follow the lecture content and you can do it easily! You can do it in no time even without programming knowledge!


Recommended for
these people!

Who is this course right for?

  • Office workers who want someone to do repetitive tasks for them

  • Office workers who want to automate their work

  • Anyone who wants to learn Power Automate

  • Those who want to automate more advanced steps after taking the Power Automate Level 1 course

Hello
This is

2,253

Students

223

Reviews

160

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

8 lectures ∙ (1hr 10min)

Published: 
Last updated: 

Reviews

All

10 reviews

4.5

10 reviews

  • 조용균님의 프로필 이미지
    조용균

    Reviews 1

    Average Rating 3.0

    3

    88% enrolled

    ..

    • 윤종길님의 프로필 이미지
      윤종길

      Reviews 5

      Average Rating 4.2

      5

      100% enrolled

      향후 필요시 잘 활용하겠습니다.

      • 오마스
        Instructor

        네, 꼭 업무에 도움이 되시길 바랍니다~ 👍👍

    • 송창환님의 프로필 이미지
      송창환

      Reviews 1

      Average Rating 4.0

      4

      100% enrolled

      학습에 많은 도움이 되었습니다.

      • 오마스
        Instructor

        다행이네요~ ^^ 힘이 나는 수강평 감사합니다!

    • tkekhr.seedcampus님의 프로필 이미지
      tkekhr.seedcampus

      Reviews 3

      Average Rating 4.7

      5

      100% enrolled

      고맙습니다

      • 오마스
        Instructor

        저도 고맙습니다~ ^^

    • 이진옥님의 프로필 이미지
      이진옥

      Reviews 4

      Average Rating 4.8

      4

      100% enrolled

      회사 보안 프로그램때문에 실습하는데 어려움이 있었지만 도움이 되었습니다.

      • 오마스
        Instructor

        아하! 보안 때문에 힘들게 실습 하셨군요~ ^^ 고생 많으셨어요!!

    omas's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!