This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Power Automate (21 exercises)
Topic ==>	Getting data (4 exercises)
Level ==>	Harder than average
Subject ==>	Power Automate and PAD training

List out the files (but not the folders) in a OneDrive folder

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 (the diagram below uses the classic flow designer for compactness):

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:

Area	Notes
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!
FilterArray action	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).
Item expressions	The syntax for choosing which columns to display in your HTML table is item()['Column name']