Andrew, this is great, in fact I’ve been looking to try to do something similar to help my clients with when ‘documenting’ their health and safety risks. So glad you have explained how to do this as my knowledge is no where near your standard.
@andrewhess123
Жыл бұрын
Hi Paul, Thanks for your continuous support! This Power App was really neat, one of my favorites. Happy to share with the world 😃 Thanks for watching Paul!
@yehunlavolontededieu322
Жыл бұрын
Now I am getting addicted to your channel. I came here from the calendar recurring solution checking if you've created another calendar . But for my req what you've already built is enough I am gonna follow your solution and build it and let you know the result. Your contents are so unique and sometimes the only solution on internet for some of my req. Thank you so much.
@andrewhess123
Жыл бұрын
Thank you so much for watching Yehun. It's great to hear how my channel works for others! I hope to keep creating more unique videos. Thank you!
@victordauden9173
Жыл бұрын
Thx Andrew. So inspiring, and code included! Least one can do is give it a thumbs up, comment and thank you
@andrewhess123
Жыл бұрын
Thanks so much Victor, means more than you know! Some day soon I'm going to have to give back more to the community
@OptimalTrainingGroup
4 ай бұрын
This is awesome Andrew! Thank you for sharing. I currently need something like this.
@andrewhess123
3 ай бұрын
Very welcome! Thank you for watching!
@Educasag
4 ай бұрын
Amazing ! Thanks!!
@andrewhess123
4 ай бұрын
Thanks much Eduardo! I really loved this app! One of my favorites
@beecee9207
Жыл бұрын
Really neat! Love this! Thank you Andrew!
@andrewhess123
Жыл бұрын
Thank you bee cee!
@edcoffeebean
Жыл бұрын
Andrew Hess, great content! I'm so glad I found your channel! I want to see if I can do this with a parent-child relationship where the mitigation plan is in a separate SharePoint list. I really like your 5x5 risk matrix! I've seen some risk programs that graph the progress of the mitigation steps (waterfall). After seeing this video, I think anything is possible!!!
@andrewhess123
Жыл бұрын
Hi Ed, totally agree the mitigation plan in a separate list is a great idea! Thanks for watching Ed! I really loved this 5x5 matrix too. Talk to you again soon!
@taaee
Жыл бұрын
Andrew, one more nice App! Congrats! I'm just thinking to increase this serie and build a complete project & performance dashboard. Let's say, for each project we have a specific team (with manager/leader and squad) and goals (objectives)... what about?
@andrewhess123
Жыл бұрын
Hi T.A, love the idea. I think all project managers and C- class people would love it too.
@probookRamS
10 ай бұрын
Hi, Andrew. Nice video, thank you for sharing. It would be really helpful for me to learn all your videos. I have an question please suggest on this doubt how to solve... I want to be able to view a selection of my bi report and bi report in a 3*4 grid in my data grid so that I can get a holistic view of the data in the report... Using powerapp
@samivess-mash1872
Жыл бұрын
This is amazing thank you by far one of the best channels out there! I've been able to play with this slightly to create what I need but any idea how instead of providing a count I could provide a label showing the ID of all the risks that meet that liklihood x probability criteria? I have written code that utilises a lookup to do so but unfortunately that means it only returns one ID rather than all the IDs....any ideas? Thanks Andrew this is all amazing!!
@andrewhess123
Жыл бұрын
Hi sam, thanks so much. A lookup in Power Apps or a lookup in SharePoint? If you can get them in the same collection that may help you to compare them. Not sure of your exact scenario and how the data is formed.
@samivess-mash1872
Жыл бұрын
@andrewhess123 Sorry for the delayed reply I didn't see the notification but thank you for getting back to me I've written a Lookup in the matrix inside a label that basically looks up the probability x liklihood to return the ID number set by the share point list. However with lookups it only returns the first value not all values that match the probability and liklihood. I really want to be able to show all the IDs that match the probability x liklihood not just the first one. I've tried collections and I've tried filters but it doesn't work (unless I'm doing it wrong!) Any help or guidance would be greatly appreciated! Any
@samivess-mash1872
Жыл бұрын
@andrewhess123 sorry to bother but I was wondering if you had a chance to look at the above as everyone I've spoken to is stuck on it!
@andrewhess123
Жыл бұрын
Hi Sam, sorry yeah it didn't give me a notification for the last one either, let me see here. So yes the LookUp is only going to give you the first one. As stated here: powerusers.microsoft.com/t5/Building-Power-Apps/Lookup-only-showing-one-row-from-sharepoint-list/td-p/688005 As you stated before the best option is probably a filter or a collection. Do you have 2 galleries like the video. So when you click in the risk matrix does it filter the 2nd Gallery on the right side? Once you get that second gallery you could probably just add ThisItem.ID to that gallery. Then you could collect that gallery and do anything you would like with the data.@@samivess-mash1872
@andrewhess123
Жыл бұрын
If you can get that gallery on the right side, I really think that's the answer to getting the SharePoint IDs. In the gallery you could add ThisItem.ID. Then you could easily collect the gallery data and do whatever you'd like with it. Hope that helps. Sorry for missing your messages! @@samivess-mash1872
@OptimalTrainingGroup
2 ай бұрын
Hey Andrew, I notice that the first square of the Matrix is always selected by default. How can I make the matrix cleared by default? I want nothing to be selected. I tried everything (Clear(), Reset()) but nothing works. Any ideas?
@andrewhess123
2 ай бұрын
I think what I did was make the points not visible if they are set at default, so you don't see them.
@OptimalTrainingGroup
2 ай бұрын
@@andrewhess123 It showed as selected for me but I solved it by adding {} to the default property of the risk matrix gallery. Thank you!
@andrewhess123
2 ай бұрын
@@OptimalTrainingGroup Awesome! 😀
@bhavanaachari9445
10 ай бұрын
Hi Andrew, I have similar issue in power apps. It’s a power app integrated into power Bi. I have a gallery view where I have 4 data columns. I want it display in such a way where if I click on a cell which each cell has a name of an order. When I click on the cell it should display the items in the package with quantity and cost. Similar to matrix visual in power bi, can you help me out here
@probookRamS
Жыл бұрын
Hi Andrew, Thank you for sharing the knowledge..... I've been looking to try to do something similar but in my requirement it looks like a 9*5 risk Matrix gallery table....... could you please help me how to add Items gallery for 6*5 Matrix .....thank you in advance
@andrewhess123
Жыл бұрын
Hey probook, I'll have to see if I can come up with the 6*5, and when you say add items? Do you mean the colors or the actual counts?
@probookRamS
Жыл бұрын
Hi Andrew Thank you!🤝 I am looking for a count of the items gallery for 9*5 From the above video we come to know 5*5 [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] similarly for my requirement looking for 6*5 or 9*5 Could you please let me know
@probookRamS
Жыл бұрын
Happy New Year 🤝🤝
@andrewhess123
Жыл бұрын
@@probookRamS Happy New year, sorry I havent put together the 6*5 or 9*5 yet, I'll mark a note to see if I can get that one too 😀
@shibinyu1085
Жыл бұрын
@@andrewhess123 Hi Andrew, I am looking for the same thing as well! came across ur video when I was looking to create a 4X4 risk matrix table. wondering if there's any solutions for this?
@geralddahl9159
Жыл бұрын
I tried to use a Powerapps chart to present attendance (a,l,p) values for every day in a month and was stymied because charts only allow 10 series and I needed 31 for October. A Power BI matrix gave me the ability to take each row from my source ({students: Tom Brady, course: acting, datevalue: 1, attendancevalue: a}, {students: Tom Brady, course: acting, datevalue: 2, attendancevalue: p} etc) and present the results so that all the student names were presented as new row items on the left and all the dates for the month were presented as new column items from left to right along the top with the attendance value for each student appearing in its correct spot. Now I need to figure out how to import that Power BI tile into Power Apps. So, perhaps your method presents a way to replicate my desired output without Power BI?
@geralddahl9159
Жыл бұрын
I did all this in my developer account and publishing Power BI to a workspace requires an associated phone number and I believe my only phone number is already registered with another account. (I believe Power Apps only imports Power BI tiles that have been published to workspaces.)
@andrewhess123
Жыл бұрын
Yes you are correct about needing the workspace
@andrewhess123
Жыл бұрын
i do think it is possible without PowerBi. PowerBi with power apps does come with some limitations and it can take a few seconds to load also.
Пікірлер: 60