Create A Custom Risk Matrix of your Projects - Project Management with Power Apps

Опубликовано: 19 Февраль 2025
на канале: Andrew Hess

9,642

161

What better app is there to show your boss or C-class leader, but a large overview of all their projects based in a populated Risk Matrix? Come check it out, compare it to a real 3rd party tool that maybe cost licenses or a large some of money.

This is one of my favorite apps and all the equations are down below! If you like this content please give me a like and a subscribe it helps me a lot to keep creating new videos!

Items Gallery at first:
[11,16,20,23,25,7,13,17,21,24,4,8,14,18,22,2,5,9,15,19,1,3,6,10,12]

Fill Rectangle Colors Formula
(Brackets were replaced with GreaterThan Symbol, Youtube doesn't allow me to put that character in the video description):
If(ThisItem.Value(GreaterThan Symbol)=23,RGBA(250,55,50,1),
If(ThisItem.Value(GreaterThan Symbol)=20,RGBA(240,140,140,1),
If(ThisItem.Value(GreaterThan Symbol)=13,RGBA(220,220,20,1),
If(ThisItem.Value(GreaterThan Symbol)=7,RGBA(105,200,105,1),
RGBA(70,150,70,1)))))

Items Property of Matrix Gallery:
Table(
{Value:11,Probability:1,Impact:5},
{Value:16,Probability:2,Impact:5},
{Value:20,Probability:3,Impact:5},
{Value:23,Probability:4,Impact:5},
{Value:25,Probability:5,Impact:5},
{Value:7,Probability:1,Impact:4},
{Value:13,Probability:2,Impact:4},
{Value:17,Probability:3,Impact:4},
{Value:21,Probability:4,Impact:4},
{Value:24,Probability:5,Impact:4},
{Value:4,Probability:1,Impact:3},
{Value:8,Probability:2,Impact:3},
{Value:14,Probability:3,Impact:3},
{Value:18,Probability:4,Impact:3},
{Value:22,Probability:5,Impact:3},
{Value:2,Probability:1,Impact:2},
{Value:5,Probability:2,Impact:2},
{Value:9,Probability:3,Impact:2},
{Value:15,Probability:4,Impact:2},
{Value:19,Probability:5,Impact:2},
{Value:1,Probability:1,Impact:1},
{Value:3,Probability:2,Impact:1},
{Value:6,Probability:3,Impact:1},
{Value:10,Probability:4,Impact:1},
{Value:12,Probability:5,Impact:1})

OnVisible Collect Formula:
Clear(colIssuesRisks);
ForAll('Issues & Risks',Collect(colIssuesRisks,{Title:Title,'Project Name':'Project Name',Impact:Impact,Probability:Probability,Owner:Owner}))

CountRows Formula Per Cell Label:
CountRows(Filter(colIssuesRisks,Round(Impact/2,0)=ThisItem.Impact && Round((Probability*10)/2,0)=ThisItem.Probability))

Items Property of 2nd Gallery:
Filter(colIssuesRisks,Round(Impact/2,0)=Gallery3.Selected.Impact && Round((Probability*10)/2,0)=Gallery3.Selected.Probability)

Chapters
0:00 Introduction
0:57 The Risk Matrix
1:54 The PowerApp
4:00 Coloring the Risk Matrix
5:15 Added the Labels & Borders
6:45 Collect SharePoint List
9:58 Items Property of Gallery
11:35 CountRows of Risk Matrix Cell
15:05 Proof the Risk Matrix is Correct
18:03 Invisible Button
18:50 OnSelect Change Fill Color
20:08 Create a New Line Item
22:08 Conclusion