
Learn to automate tasks and business processes using Power Automate for Microsoft 365. Explore basics and some intermediate features via the online version.
Automate repetitive tasks across apps, personal and business workflows, with Power Automate: use hundreds of connectors, connect via third-party tools, and build no-code approvals and invoicing processes.
Explore how a flow visualizes a task with a trigger and an action, enabling multiple actions, conditions, loops, and approvals, and manual or automatic triggers in Power Automate.
Compare instant, automated, scheduled, UI flow, and business process flows, and see how triggers start tasks in Power Automate.
Access Power Automate through online, desktop on Windows 10, or free trials, depending on your Microsoft 365 subscription.
Create a Power Automate flow from a template that notifies by email or mobile when a file uploads to a OneDrive folder; configure trigger, actions, and dynamic fields, then test.
Learn to run flows in Power Automate by creating a manually triggered instant flow, running it, and reviewing run history, with comparisons to automated flows triggered by events.
Navigate flow diagrams to inspect and edit triggers, actions, and dynamic content for sending emails. View run history, tweak settings, and share or export flows with ease.
Edit a flow to adjust the recipient, switch the email sender from the trigger account, and verify with flow checker and testing—manually or automatically—before confirming in Outlook.
Learn how to track flow runs, share and edit flows, rename and describe them, add steps from templates or from scratch, and review or modify the underlying JSON code.
Learn how to share Power Automate flows with others, including how to sign in to Gmail and Outlook, run a manual instant flow, and manage embedded connections and ownership.
Create an automated Power Automate workflow from a Twitter template to email you new tweets about a keyword like Excel, with testing and saving.
Create a flow from scratch in Power Automate, defining your own triggers and actions to automate an email alert when a specific Twitter keyword is posted.
Create a trigger from a tweet containing the keyword excel, select the Twitter connector, then add an Outlook email action and use dynamic content to tailor the message.
Learn to build a Power Automate flow that emails tweet updates using dynamic content fields - subject, body, tweet text, username, location, and post time.
Learn to edit flows with the pencil icon, adjust triggers, actions, names, and connections, then test with the flow checker and add dynamic content like tweet id.
Use Power Automate expressions to format a date with the format date and time function, using created at from dynamic content to produce a readable year-month-day timestamp.
Explore how to join text strings with the concatenate function in Excel and Power Automate. Combine username and name with spaces or a slash, and test the flow.
Create a Power Automate conditional flow that uses dynamic content to check tweet text for Excel and tips or tricks, posting to the Teams channel when true and emailing otherwise.
Learn to create and run scheduled flows in Power Automate, using time-based triggers and daily recurrence to post end-of-day reminders in a Teams channel.
Create a scheduled cloud flow that posts to Slack every Monday at 9am, then add a random 1-5 minute delay using a delay action and rand expressions.
Discover how an approval flow automates document reviews by triggering on file uploads to SharePoint or OneDrive, sending approval emails, and routing the file to approved or rejected folders.
Create an approval flow in Power Automate, using a template, triggered by a OneDrive file upload, wait for manager approval, and move files to approved or rejected folders.
Test approval workflow by creating a OneDrive file to trigger the Power Automate flow, then reject it in Outlook to move the file to the rejected folder using a template.
Businesses have embraced automation because it improves work efficiency, maximizing both work speed and reliability.
Power Automate is a simple yet powerful application from Microsoft for task and business process automation with no coding required. It is an exhaustive tool that can be connected to almost any application and used to streamline repetitive tasks. It lets you perform complex workflows and even allows you to share your workflows with other users.
This beginner-level course is suitable for those brand-new to Power Automate for Microsoft 365 and intermediate users looking to expand their skills. The online version of Power Automate is used throughout this course, which covers the basics to get you started with the application, plus some intermediate features. Please note, this course does not cover advanced features such as UI and desktop flows.
This course covers:
How to get started with the Power Automate interface
The definition of a flow and types of flow
Creating a flow from a template
How to create an automated flow
Running, editing, and tracking a flow
Sharing flows with others
Creating a flow from scratch
How to create triggers and actions
Using dynamic content
How to create expressions
How to create conditions
Creating scheduled flows
What is an approval flow?
Input types and how to apply them
Intro to built-in functions
Working with loops
Do-until function overview
How to use switch statements
This course includes:
2.5 hours of video tutorials
36 individual video lectures
Certificate of completion
Here's what our students are saying...
★★★★★ "What I like about this course is the delivery of material that is easy to understand. It is suitable for beginners and those who do not have an IT or programming background." -Denny Permana