PowerApps Issues & Risk List connected to our Project Dashboard
Vložit
- čas přidán 24. 07. 2024
- 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
A couple of the formulas would not go in the description of the video, because they contained < & >, so if you would like those equations feel free to leave me a comment. Thank you all for your support!
Thanks Andrew, very helpful
Thanks for watching Hugo
great content as always! best regards!!!!!
Thanks Cristobal! Can't wait to share next weeks!
Nice serie Andrew! A risk matrix would be nice.
Hopefully about to put that video together today.
Got started late today, as long as I can finish today, will release 10AM tomorrow EST
Great work, Andrew. Please how did you change the color set of the pie chart? What did you do with the ItemColorSet?
At 6:53 in the video you make the image disappear then a red x appears. I'm not sure what you did and can't replicate what you did. Can you help me?
Oh so first, you put your datasource in the items property, then i delete the image with the delete button. Then the red X's appear, so i go to the red x's formulas that are wrong. First the X value, and I just delete the formula for X because I will manually move it. Then the width I just remove image.width because it can't find the image.
Let me know if this helps
For gallary, why don't you go to property> layout setting on the side and change the "image, title and subtitle" field to just "title/subtitle"?
Hi Eugene, just habit. That could work too.