This page has 0 threads | Add post

Exercises

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

Software ==>	Power Automate Desktop (18 exercises)
Topic ==>	User intefaces (UIs) (2 exercises)
Level ==>	Harder than average
Subject ==>	Power Automate and PAD training

Create a flow to simulate opening Power BI Desktop and linking to an Excel table

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.

Before you can do this exercise, you'll need to download and unzip this file .

The aim of this exercise is to get to this state:

Your flow should open Power BI, clear the splash screen which appears, choose to connect to the Excel workbook in the above folder and load the list of films. The answer doesn't then expand the Top films table to show the fields in it (as shown in the diagram above), but you could do this as an optional extra!

Listed below are the ways that Wise Owl managed to get this to work, but our solutions aren't necessarily the best ones, and you'll get much more out of this exercise if you try working out how to solve all the problems yourself without reading on.

Here are the steps Wise Owl took to solve this problem, using a new flow called Open Power BI and connect, with notes of where we got stuck. There are almost certainly better ways to create this flow:

Step	Solution
Open Power BI	We couldn't find the executable for Power BI, so instead ran it by clicking on one of our Windows task bar icons (cheating a bit!).
Clear the splash screen	This was hard! The splash screen seems to run in the background, so we ended up creating an image showing the cross in the top right corner, then selecting this (with a left click following).
Choose to load an Excel workbook	This was easy: just create a UI element for the ribbon tool, and click on it.
Choose the file	This was relatively easy: create a UI element for the file name box, go to it and use a Send keys action to type in the file name and to then press Enter.
Choose which table to load	Search as we might, we couldn't find a short-cut key to accomplish this (and even had we done so, we couldn't find a way to send keystrokes to the right window). We ended up using two images: one for the check box next to the table name, and one for the Load button. Not a good solution!

If you get this all working and still have spare time and energy, you could always try creating a Power BI visual (probably best to stick to a table) showing each film title with its number of reviews. Still have time? You could try formatting this!

When you're happy with the state of your flow (and you've checked it works OK) save it and close it down.

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.

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

This page has 0 threads

Add a new post