No prior knowledge of AI or programming required
Basic computer skills (using a browser, email, files)
Curiosity to learn new technology
Access to a laptop or desktop with internet
Willingness to practice with simple AI tools
Microsoft have given the same name to two completely different products: the old Microsoft Flow (now called Power Automate), which allows you to automate workflows in the cloud, and the old Win Automation (now called Power Automate for Desktop), which allows you to implement Robotic Process Automation on your desktop computer. This video summarizes the differences between the two software applications and gives an example of each.
This video will get you started with creating basic flows in Power Automate: the tutorial walks you through an example of creating a flow to send an email to someone using Outlook 365.
This tutorial will show you how to write a flow which runs on a trigger. For the example used for this video, this trigger will be someone adding a new recipe to a specified folder in OneDrive, which will then cause Power Automate to send a notification email out.
This tutorial shows how you can create a text file in OneDrive when someone selects a file in SharePoint. The flow you'll create uses a Compose action (one of the most important in Power Automate) to bring the information you want to export together, before using a OneDrive action to create a text file. You'll also learn about the limitations of debugging in Power Automate, and how to get round these.
This tutorial is the first of a series of 3. It explains what variables are in Power Automate and how to use them, and also gives example of setting and collapsing arrays. The next two tutorials in the series will show how to tidy up flows to make them neater and more elegant, and how to add conditions to test expressions in flows.
This tutorial will show you how to make flows easier to read (and also more efficient). You'll learn how to group actions together using Scope, how to create branches in flows and how to work with expressions more efficiently. Note that you should watch the previous tutorial on variables and arrays before watching this one (this is the second tutorial in a mini-series of three).
This tutorial will show you how to add conditions to flow, whether using the simple Condition action to test between two possibilities or the more complicated Switch action to test between multiple mutually exclusive options.
This tutorial will show how to load data from Excel tables, SharePoint lists, Outlook (for example, lists of emails) and OneDrive (for example, lists of files and folders). The tutorial also shows how to select only the columns you need, and how to present the information in an HTML table.
This tutorial shows how you can use OData to sort and filter tables of rows returned from online cloud-based apps like SharePoint and Excel 365, and why you should want to do this.
This tutorial will explain some of the things about Power Automate which may have been puzzling you, such as: - why Power Automate keeps randomly embedding your actions in Apply to Each loops - how you can copy dynamic content into an expression for subsequent editing - the syntax of expressions, on what all those question-marks mean The tutorial explains how to create and use Apply to Each loops in Power Automate, using the example of looping over the rows in an Excel table.
This video shows how to handle errors in Power Automate flows. While it contains some complicated expressions, it will give you a good understanding into creating JSON expressions (as well as in the best way to implement error-handling).
This video shows how you how to create an approvals process. For our example when someone adds a film to a suggested watch list, you (or someone else) will be able to accept or reject the recommendation, giving your reasons. This acceptance or rejection (with the corresponding reason) will be flagged in SharePoint and the person who added the film will receive a notification of the result.
This video shows how to write flows to run when someone fills in a form that you've created. The cloud-based Forms application only exposes one trigger and one action, so there's not too much that you can do to automate forms using flows, but this tutorial also gives a handy introduction to how to create and distribute surveys using the easy-to-use Forms application.
This video shows how you can create Power Automate buttons in Power BI reports, which run flows when you click on them. The example in this tutorial shows how you can email the current data in the filter context for a visual to someone just by clicking on a button embedded in a report.
This video shows how you can create a flow to interact with Teams. The example used is to listen for specific keywords mentioned in a Teams channel, and post updates to another channel when these designated keywords are mentioned.
This video shows how you can delegate your error-handling to a separate flow, and then call this child flow when an error is triggered. Along the way you'll also learn about passing inputs to triggers and about creating solutions.
This video shows how you can create tracked properties for any action, using them for this example to time how long an action takes to run.
As the Super Admin of our platform, I bring over a decade of experience in managing and leading digital transformation initiatives. My journey began in the tech industry as a developer, and I have since evolved into a strategic leader with a focus on innovation and operational excellence. I am passionate about leveraging technology to solve complex problems and drive organizational growth. Outside of work, I enjoy mentoring aspiring tech professionals and staying updated with the latest industry trends.
No Review found