inflearn logo
inflearn logo

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.6) 14 reviews

126 learners

Level Basic

Course period 3 months

Power Automate
Power Automate
MS-Office
MS-Office
Power Automate
Power Automate
MS-Office
MS-Office
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

Reviews from Early Learners

Reviews from Early Learners

4.6

5.0

김유상

100% enrolled

It was easy to understand thanks to the easy explanation.

5.0

mskim1

38% enrolled

I understood it well and it was easy to follow.

5.0

이수형

100% enrolled

It was great that it was composed of content that would be helpful in actual work.

What you will gain after the course

  • 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 online, the coding screens can be difficult to see clearly. Therefore, I'll be capturing all the coding screens during the lecture to ensure a clear view for students. For those who require live coding, please note that this lecture will be conducted via screen capture.

Lecture Introduction 📝

If you've taken the Power Automate Level 1 course, "Automating My Repetitive Tasks - Power Automate (Flow)" and automated tasks by applying simple Flows, let's automate tasks in more steps with the Level 2 course!

I want to automatically copy my calendar and group calendars in Outlook, automatically save SharePoint List items to Excel files, receive emails with the information I want when adding/editing/deleting SharePoint List items, and automate everything from event registration to participation guidance!

This course will help you automate repetitive tasks, focus on more important tasks, and become a professional!


What I learned in class ✏️

So, let's see what tasks we can automate.

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


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


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


  5. Event registration is received through Forms, automatically saved as a SharePoint List, and an email is sent out informing participants of the participation schedule.

What you need to attend the lecture 💡

  1. Power Automate
  2. SharePoint Online
  3. OneDrive Business
  4. Forms
  5. 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 any tools to take the course?
A. No~~~!! You can take the course with the free trial version!

Q. Do I need any IT development or programming knowledge to take this course?
A. No~~~!! Just follow the lectures and you'll be fine! You can do it in no time, even without any 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 omas

2,631

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

Reviews

All

14 reviews

4.6

14 reviews

  • jj6253님의 프로필 이미지
    jj6253

    Reviews 8

    Average Rating 5.0

    5

    63% enrolled

    • kyoungminpark8038님의 프로필 이미지
      kyoungminpark8038

      Reviews 5

      Average Rating 4.8

      5

      38% enrolled

      • jonggilyoun6892님의 프로필 이미지
        jonggilyoun6892

        Reviews 5

        Average Rating 4.2

        5

        100% enrolled

        I will make good use of it in the future when necessary.

        • omas
          Instructor

          Yes, I hope it will help you with your work~ 👍👍

      • mskim12144님의 프로필 이미지
        mskim12144

        Reviews 2

        Average Rating 4.5

        5

        38% enrolled

        I understood it well and it was easy to follow.

        • omas
          Instructor

          I'm so glad to hear that it was easy to understand~ 😀 Thank you!

      • suhyounglee8865님의 프로필 이미지
        suhyounglee8865

        Reviews 10

        Average Rating 4.8

        5

        100% enrolled

        It was great that it was composed of content that would be helpful in actual work.

        • omas
          Instructor

          I'm so happy that it was helpful, thank you for the energizing review that gives me so much strength!!! 👍👍

      omas's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!

      $26.40