Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Power Automate - Complete Guide to Microsoft Power Automate

Name: Power Automate - Complete Guide to Microsoft Power Automate
Rating: 4.6 (24361 reviews)

Automate your tasks with Microsoft Power Automate | Power Automate Masterclass | Integrated with Gen AI | Updated 2025

Created byHenry Habib, The Intelligent Worker

Last updated 4/2025

English

Arabic [Auto],Czech [Auto],

What you'll learn

Automate any task
Understand flow diagrams and how they visually represent a task
Create flows around everyday tasks, like sending an email or responding to an email
Learn about the five different types of flows (instant, automated, scheduled, UI, and business process flows)
Execute, share, manage, and monitor all your flows
Concepts you need to get certified by Microsoft
Integrate external applications into your flow using connectors and using API / HTTP requests
Create complex flows with conditions, loops, approvals, user input, and multiple actions
Apply Robotic Process Automation using Desktop or Web UI flows
Read Microsoft Power Automate documentation and resolve errors for future application builds

Course content

17 sections • 101 lectures • 12h 52m total length

Idea Behind Power Automate8:32
Power Automate provides a no-code platform to automate everyday workflows, using orchestration, thousands of connectors, and infrastructure to streamline tasks like email-to-ticket creation and onboarding, boosting productivity.
Course tips0:44
What is This Course?3:27
Master the Power Automate platform with an end-to-end, no-code guide to automating any workflow using connectors, AI features, and extensibility beyond your organization.
Course Roadmap4:51
Explore the complete Power Automate roadmap: from setup and beginner triggers to intermediate data actions and advanced HTTP requests, Copilot, and end-to-end workflows.
Features of Power Automate5:04
Power Automate is a no-code, easy-to-use platform integrated with Microsoft 365 and thousands of connectors. Offers orchestrations, workflows, and approvals, with security and extensible capabilities via connectors or APIs.
Who I Am1:26
Meet Henry Habib, a data and automation consultant, who boosts productivity by automating workflows, building applications, and guiding organizations with no-code tools and the Power Platform.
Keys to Success for Power Automate2:17
Practice along with the instructor to master power automate, embracing guided experiential learning, exploring beyond basics, and asking questions in the Q&A community to reinforce retention.
Ways to Contact0:53
Learn the best ways to contact the instructor, including Udemy Q&A, direct messages on the platform, and the Linktree for feedback and opportunities.
Leave a Rating0:56
Leave a rating to help the instructor improve and grow, and engage with this content by sharing questions and feedback for a better learning experience.
Watch in 1080p0:50
Watch all videos in 1080p or the highest resolution to ensure the best learning experience. Set 1080p in the video player via the gear icon, and avoid auto or 720p.

Get Power Automate5:46
Learn how to access Power Automate via Microsoft 365, verify licenses on office.com, and use start free or buy now options on the Power Automate site.
Power Automate Platform Walkthrough6:15
Navigate Power Automate environments to select the proper one, explore connectors and templates, and use the workflow canvas to create an instant cloud flow with a manual trigger.
What is a Power Automate Flow?8:37
Power Automate maps tasks into workflows with a trigger and a sequence of actions, from email to Excel, forms, time, or manual button clicks.
Types of Power Automate Flows5:50
Explore five Power Automate flow types, focusing on automated cloud, instant cloud, and scheduled cloud flows. A decision diagram guides choosing between connectors and desktop options, including Power Automate Desktop.
Course Resources0:01
Please see attached course resource.

