This is an intermediate level Power Apps I will be skipping over some of the basic Power App functionality, but we will be building an Issues and Risk list, which potentially will lead us to the next step in our Power App Development. I'm really hoping my next video can be a Risk Matrix that builds off this Dashboard. My name is Andrew Hess, Thank you for watching please like and subscribe if you enjoy this content.
OnVisible Collection for Risk Score Formula:
Concurrent(Clear(Red),Clear(Yellow),Clear(Green));
ForAll(Filter('Issues & Risks',RYG="R"),Collect(Red,{Title:Title}));
ForAll(Filter('Issues & Risks',RYG="Y"),Collect(Yellow,{Title:Title}));
ForAll(Filter('Issues & Risks',RYG="G"),Collect(Green,{Title:Title}));
ClearCollect(RYG,CountRows(Red),CountRows(Yellow),CountRows(Green));
Average Risk Score Formula:
Sum(Gallery1.AllItems,Score)/CountRows(Gallery1.AllItems)
Total Cost Formula:
Text(Sum(Gallery1.AllItems,Cost),"[$-en-US]$#,###.00")
RYG Fill Formula:
If(ThisItem.RYG = "R", RGBA(200,0,0,1),ThisItem.RYG ="G", RGBA(0,200,0,1),RGBA(250,250,0,1))
Chapters:
0:00 Introduction
0:44 What's the difference between an Issue & a Risk
1:31 Creating a SharePoint List
2:50 Creating SharePoint Columns
6:18 Creating the PowerApp
7:55 Creating a new Edit Form
13:30 Updating our Main Gallery
16:55 Issues with Percentage in SharePoint
19:39 Calculating Score (Impact * Probability)
21:17 Adding Columns for RYG and Cost
24:05 Adding a Risk Score Chart using Collections
27:35 Average of Risk Score KPI
28:45 Show Total Cost
30:00 Show Top 3 Highest Risk Cost
31:30 Conclusion
21 июл 2024