This page has 0 threads | Add post

Exercises

Many people around the world enjoy and benefit from our exercises. If you're one of them - and can afford to - please make a small donation to help keep this and future blogs, exercises, skills assessment tests, tips, tutorials and videos freely available to everyone!

You can find other training resources for the subject of this exercise here:

You can also book hourly online consultancy for your time zone with one of our 7 expert trainers!

Software ==>	Power Automate (23 exercises)
Topic ==>	Getting data (4 exercises)
Level ==>	Harder than average
Subject ==>	Power Automate 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 two things that you'll probably need to know to solve this:

Area	Notes
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']

A post-script - you could try seeing how Copilot would write this? Here's a suggestion for a prompt to use within Copilot within Power Automate to generate your flow:

Create a flow to loop over all of the files and folders in a chosen OneDrive folder. The flow should show the file name and file size of each file in a nicely formatted table, but should not list any folders.

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:

You can also book hourly online consultancy for your time zone with one of our 7 expert trainers!

This page has 0 threads

Add a new post

EXERCISE TOPIC

POWER AUTOMATE EXERCISES

POWER AUTOMATE EXERCISES

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

Head office

London

Manchester