Creating a Power Automate Flow from Scratch9:00
Create a Power Automate flow from scratch, starting with a manually triggered instant cloud flow that sends an email or Teams message using the Office 365 Outlook connector.
Running and Testing Your Flow6:46
Master testing and debugging of Power Automate flows using manual and automatic test runs, monitor flow runs, and inspect inputs, outputs, and intermediary results for reliable email automation.
Adding More Actions in Power Automate (Gmail and Teams) 16:49
Learn how to extend Power Automate by adding Gmail and Teams actions, create and authorize new connections, and post a message while testing in development mode.
Adding More Actions in Power Automate (Gmail and Teams) 22:14
Test and verify a multi-action Power Automate flow across Outlook, Gmail, and Teams, showing sequential and parallel options and how to set initial inputs usable later in the workflow.
Input Parameters and Dynamic Content12:04
Define input parameters for manual and automated flows and leverage dynamic content to customize email and Teams messages, using triggers, testing, and recently used inputs for efficient iteration.
Automated Cloud Flow12:50
Create an automated cloud flow that triggers on a new email and posts the email content to a Teams channel, using Office 365 Outlook and dynamic content.
Automated Cloud Flow with Gmail7:59
Create an automated cloud flow in Power Automate using the Gmail trigger 'when a new email arrives,' configure a reply with an out-of-office message, test, and turn off the flow.
Scheduled Cloud Flows6:25
Create and manage scheduled cloud flows in Power Automate by triggering actions on a time-based schedule, such as posting a Teams message every minute, with testing and disabling options.

Introduction to Expressions in Power Automate8:29
Explore Power Automate expressions, the no-code way to manipulate strings, dates, and logic, using Excel-like formulas to build concatenations such as full name from first and last names.
Expressions Exercises15:48
Practice using expressions in Power Automate instant cloud flows to sum and max two numbers and manipulate dates with date time functions and format strings.
Expression Resources and Copilot7:45
Explore the Power Automate reference guide to learn functions, inputs, and optional parameters. Use Copilot to quickly craft expressions, like splitting a full name into first and last names.
Expression Quiz with Copilot5:48
Learn to use Copilot to create and update a Power Automate expression that returns the last array item plus all remaining items joined with spaces, using split, skip, and join.

Introduction to Conditions in Power Automate10:29
Explore how conditions drive branching in Power Automate, routing actions to email or Teams messages based on the delivery method.
Practical Conditions Exercise 114:42
Create an automated cloud flow in Power Automate triggered by a donor form submission, convert the donation amount to an integer, and act on amounts above 3000 with alerts.
Practical Conditions Exercise 25:49
Learn to build conditional flows in Power Automate that route emails based on form submissions, switching to Office 365 Outlook when Gmail is restricted, and flagging large donations.
Nested Conditions in Power Automate7:09
Explore how to build nested conditions in Power Automate, using if statements and actions like sending emails and creating calendar events for large donations.
Switch Statements13:41
Use switch controls in Power Automate to branch logic by a parameter. Define cases for first time donor, occasional donor, and all time donor with a default path.
Parallel Branches4:13
Create parallel branches in Power Automate to run steps with no dependencies alongside sequential steps, enabling a Teams message and donor type switch to execute concurrently.

Flow Management Overview in Power Automate3:16
Explore how to manage existing Power Automate flows, view run history and details, debug with action-level data, and configure sharing, run-only limits, and monitoring for automated cloud flows.
Turning Flows On or Off2:04
Turn automated cloud flows in Power Automate on or off, especially those triggered by form submissions, and verify status with the on/off indicators and flow checker.
Sharing a Flow6:59
Explore three ways to share a flow in Power Automate: add recipients to flow actions, send a copy, or grant co-ownership within your organization.
Flow Monitoring5:08
Monitor and optimize your flows with analytics, run history, and error tracking; leverage process mining and flow checker to identify bottlenecks and prevent recursive loops.

Introduction to Alternative Methods in Power Automate4:06
Explore templates, AI-assisted flow creation, and Visio templates in Power Automate, understand when to rely on the base flow design, and how LLMs may shape future automation.
Create Flows from Templates8:43
Learn to build Power Automate flows from templates, connect to Gmail, Teams, Forms, and Planner, and automate tasks like notifying responses and posting updates.
Create Flows from Scratch Using Copilot6:34
Discover how Copilot speeds creating a power automate flow from natural language, then validate connectors, and deploy a simple trigger for new emails that posts to Teams using profile data.
Use Copilot to Modify Existing Actions3:48
Learn how to use Copilot to modify Power Automate actions, such as updating a Teams message to include the email sender and body, using concat and dynamic content, with testing.
Use Copilot to Add Actions in Power Automate6:47
Use Copilot to add actions in Power Automate, including replying to Outlook emails and creating calendar events, while testing and tweaking expressions and time zones.
Limitations of Copilot in Power Automate5:01
Explore building a Power Automate flow with Forms, including get response details and conditional logic, and learn Copilot’s limitations on complex workflows such as conditions and approvals.
Using Copilot to Ask Questions About Your Flow3:30
Use Copilot to ask questions about a flow, getting explanations of simple workflows like triggering on new email, notifying a chat, replying to emails, and calendar events, with limitations.

