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 ==>	Handling errors (1 exercise)
Level ==>	Harder than average
Subject ==>	Power Automate and PAD training

Build a flow to add an item to a SharePoint list with a Try and Catch clause

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 create a flow allowing users to add items to a to-do list, reporting any problems which occur.

You may well find this exercise easier to do using the classic Power Automate flow designer. There seem to be several things to do with Scope actions which are harder to accomplish using the new designer.

Start by creating a new list in SharePoint based on an Excel table:

Choose this option, then choose to base your list on the Excel table called TodoList (it's the only one) in the above folder.

Choose to edit the Priority column:

First choose this option to edit the column .

Tell SharePoint that all your tasks must have different priorities:

Here we've also enforced a maximum value for the priority.

Create a new Power Automate flow called Exercise NN - add to do item, and add these 3 inputs to the Manually trigger a flow trigger at the top of it:

Create three inputs: two string ones, plus an integer one for the priority.

Add an action to create an item in your SharePoint list:

Pass the input values as parameters to the Create item action.

Run your flow twice, with these input values:

Run	Task name	Priority	Status
1	Pilates class	1	Done
2	Washing-up	1	Not done

The first run should work, but the second should fail because there's already a task in the list with priority 1. Time to add some error-checking!

Add two Scope actions to your flow, rename them and drag the Create item action into the first scope to set up an error-handling template:

You don't have to set up error-handling like this, but it's good practice to.

Configure the Catch scope to run after the Try one has failed:

The Catch clause will run only if one of the actions in the Try clause fails.

Deep breath! Add actions to your Catch scope to get the results of the Try scope, filter these to show only ones with status Failed, then show the error details:

If you need help, the expressions are shown below! As a starter, the Filter array action above should pick out all items where the item()['status'] equals Failed.

Here are the expressions for the Select action:

Select column	Expression
Flow name	workflow()['tags/flowDisplayName']
Action name	item()['name']
Error message	item()['outputs/body/message']

Add a task to turn this information into an HTML table, then send this information to yourself as an email:

You could always add CSS to tidy up this output ...

If you still have the time and energy, you could use the expression in the text file in the folder shown at the start of this exercise to add a link back to your flow!

Check that your flow works correctly when you type in a valid (ie unique) or invalid (ie duplicate) prioriity, then - with some relief - return to the Power Automate home page.

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

This page has 0 threads

Add a new post

EXERCISE TOPIC

POWER AUTOMATE AND PAD EXERCISES

POWER AUTOMATE EXERCISES

Build a flow to add an item to a SharePoint list with a Try and Catch clause

Head office

London

Manchester