Platform Banner

Power Automate / Flow - Track in Planner and Lists and summarize in Teams Tutorial

Unlock your productivity with our latest video, 'Track in Planner and Lists and Summarize in Teams.' Discover how to combat invisible blockages in your projects using Power Automate. Learn to create real-time alerts that escalate issues to the right people instantly, minimizing delays and maximizing efficiency. Join us to transform your task management!

05:55
124 views

Available in Microsoft365

00:00:06

A task can remain blocked for days without anyone being informed,

00:00:11

delaying the entire project.

00:00:14

This 3rd automation instantly detects blockages

00:00:18

and automatically escalates them

00:00:20

to the right people to quickly resolve the situation.

00:00:24

Unlike previous automations that operate on a scheduled basis,

00:00:28

this one reacts in real time as soon as the status change is detected.

00:00:34

Let's start by creating a new flow in power automate.

00:00:37

For this automation,

00:00:39

we will use the trigger when an item is created or modified

00:00:43

from the SharePoint connector.

00:00:45

This trigger is perfectly suited to our needs

00:00:48

because it monitors in real time all changes

00:00:52

made to the items in your list

00:00:54

without requiring scheduled checks.

00:00:57

Once the trigger is added to your flow,

00:01:00

you need to connect it to your project tracking list.

00:01:03

Start by selecting the address of the SharePoint site where your list is located.

00:01:08

You can choose from your recent sites or directly

00:01:11

enter the full URL of the site in question.

00:01:14

Then in the next field,

00:01:16

select the name of your list that contains your tasks and their status.

00:01:21

Once this setup is complete,

00:01:23

the trigger will automatically monitor all changes made to this list,

00:01:28

ready to react to each modification.

00:01:31

Now that the trigger is in place,

00:01:34

let's add a condition to filter only the blocking cases.

00:01:38

This step is absolutely crucial because we don't

00:01:41

want the flow to run with every change,

00:01:44

but only when a task changes to block status

00:01:48

to set up this condition,

00:01:50

select the dynamic content status from the trigger,

00:01:54

choose the operator is equal to.

00:01:56

Then type block

00:01:58

respecting the exact case

00:02:00

and spelling used in your list.

00:02:03

This condition intelligently evaluates each modified item

00:02:07

and only continues the flow

00:02:09

if the status actually corresponds to a blockage.

00:02:14

Let's now move on to the actions to take when the condition is true,

00:02:18

that is when a task is blocked.

00:02:21

It is important to note a major difference here with the previous automation.

00:02:26

Unlike the due date reminder flow

00:02:29

where we had to retrieve the planner task details with an additional action,

00:02:33

here

00:02:34

we do not need to add an action to get the items.

00:02:37

The trigger,

00:02:38

when an item is created or modified,

00:02:41

does not go through the entire list but only

00:02:44

processes the item that has just been modified.

00:02:47

All the metadata of this item is already available

00:02:50

directly in the dynamic content of the trigger.

00:02:54

This is a major advantage in terms of performance and simplicity,

00:02:58

making this flow particularly effective

00:03:01

in the true branch of your condition

00:03:03

now add the action,

00:03:05

post the message in an instant conversation

00:03:09

or a channel of the Microsoft Teams connector.

00:03:13

Configure this action by choosing to post as a flow bot,

00:03:16

select channel as the destination,

00:03:19

then choose the appropriate team and channel for your escalations.

00:03:23

This channel can be a space dedicated to urgent situations

00:03:27

or your main project tracking channel,

00:03:30

depending on your team's organization.

00:03:34

Start with a catchy title like Blockage Reported

00:03:38

Action Required to immediately grab attention.

00:03:41

In the detail section insert the following dynamic contents

00:03:46

the title field for the name of the blocked task,

00:03:48

the person field for the name of the person who blocked the assigned task

00:03:52

to identify the responsible party,

00:03:54

the created by field for the decision maker who initiated this task,

00:03:59

and the modified field for the date the blockage was reported.

00:04:02

If your list has a description field,

00:04:04

add it to provide context for the issue.

00:04:07

Finish with the dynamic content linked to the item

00:04:10

that allows direct access to the item in the list.

00:04:14

The major advantage of SharePoint is that all these fields

00:04:17

are native properties already formatted and ready to use,

00:04:21

unlike Planet where we had to resolve ideas into unreadable form.

00:04:27

Everything is immediately usable to create a clear and actionable message

00:04:31

to ensure that the concerned individuals are alerted

00:04:34

even if they do not check teams regularly.

00:04:37

Add the action.

00:04:38

Send an email from the office 3165 Outlook connector.

00:04:45

In field A,

00:04:46

insert the dynamic content of the assigned person's email address

00:04:49

via responsible email.

00:04:51

By adding a semicolon as a separator,

00:04:54

add the task creator's email via created by email,

00:04:58

which represents the decision maker.

00:05:00

Write the subject followed by the dynamic title of the task.

00:05:04

In the body use the same structured content

00:05:07

as your team's message to ensure perfect consistency

00:05:10

between the two channels.

00:05:12

The key advantage is that the recipients are entirely dynamic.

00:05:16

The flow automatically sends the alert to the right

00:05:19

people based on who is assigned to the task

00:05:22

and who created it,

00:05:24

ensuring that each blockage is escalated precisely to the concerned individuals.

00:05:29

This automation radically transforms your blockage management.

00:05:33

Instead of invisible issues silently delaying your projects,

00:05:37

you now have a visible and actionable alert system.

00:05:41

Downtime is significantly reduced

00:05:44

as escalation is immediate and targeted.

00:05:47

The fluidity of your projects is maintained through quick detection

00:05:51

and resolution of obstacles.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

55 Views

E-learning Débutant

Video Training Microsoft 365 - Choose your task management tool

Discover how to structure task management in Microsoft 365 by combining Outlook, Lists, Planner, Loop, and To Do for smooth and centralized ...

ALL COURSES