How to compare values of 2 columns against 2 other columns in another list and show the third column value if true

[Anonymous]

Hello,

For a project I need to create a column in a sharepoint list that contains a conditional/calculated column. This column is the risk value will be "calculated" depending on the values of the risk likelihood and risk consequence. Right now it is a field that users can fill in themselves but they should follow a certain logic.

I have created a seperate sharepoint list "Risk Consequence Calculator" that contains all the values that can be possible for all three columns.

The source sharepoint list is called the "Risk Consequence Calculator"

The sharepoint list where the calculated/conditional column should be filled in is "Info Sec and IT Risk Register"

The "Source sharepoint list" that contains all the data:

The list where the users can fill in the data and the risk value should be calculated:

Does anybody know how the code for the column "Risk Value" should look like? 

In my humble opinion I think the logic should be like this:

If the value of Info Sec and IT Risk Register. Risk Likelihood = Risk Consequence Calculator.Risk Likelihood

and the value of Info Sec and IT Risk Register. Risk Consequence = Risk Consequence Calculator.Risk Consequence,

Info Sec and IT Risk Register.Risk value = Risk Consequence Calculator.Risk value.

Best regards,

Kris 

[gabibalaban]

@Anonymous ,

Are you trying to achieve this via PowerApps or only using the Sharepoint internal tool only ? 

If is the second option, I recommend to use a PowerApps form to personalize the user experience and also inside this form to set the value of the "Risk Consequence Calculator" column based on user choices in other columns.

From my knowledge, I don't think that you can achieve your goal using only calculated column from native Sharepoint.

[v-bofeng-msft · Accepted solution]

Hi @Anonymous :

I've made a test for your reference:

1\My Lists:

2\Create a flow

The Result:

Best Regards,

Bof

[Anonymous]

Hi @v-bofeng-msft Thanks for your response! This really helped out. I was on a holiday so I couldn't reply sooner but nevertheless much appreciated.

Grtz, Kris