Answered

Auto populate dropdown based on other three dropdown values

(0) Share

Report

Posted on by DaynaBee

309

I am trying to auto populate a dropdown field (High, Moderate & low) based on other three dropdown values. If any of the three fields have a Value "High" the value should be set to "High" and if any of the fields have a value set to "Moderate" the value should be "Moderate".

Any idea how i can set this up?

Thanks,

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Yemata ,

Could you tell me:
If the value of one dropdown is 'High' and the value of the another dropdown is 'Moderate', what is the value of the fourth dropdown?
If the values of the three dropdowns are all 'low', what is the value of the fourth dropdown?

I assume:
If the values of dropdowns have both 'High' and 'Moderate', the value of the fourth dropdown is 'High'.
If the values of the three dropdowns are all 'low', then the value of the fourth dropdown is 'low'.

If my assumptions are correct, I did a test for you.
1\ Add 4 dropdown controls .'Dropdown1' , 'Dropdown2', 'Dropdown3', 'Dropdown4'.
Set their Items property to:
["High","Moderate","low"]

2\ Set the 4th dropdown control 'Dropdown4' 's Default property to:
If(Or(Dropdown1.Selected.Value="High",Dropdown2.Selected.Value="High",Dropdown3.Selected.Value="High"),"High",Or(Dropdown1.Selected.Value="Moderate",Dropdown2.Selected.Value="Moderate",Dropdown3.Selected.Value="Moderate"),"Moderate","low")

3\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
DaynaBee 309 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft For some reason it is underlining the whole formula in red.
DaynaBee 309 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft Any idea why the formula is throwing error ?