Posted by
Andy Brown
on 21 August 2023
Power Automate has a cloud-based server and a desktop version. They may share the same name, but they are completely different products - this tutorial helps you work out which one you should be learning!
Posted by
Andy Brown
on 21 August 2023
This tutorial shows you how to get onto Power Automate, and how to create your first flow (to send an email to someone using Outlook 365).
Posted by
Andy Brown
on 21 August 2023
This video will show you how to create a flow in Power Automate triggered by an action (in this example, someone adding a recipe file to a folder in OneDrive).
Posted by
Andy Brown
on 22 August 2023
This tutorial will introduce the important Compose action, show you how to respond to SharePoint triggers and show the extent to which you can debug flows in Powre Automate.
Posted by
Andy Brown
on 22 August 2023
This is the first of a three-part series of tutorials, showing how to compare the files in OneDrive and SharePoint folders. This video concentrates on using variables and arrays to count the number of files found in each folder; the next two videos will show how to make the flow tidier and how to add a condition to test if the number of files found in each folder is the same.
Posted by
Andy Brown
on 23 August 2023
This video shows you how to use the Scope action to group tasks together, how to create branches in flows, how to annotate expressions and how to use the experimental expression editor (all ideas for tidying up your flows and making them run more efficiently).
Posted by
Andy Brown
on 23 August 2023
This tutorial shows how to test conditions in flows, whether using the simple Condition action or the more versatile Switch action.
Posted by
Andy Brown
on 24 August 2023
How to load data from Excel tables, SharePoint lists, Outlook (for example, lists of emails) and OneDrive (for example, lists of files and folders). This tutorial also shows how to select only the columns you need, and how to present the information in an HTML table.
Posted by
Andy Brown
on 25 August 2023
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.
Posted by
Andy Brown
on 25 August 2023
This tutorial will explain 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 and what all those question-marks mean! The tutorial also 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.
Posted by
Andy Brown
on 25 August 2023
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).
Posted by
Andy Brown
on 31 August 2023
How to create an approvals process. For this 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.
Posted by
Andy Brown
on 19 September 2023
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.
Posted by
Andy Brown
on 20 September 2023
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.
Posted by
Andy Brown
on 20 September 2023
This video shows how you can create a flow to interact with Teams. The example used listens for specific keywords mentioned in a Teams channel, and posts updates to another channel when these designated keywords are mentioned.
Posted by
Andy Brown
on 21 September 2023
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.
Posted by
Andy Brown
on 21 September 2023
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.