
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.
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.
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.
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.
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.
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 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.
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.
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.
Please see attached course resource.
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.
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.
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.
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.
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.
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.
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.
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.
Explore how conditions drive branching in Power Automate, routing actions to email or Teams messages based on the delivery method.
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.
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.
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.
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.
Learn to build Power Automate flows from templates, connect to Gmail, Teams, Forms, and Planner, and automate tasks like notifying responses and posting updates.
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 Automate, including replying to Outlook emails and creating calendar events, while testing and tweaking expressions and time zones.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 list and learn to connect it with Power Automate flows to capture form submissions, track data, and set up alerts in your organization.
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.
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.
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.
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.
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.
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.
*** 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.