Introduction to Variables in Power Automate7:10
Power Automate teaches how to use variables to store and reuse data in a flow, including initializing a string variable and updating it with dynamic content.
Practical Use Case Example of Variables9:54
Create a practical Power Automate flow that initializes a full name variable from first name, middle initial, and last name, then use it in Microsoft Teams messages and emails.
Variable Cascading3:02
Master variable cascading in Power Automate to create dependent string variables and maintainable flows by initializing a variable from another and referencing dynamic content.
Integer and Float Variables in Power Automate15:49
Learn to use integer and float variables in Power Automate to store numeric form responses, convert strings to numbers, and calculate after-tax donations using a tax rate.

Introduction to Data and Writing to Excel in Power Automate9:22
Learn how to read from and write to data with Power Automate, using Excel online in OneDrive as a data store for a simple CRM and vacation requests tracker.
Email to Data Saved in Excel Online4:57
Create an automated cloud flow that triggers on new Outlook emails and saves the sender email and body to an Excel Online table in OneDrive for Business, using dynamic content.
Trigger Automations from Excel 114:44
Explore how to trigger Power Automate flows directly from Excel Online, for a selected row via right-click actions, to auto-send Teams messages and process donor data.
Trigger Automations from Excel 2 (with Input)4:11
Add an optional input to an Excel-triggered Power Automate flow and include the additional context in a Teams message using dynamic content, noting the one-row limitation.
Get a Row in Excel13:05
Use Power Automate to get a row from Excel Online by a unique email address, extract name, amount, and type, and post a Teams message.
Google Sheets Integration6:38
Discover how to use Power Automate to connect Microsoft Forms with Google Sheets and Google Drive, creating a flow that inserts form responses into a Charity Submissions sheet.
Create a SharePoint List7:19
Create a SharePoint list and learn to connect it with Power Automate flows to capture form submissions, track data, and set up alerts in your organization.
Forms to SharePoint List9:14
Create a Power Automate flow from a charity form submission to populate a SharePoint list, mapping name, email, amount, and donor type, including int conversion and basic error handling.
Trigger from SharePoint List and Send Email7:12
Power Automate creates an automated flow that triggers on a new item added to Charity Submissions SharePoint list, posts a Teams alert, and emails the donor with their donation amount.

Loops Introduction and Apply to Each in Power Automate9:09
Master loops in Power Automate to iterate arrays with Apply to each and repeat actions with Do Until, using practical examples like multi-select inputs and Teams messages.
Apply to Each: Attachment Example10:04
Apply to Each: Attachment Example demonstrates building a Power Automate flow that loops through email attachments, saves them to OneDrive, and notifies via Teams for each file.
Apply to Each: Tips and Conditionals9:30
Explore how Power Automate creates an apply to each loop automatically when you reference an array. Apply a condition to save or skip attachments and post updates to Teams.
Apply to Each: Cycle Through Records7:28
Explore how a for-each loop in Power Automate cycles through an Excel table stored in OneDrive for Business, converts amounts to integers, and posts Teams alerts for donations over 10000.
Do Until Introduction13:26
Explore the do until loop in Power Automate, using a counter variable, delay, and break conditions to repeat actions until a threshold is met.
Do Until Example 116:54
Demonstrate a practical do-until loop in Power Automate by capturing a form submission, saving details to an Excel table on OneDrive, and sending repeated Teams alerts until contact is made.
Do Until Example 26:00
Debug a power automate do until loop by removing the question mark from variable name and updating references. Avoid duplicates and ensure the loop stops when contact status becomes yes.

Requirements

This course goes starts from the basic level, so no prerequisites are required. Come hungry to learn!
Familiarity with Microsoft applications (Word, Excel, especially Excel formulas) is desired but not required
Willingness to learn

