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.
When you register a schedulein your Outlook calendar, the schedule is automaticallycopiedto the desired group calendar.
Automatically saveto a specified Excel filewhen new items are addedto a SharePoint list
Automatically notify you by email when items are added/modified in a SharePoint list.
Automatically send email notifications with the necessary information when an item is deleted from a SharePoint list.
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 💡
Power Automate
SharePoint Online
OneDrive Business
Forms
PC with internet access
Tools covered here 💡
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.
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!