- Access exercises (91)
- C# exercises (79)
- Excel exercises (278)
- Power Apps exercises (13)
- Power Automate exercises (18)
- Power BI exercises (139)
- Power Platform exercises (157)
- Python exercises (28)
- Report Builder exercises (141)
- SQL exercises (198)
- SSAS exercises (51)
- SSIS exercises (46)
- SSRS exercises (99)
- VBA exercises (85)
- Visual Basic exercises (46)
POWER AUTOMATE EXERCISES▼
POWER AUTOMATE DESKTOP EXERCISES▼
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.
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:
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!