Description

*** UPDATED APRIL 2025 *** This Power Automate course has been significantly updated in 2025 to incorporate latest and greatest features and improvements to the platform. The older content is not available but can be provided if you message me. ***

*** NEW *** This course also includes Power Automate's AI Hub, which integrates Gen AI into your workflows - check it out in the Intermediate section.

Good news, everyone! Our Power Automate course has received a significant update in 2025 to incorporate the latest features and improvements of the platform, designed to aid and enhance the knowledge you gained in the previous course.

We will start with the fundamentals, including setting up flows, using expressions, and adding conditions. From there, we'll move on to advanced topics such as approvals, AI-powered automation with Copilot, and seamless integrations with Excel, SharePoint, and Power Apps. The updates are made to provide you with the most current tools and techniques to excel in your automation projects.

Moreover, we’ve incorporated real-world exercises to equip you with practical skills. With these enhancements, we believe you will find our Power Automate course more valuable and enriching.

Note: Power Automate was previously called Microsoft Flow

Have you ever wanted to automate a repetitive task? Are you an automation enthusiast? Do you want your business to be more efficient? If so, then welcome to Power Automate

Learn from more than 22 hours of relevant instructional video content, with many resources and further reading at your disposal!

Automate any tasks! Build automated workflows with no code. Power Automate is a development environment created by Microsoft to quickly create flows, which can automate any repetitive task that you have (both personal and for work). Power Automate is built for people who want to automate their tasks so that they can be more efficient.

Any task or business process can be automated. It can be something simple like "Get the most recent document from this website and email it to all my users every morning" or something more complex like "Retweet all tweets that mention my brand in a positive way".

Power Automate is quickly growing in demand and is currently the highest adopted automation system in medium-to-large companies (along with PowerApps) and one of the most sought after Microsoft skills, both personally and for business. People have leveraged Power Automate to free up several hours in their work day, so that they can focus on more important things. In fact, Forrester has reported that Power Automate makes businesses on average 15% more efficient. In Microsoft's words, Power Automate empowers everyone, from end users to technology experts.

Power Automate also contains both attended and unattended Robotic Process Automation (RPA) capabilities. You can start implementing RPA in your workflow with Power Automate. In fact, Power Automate was labelled as an RPA Visionary by Gartner in July 2020, and RPA continues to become more popular.

This is the only complete guide to Microsoft Power Automate, from basic to advanced. This course is not only comprehensive (it covers everything you need to know right from the start / beginner level) but is also instructional in nature, meaning that as we learn new concepts, we are also integrating them in the application with examples. Don't just learn concepts, learn how to actually apply them. That also means that whether you are a beginner or expert, there's something for you in this course.

This course is structured in a way that helps you learn all the concepts. For each concept, we first cover it in theory and then apply it using a real life example. We also progressively learn more and more advanced concepts, so that you never feel overwhelmed and can achieve your goals. I also respond to questions, and have an interactive portion in the course!

Again, this is the complete guide to Power Automate - you won't ever need another course. We will also update the course if there is a newer version or if newer features get released!

What is Power Automate?

Power Automate is a tool that allows you to build and execute flows, which can automate and streamline any repetitive tasks. It has the ability to connect to wide variety of applications (twitter, slack, outlook, drive, file system, third party via API) and can also contain complex logic like conditions or loops. It is also frequently used to develop Robotic Process Automation (RPA) within businesses. Almost any repetitive task can be replaced by Power Automate.

What are the main features of Power Automate?

