Creating a Risk Matrix system. How do I sort and group risk in Gallery List?

(0) Share

Report

Posted on by iceman31

Hello from Malaysia,

I am trying to create a risk matrix system using SharePoint as the database.

The testing app as follows:-

Currently the gallery list is sorted by coloum and vertically. How can i make it horizontally and group each of the risk by likelihood x impact as picture below ?

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @iceman31 :

Could you tell me:

Do you want to group all records based on the values of Likelihood and Impact and display these records in the form of a table so that the user can select one of the required records?

The solution I adopted is to use a nested gallery.I'v made a test for your reference:

1\My data source:

ClearCollect(YourDataSource,{Company:"ITSD",Likeihood:3,Impact:3},{Company:"DDD",Likeihood:3,Impact:3},{Company:"CCC",Likeihood:4,Impact:3})

2\Add a Blank horizontal gallery(Gallery14) and set it's items property to:

[1,2,3,4,5]

3\Add a Label(Label16) control into Gallery14 and set it's items property to:

ThisItem.Value

4\Add a Blank vertical Gallery (Gallery15) into Gallery14 and set it's items property to

[1,2,3,4,5]

5\Add a List Box control(ListBox1) into Gallery 15 and set it's Items proeprty to:

Filter(YourDataSource,Likeihood=ThisItem.Value && Impact=Value(Label16.Text) )

OnSelect

Set(MYVAR,ListBox1.Selected) /*MyVar is my custom variable*/

SelectMultiple

false

When you make a selection in the listbox, the record you selected will be saved in the variable "MYVAR". On your side, you only need to set the Items property of the displayform to ‘MYVAR’.

Best Regards,

Bof

Was this reply helpful? Yes No
iceman31 4 on at

Like (0)

Report
Copy link

Link copied!

Hi v-bofeng-msft

Will try it out.

Thank you so much

Best regards,

Was this reply helpful? Yes No
Merley72 60 on at

Like (1)

Report
Copy link

Link copied!

Hi Iceman31

Although you posted this some time ago, I was wondering if you managed to get all things working as you want them for your Risk Assessment /Matrix system.

We have created just such a system for use in Power Apps which integrates with Microsoft 365 (SharePoint behind the scenes), and have installed this within a several companies here in the UK. We are in the process of turning it into an installable solution which we will eventually sell through the Microsoft channels. It uses SharePoint as a back end as this allows for easily to configure Views, displays of records and data and for Management and end-user interaction. I’m preparing a couple of 5 minute videos which explain about it much more detail and wondered if these would be of interest when they are complete?

Please drop me a DM or reply if this is of interest.

Regards and thanks, Alan C.

Was this reply helpful? Yes No
GemM 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Merley72

I am working in the Risk Matrix space for a large-ish agency and would be interested in contacting you regarding the abovementioned installable solution. Are you please able to reach out and provide me with some information that I might be able to provide to my management about this possibility.

Was this reply helpful? Yes No