Power Automate Desktop | Loops exercise | Create a flow to loop over Excel workbooks signing each one

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.

Software ==> Power Automate Desktop  (18 exercises)
Version ==> Latest version
Topic ==> Loops  (3 exercises)
Level ==> Average difficulty
Subject ==> Power Automate training
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

The above folder contains four files:

Four files

Your task is to get a list of all of the Excel workbooks in this folder, then loop over this list opening each workbook up, adding a worksheet to it, signing your name in cell A1 and then saving the workbook and closing it back down again.

 

Although this sounds hard, it's actually pretty straightforward!  Remember to set a file filter of *.xlsx when getting a list of the files from the folder, and bear in mind that when you add a new worksheet you'll automatically be taken to cell A1 in it.

Create and write a flow called Kilroy was here to accomplish this task  When you've got this working to your satisfaction, save and close it!

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only. Our Power Automate exercises answers are provided as text files - you can see how to assemble these back into PAD flows here.
This page has 0 threads Add post