
Explore how to start with Power Automate, understand course structure and expectations, and learn the basics of creating flows, variables, and dynamic content for event and invoice projects.
Explore the Power Platform, a set of Microsoft tools for end-to-end solutions across user interface, logic, and data layers, with Power Automate as the logic layer.
Explore how Power Automate automates tasks with triggers and actions through a drag-and-drop interface and dynamic content, and compare the web cloud version with the desktop on-premises version.
Learn to access Power Automate from your browser and explore the environment, create automated and schedule flows from templates, manage connections and approvals, and navigate My Flows and learning resources.
Create your Power Automate flow with an instant cloud flow and a manual trigger, add a text input named message, and configure it to send an email to an address.
Explore how to use dynamic content in Power Automate to trigger flows from emails with a subject line filter, capture the body, and convert html to readable text.
Learn about variables and data types in Power Automate, including string, integer, float, boolean, object, and array, and how to initialize, set, append to variables, and increment or decrement values.
Explore variables and data types in Microsoft Power Automate by building a flow with a get current weather action, and initializing array and object variables.
Create a Power Automate flow to load Microsoft form responses into an Excel table, combining first and last names into a single column and storing email, course, and attendee count.
Create and format an Excel table from a range, name it, and pull its records into Power Automate using the list rows present in a table action.
Create a Microsoft form and an Excel table to capture attendees' emails, names, chosen course, and number of guests, with the table auto-updated by form submissions.
Create an automated cloud flow that connects a Microsoft Form to an Excel table, using get response details to add a row with name, email, course, and quantity of people.
Create a Microsoft form and connect it to an Excel file using a Power Automate flow, leveraging tables and expressions to transform form responses before loading into the workbook.
Automate sending an email for each invoice by reading data from an Excel table and using an apply to each loop with DateTime expressions in Power Automate.
Learn to read a table of invoices with the Power Automate Excel Online connector, loop through each record using apply to each, and send an email for every invoice.
Power Automate reads the invoice table and sends an email for each record from a shared mailbox. Dynamic content includes customer name, invoice number, amount, and a subject 'invoice issued'.
Explore next steps in your Power Automate journey by pursuing related Power Platform courses, Power Apps, Microsoft certifications, joining the Power Automate community, and applying automation to real-world processes.
In this course, you'll start your automation journey with Microsoft Power Automate. Designed specifically for beginners, the course offers a comprehensive introduction on how to get started with Power Automate, bringing real-world examples on how to automate repetitive tasks and streamline your processes.
Among other topics, you will learn:
What is Power Platform and Power Automate
How to navigate in Power Automate environment
How to choose the correct type of flow in Power Automate
How to work with variables and data types (even without being a software developer!)
How to connect Power Automate to other services, like Excel, Outlook and Forms
In addition to the theoretical lessons, the course also has two real-world projects, where you will have a hands-on experience on how to solve problems with Power Automate:
Project 1: "No-click" solution to handle upcoming event registrations, storing the data from event's attendants in an Excel file.
Project 2: Automation to populate an email template and send it to several addresses via Outlook. The template is dynamically populated from an Excel file, and will even include a quick introduction on how to format dates in Power Automate.
By the end of the course, you'll be equipped with the basic practical skills to move forward in your Power Automate path.