Power Automate Part 5 – Variables and Basic Arrays

By Andy Brown

If you’d like to help fund Wise Owl’s conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

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.

Chapters
00:00 Topic list
00:57 What this tutorial shows (OneDrive vs. SharePoint file counts)
03:21 The variables we need to create, and how variables work
06:14 Initialising the variables for OneDrive
08:59 Getting an array of the OneDrive files
12:19 Collapsing this array
15:56 Counting the files in the array
17:59 Repeating the above steps for SharePoint files

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Office Scripts, Power Automate and more!