Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
550 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers 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
Search our website
We also send out useful tips in a monthly email newsletter ...
You are welcome to try any of the 21 Power Automate exercises listed below, but please do not distribute them in any form without asking for our written permission first.
Software: | Power Automate |
Topic: | Writing basic flows |
Level: | Relatively easy |
Exercise: | Create a slightly pointless basic flow to show your name and the date. |
Software: | Power Automate |
Topic: | Writing basic flows |
Level: | Relatively easy |
Exercise: | Filter a SharePoint list of most visited websites to show only the search engines. |
Software: | Power Automate |
Topic: | Writing basic flows |
Level: | Relatively easy |
Exercise: | Write a flow to list all of the emails in your Outlook Inbox. |
Software: | Power Automate |
Topic: | Writing basic flows |
Level: | Average difficulty |
Exercise: | Use an Outlook trigger to capture summary data for any email when flagged. |
Software: | Power Automate |
Topic: | Writing basic flows |
Level: | Harder than average |
Exercise: | When an Abba song is added to a SharePoint list send a notification email. |
Software: | Power Automate |
Topic: | Getting data |
Level: | Average difficulty |
Exercise: | Get the tables in an Excel workbook and pick out the names. |
Software: | Power Automate |
Topic: | Getting data |
Level: | Average difficulty |
Exercise: | Write a flow which allows you to show the towns/cities for any specified UK region. |
Software: | Power Automate |
Topic: | Getting data |
Level: | Harder than average |
Exercise: | Count the number of films for two different genres, and compare these numbers. |
Software: | Power Automate |
Topic: | Getting data |
Level: | Harder than average |
Exercise: | List out the files (but not the folders) in a OneDrive folder. |
Software: | Power Automate |
Topic: | Apply to each loops |
Level: | Relatively easy |
Exercise: | Delete all of the emails from your Outlook 365 inbox about a given subject. |
Software: | Power Automate |
Topic: | Apply to each loops |
Level: | Average difficulty |
Exercise: | If someone uses SharePoint to order a known drink, order it; otherwise, tell them they can't. |
Software: | Power Automate |
Topic: | Apply to each loops |
Level: | Average difficulty |
Exercise: | Write a flow to loop over OneDrive files and folders listing out the folders only. |
Software: | Power Automate |
Topic: | Handling errors |
Level: | Harder than average |
Exercise: | Build a flow to add an item to a SharePoint list with a Try and Catch clause. |
Software: | Power Automate |
Topic: | Adaptive cards |
Level: | Relatively easy |
Exercise: | Create a simple adpative card for adding a team-building suggestion to a Teams channel. |
Software: | Power Automate |
Topic: | Adaptive cards |
Level: | Average difficulty |
Exercise: | Create an adaptive card for ordering from a Christmas menu (choosing carnivore or veggie). |
Software: | Power Automate |
Topic: | Approvals |
Level: | Relatively easy |
Exercise: | Create a flow to approve or reject requests to do specific things. |
Software: | Power Automate |
Topic: | Microsoft Graph |
Level: | Average difficulty |
Exercise: | Create an HTTP request to Microsoft Graph to list out all 365 users. |
Software: | Power Automate |
Topic: | Working with Forms |
Level: | Average difficulty |
Exercise: | Create a simple drinks order form and email yourself the orders as they come in. |
Software: | Power Automate |
Topic: | Working with Teams |
Level: | Relatively easy |
Exercise: | Email yourself details of any message that you're tagged in. |
Software: | Power Automate |
Topic: | Working with Teams |
Level: | Average difficulty |
Exercise: | Post a pop-up message in Teams when someone mentions the Spanish Inquisition. |
Software: | Power Automate |
Topic: | Working with Power BI |
Level: | Average difficulty |
Exercise: | Add a button to a Power BI report to send yourself or Teams a list of pizzas chosen. |
You can search our full list of Power Automate and PAD exercises here. Or why not learn to do them the right way on one of our Power Automate and PAD training courses? You can attend our online training classes wherever you are in the world!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.