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

Like (0) Share

Report

Posted on 30 Sep 2020 16:26:21 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:

General Questions

All responses (4)

Answers (1)

GemM 2 on 23 Aug 2022 at 05:03:22

Like (0)

Report

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

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.
Merley72 60 on 24 Jun 2022 at 15:27:28

Like (1)

Report

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

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.
iceman31 4 on 04 Oct 2020 at 13:27:05

Like (0)

Report

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

Hi v-bofeng-msft

Will try it out.

Thank you so much

Best regards,
Verified answer

v-bofeng-msft on 02 Oct 2020 at 02:07:58

Like (0)

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

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