Answered

Need compare 20 fields on lable to get the outcome

(0) Share

Report

Posted on by erkindunya

We have 20 fields these are mix-match of radio button and dropdown(including multi-select) I use if to calculated result and store them in separate 20 label, and the result is these 4 strings: Low, Medium, High and Critical.

Low	Medium	High	Critical	Medium	Low	Critical	High	High	Critical
11	12	13	14	15	16	17	18	19	20
Medium	Low	Critical	Low	High	Critical	Medium	Low	High	Low

The outcome will be the highest value available or presented on the above table which is Critical, even if we have 19 Low and 1 Critical it makes it to Critical.

Many thanks for your help in Advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I would make the Medium, High and Critical variables that you assign numbers to - 1,2 and 3. Create a variable to hold the outcome - say var_FinalState, nad set the initial value to 1. Then each time a radio button or dropdown is changed you can compare the value that the control was just set to to the value of var_FinalState and set the new value to the greater of Var_FinalState or the control. That way it will always have the greatest value of any control. When all controls are adjusted yo will have the value you need.

Was this reply helpful? Yes No
erkindunya 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Brian, I thout about that, how do I compare the 20 variables?

Was this reply helpful? Yes No
Verified answer

BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The actual syntax will change slightly depending on the control, but say for a radio button,

In the OnChange of each control put:

If(var_FinalState<Radio.Selected.Value, Set(vaf_FinalState, Radio.Selected.Value))

That will set var_FinalState to the larger of it's previous state or the radio button, whichever is larger

Put that formula - or a similar one, depending on the control - in each OnChange event. Then no matter what order they change the controls var_FinalState will always have the greatest value.

For your final value a statement like

Switch( var_FinalState,

1, "Medium",

2, "High",

3, "Critical")

Will get your text value for your final output

Was this reply helpful? Yes No