556 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Create a flow to list out all of the files (but not the folders) in a given OneDrive folder:
This is what your final flow should show: an HTML table giving the name and size of each file in your chosen OneDrive folder.
Some brief notes to give you a chance of solving this are shown below (we think you'll need them!).
Here are 3 things that you'll probably need to know to solve this:
Choice of flow designer
Wise Owl couldn't get this to work in the new designer, and so had to use the old one: Power Automate kept correcting the source of data for one of our actions. This isn't the first bug we've found in the new flow designer!
This flow uses a FilterArray action to pick out all of the files (you'll need to run your flow and have a look at the outputs from the List files in folder action to work out what filter you should set).
The syntax for choosing which columns to display in your HTML table is item()['Column name']
A post-script - you could try seeing how Copilot would write this?
We tried being as explicit as possible, but the results were more complicated than they needed to be.
Reflecting on whether your job is safe for now or not, return to the Power Automate home page.
You can find other training resources for the subject of this exercise here:
25 Aytoun Street