This page has 0 threads | Add post

Exercises

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

Software ==>	Power Automate (21 exercises)
Topic ==>	Writing basic flows (5 exercises)
Level ==>	Relatively easy
Subject ==>	Power Automate and PAD training

Filter a SharePoint list of most visited websites to show only the search engines

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 .

Create a new list in a SharePoint website:

How to start a new list in SharePoint.

Choose to base your new list on an Excel workbook, and then choose the Excel workbook in the above folder (it contains a list of the 35 most-visited websites in the world as of October 2023, according to Wikipedia):

Choose to get your data from Excel.

You should end up with a list beginning like this:

The start of your loaded list in SharePoint.

Create a flow called Exercise NN - list search engines which gets the rows (items) from your SharePoint list and shows certain columns:

On the left-hand side is what your flow should look like; on the right-hand side are the columns you want to pick out. It'll be much easier to do this than it looks because the dynamic content list of fields will give the correct column names, rather than just field_n!

Now add an OData filter to pick out just the search engines. When you run your flow the final output should look like this:

You should just see the search engine websites.

Time now to make your flow more useful by adding a variable containing the category of website that you want to search for.

Initialising the website choice variable

Here we've called the variable WebsiteChoice, and set it to Social media to begin with.

Change your Get items action filter so that it picks out all of the websites whose category equals the value of the variable you've just created. This should give results looking like this:

The first 3 social media websites.

When you first run this flow you will probably get a run-time error. Read the error message and see if you can work out how to change your criteiria to solve this problem (if you didn't get an error, you can award yourself a Smug Programmer yellow star).

Breathe a deep sigh of relief, and return to the Power Automate home screen.

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

This page has 0 threads

Add a new post