Microsoft ecosystem - Power Automate is similar to other familiar Microsoft applications, like Word or Excel. It has the same ribbon structure and similar design, which makes it easy to learn and transfer knowledge. Power Automate is Microsoft's way to build and execute flows, similar to how PowerPoint is Microsoft's way to build presentations.
Easy to use - No coding necessary or even required. Similar to other Microsoft applications, it's a drag-and-drop system which makes thing easy, and has an amazing user-friendly interface to create flow diagrams.
Connect to anything - Power Automate has hundreds of pre-built connectors, allowing your flows to interact with several applications at once (like Outlook, Slack, Text, Trello, Filesystem, Drive, SQL). It also allows you to connect to any third-party application via API, and allows to interact with both Desktop and Web user interface.
Create any logic - Power Automate can make both simple (trigger and action) and complex (trigger, condition, loop, approval, action, etc.). It also has an approval feature, allowing you to get approval from someone before your flow can continue. This is useful for automating business processes.
Customize to your heart's desire - Power Automate allows you to build your flow your way. This means that you can build the flow in your vision - your imagination is your only limitation!
Powerful scaling - Flows have a powerful monitoring feature, allowing you to see how flows have performed for all your users. Flows can also be shared among colleagues with ease, and can scale up as your business or personal needs grow.

Why Learn Power Automate?

Boost your productivity - Power Automate can automate any repetitive task, meaning that you can have more time in the day for what matters most.
Create impact fast in your business - Power Automate can replace many mundane business process tasks with the click of a few buttons, without any code. Do you have a process in your organization or with yourself that is currently that can be automated? Power Automate allows you to replace this with an automated flow.
Get hired / increase your employability - Power Automate is one of the fastest growing tools in medium-to-large businesses, and is expected to be one of the top sought after Microsoft skill. Put this skill on your resume to boost your chances and pay rate. It is also a must-have for automation enthusiasts.
Improve your toolkit - Add this to your list of Microsoft skills - this is very powerful in conjunction with other Microsoft products (PowerApps, Office, PowerBI, Azure, 365, etc.)

Why Choose This Course?

Complete guide - this is the 100% start to finish, zero to hero, basic to advanced guide on Power Automate. There is no other course like it that teaches you everything from start to finish. It contains over 10 hours of instructional content!
Fully instructional - we not only go through important concepts, but also apply them as we are building our application so that we can solidify them. This is not only a walkthrough of the Power Automate features, but a course that actually builds flows with you
Step by step - we go through every single concept in a sequential order (from beginner to advanced). This improves your probabilities of learning Power Automate rather than going haphazardly through each feature.
Learn to learn - During the latter parts of the course, we go through situations where we encounter new features or errors, and work through how we would use the documentation to resolve them. In this way, you not only learn about Power Automate inside and out, but learn how to resolve your own issues as they come up
Teacher response - I have a response time of <8 hours, so if there's anything else you would like to learn, or if there's something you cannot figure out, I'm here for you!
Great resources - Resources, and further reading can help you in your learning journey

Course and Module Overview

Introduction - learn about Power Automate, its features, how to learn through this course, and what a flow is
Environment Setup - make a Power Automate account and set up your development environment
Beginner: create your own flow from scratch and learn about triggers, actions, dynamic content, expressions, and more
Intermediate: build more flows with complex controls, variables, loops, approvals and the AI Hub
Advanced: get expertise on data operations, HTTP requests, connectivity to Power Apps & Copilot Studio, advanced controls, and more
Conclusion: - earn your certificate

If you want to learn Microsoft Power Automate, this is the course for you. We're looking forward to having you in the course and hope you earn the certificate.

Who this course is for:

Analysts / Managers who want to automate any repetitive task to save time
Analysts / Managers who want to integrate automation into their business processes, saving time for everyone!
Students who want to impress employers with a relevant high-in-demand and growing Microsoft skill
Anyone who has a repetitive task that they want to automate
Anyone who wants to create an automated workflow
Seasoned Power Automate users / developers who want to enhance their skills (expert and advanced sections)
Automation and Robotic Process Automation (RPA) enthusiasts

Power Automate - Complete Guide to Microsoft Power Automate

What you'll learn

Explore related topics

Course content

Introduction10 lectures • 29min

Environment Setup5 lectures • 26min

Beginner - Flow Creation8 lectures • 1hr 4min

Beginner - Expressions4 lectures • 38min

Beginner - Conditions6 lectures • 56min

Beginner - Flow Management4 lectures • 17min

Beginner - Templates and Copilots7 lectures • 38min

Intermediate - Variables4 lectures • 36min

Intermediate - Data Interactions9 lectures • 1hr 17min

Intermediate - Loops7 lectures • 1hr 13min

Requirements

Description

Who this course is for: