Currently Empty: £0.00
Power Automate (formerly known as Microsoft Flow) is the new generation of Microsoft automation tools on Microsoft cloud. With this technology Microsoft is trying to make automation more accessible to the people who actually understand and live with the business process than techies to live and breath technology and quite often not so familiar with the business process.
This course is designed form beginners with no experience with Power Automate and upon completion of this course you will be able to create workflows using Power Automate that can solve real life automation challenges. Although the course is designed for beginners, the content is suitable for people with strong technical background that are willing to start with Microsoft Power Automate.
The course focuses on field experience and using the technology in day-to-day basis rather than just demos. Clear explanation is given for every step of the work assuring you well understand the work you do and can transfer the knowledge to your day-to-day job. Clear explanation of Microsoft Power platform guarantees your understanding of all elements you need to learn and all the licensing requirements are clarified right in the beginning of the course.
The course includes lectures, quiz and a final project that puts all the course knowledge together for a real life example of using Power Automate.
Working with Power Automate Trigger
-
1Introduction to Power Automate
Welcome and introduction to the course
-
2Who can benefit from this course?
The course target audience and prerequisites.
-
3What is Power Automate?
A review on Microsoft Power platform and understanding the basics of Power Automate.
-
4Hello World using Power Automate
Let's create a tiny Flow using Power Automate and point out Trigger, Action and Connectors.
-
5Licenses and tools you need for this course
-
6Warm-up with Power Automate
Let's build our first Flow in Power Automate together :)
-
7Course Road Map
Let's have an overview on what we are going to learn in this course.
Working with Power Automate actions
-
8Understanding different types of Power Automate triggers
In this lecture we learn about different types of triggers we have in Power Automate.
-
9Manually firing a Power Automate Flow
In this lecture you will learn how to use manual flow trigger with added fields. You will also run your first Flow from Power Automate mobile app.
-
10Instant Power Automate triggers that we don't cover in this course
-
11Firing Power Automate Flow on schedule
In this video you will see how to create a Flow that is fired on a calendar with intervals.
-
12Power automate automated triggers
In this lecture we create a Flow that monitors a SharePoint library and sends an email when a file is added to the library.
-
13Checking an e-mail arrival in a mailbox using Automated trigger
In this lecture we use a trigger that is fired when an e-mail gets to a mailbox.
-
14What is next?
Working with Power Automate Data types and Variables
-
15Create your first Flow that interacts with SharePoint online
-
16Make real use of a very simple Power Automate Flow
This is a real life example of using what we have learned so far
-
17Retrieving all items in a SharePoint list
In this lecture we will learn how to get all items from a SharePoint list using Power Automate Get Items action
-
18Why do we need OData in Power Automate?
In this video you will describe a scenario in which we need OData
-
19Learning OData syntax
In this lecture we learn the basic OData filters and use them in Power Automate Flow.
-
20OData Limitations and Sort
In this lecture we review some of the limitations of OData in Power Automate. We will also see how to sort the content that we receive from other sources using OData sort feature.
-
21Get Items vs Get Item - Finding list item by ID
So far we learned how to get all items in a list based on some filter criteria. In this lecture we learn how to get a specific item assuming that we have the item ID.
-
22Deleting and Updating list items in Power Automate
-
23Test your knowledge
This is a small quiz to test your knowledge about Power Automate basic actions
Working with Flow Control Actions
-
24Why do we need variables?
This is a quick introduction to why we need variables in Power Automate
-
25Let's create our first variables
-
26Set vs Increment/Decrement vs Append
In this lecture we learn how to work with different variable actions in Power Automate.
-
27Append to an array
An introduction to arrays in Power Automate followed by append function
-
28Working with Object variables
In this lecture, we create an object variable and assign a JSON object to it. Then we learn to use "Parse JSON" to read the object properties.
-
29Test your knowledge
Power Automate Security
-
30Working with conditions
In this lecture we learn how to use Condition action and select different flow paths based on the received value.
-
31Working with Flow Switch
This lecture is a demo of Switch control
-
32Working with "Apply to Each"
In this lecture we learn how to use "Apply to each" to navigate through all items in an array.
-
33Working with "Do Until" loop
Now we can have a loop with counter.
-
34Scope and Error Handling - Problem definition
The first section of error handling.
-
35Error handling - Basic features
In this lecture we learn about "Configure run after" and go through a simple example
-
36Error handling - Solving the problem
-
37Working with approval requests
In this lecture we learn how to create an approval request and send it to more than one approver simultaneously
-
38Branching the flow for different simultaneous approval requests
In this lecture we learn how to create two approval requests and send them to two approvers at the same time in two parallel branches.
-
39Test your knowledge
This is the test of your knowledge in Flow control actions
Working with Excel files
-
40Introduction to Power Automate Security
-
41Adding co-owners to the Power Automate Flow
In this lecture we learn about how to add co-owners to the flow and the impacts of it to other access levels.
-
42Working with Run-only users
This is an important chapter. In this lecture we will learn about giving a user to run a Power Automate Flow without giving access to open the Flow for edit.
-
43Test your knowledge
Time to test your knowledge on Security
Working with Office Forms
-
44Introduction to Power Automate and Excel
-
45Refresh your Excel knowledge
-
46Calling Flow from Microsoft Excel
In this lecture we create a Power Automate Flow that we call directly from Microsoft Excel and we pass table row as parameter to Flow
-
47Insert/Delete/Update Excel content from Power Automate Flow
In this lecture we create an excel file with a table inside it. Then we user Power Automate to insert, delete and update the rows in the table.
-
48Reading table rows in Excel
In this lecture, we connect to a table in Microsoft Excel and read the table content from Power Automate Flow
-
49Creating a table inside Microsoft Excel and reading the content
In this lecture we use Power Automate to convert an Excel range to a table and then read the content from the table in the same Flow.
-
50Test your knowledge
See how much you can remember from Excel interactions
Real life Flow scenarios and future steps
-
51Introduction to Office Forms
Let's have a quick review on Microsoft Office Forms before we get into connecting it to Power Automate.
-
52Capturing Office Forms submitted form using Power Automate
In this lecture we create a form that can anonymously capture the values from a user and insert it to a secure SharePoint list.
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Stars 5
5025
Stars 4
3506
Stars 3
647
Stars 2
47
Stars 1
24