Power Platform Community Forum Thread Details

Hi All,

I need your support with the following, I need to auto-populate a result value in a dropdown list based on another 2 dropdowns. For instance: I have 3 dropdowns fields, in the 1st dropdown I had selected "Cat", in the 2nd dropdown I had selected "Big" so based on that two selections I should auto-populate the result in the 3rd dropdown.

I was thinking about using the "IF" formula but to be honest I do not know how to build this formula because the result in the previous 2 dropdowns are values taken from a SharePoint List and the result in the 3rd dropdown also is part of a SharePoint list but.. using as a conditional the previous 2 selections.

Could you please help me?

Thanks!

Categories:

Building Power Apps

Hi @Franvala22 ,

Do you want to make the third dropdown auto-selected bases on the other two dropdowns? Could you please share more about the items in those three dropdowns? What type are the three columns in your SP list, Choices or Text?

If you want an auto-seleted dropdown box, yes the If statement is the right answer. You’ll need to apply below formula to the Default property of the third Dropdown Box.

But for a supplement, you may have to pay attention to the form’s DisplayMode if you are managing a form from SP list, so I have wrote down a quite complete formula, in which I assume the field types of the columns are Text and contents were supposed to be "Cat" and "Dog", Items of Dropdown 2 were ""Big", "Medium" and "Small", and in Dropdown3 items were "Result1", "Result2" and "Result3":

If(Form.Mode=Edit,
 If((Dropdown1.Selected.Value=”Cat” && Dropdown2.Selected.Value = “Big”)||
 (Dropdown1.Selected.Value=”Cat” && Dropdown2.Selected.Value = “Medium”) || 
 (Dropdown1.Selected.Value=”Cat” && Dropdown2.Selected.Value = “Big”),
 ”Result1”,
 (Dropdown1.Selected.Value=”Dog” && Dropdown2.Selected.Value = “Big”)|| 
 (Dropdown1.Selected.Value=”Dog” && Dropdown2.Selected.Value = “Small”),
 “Result2”,
 “Result3”
 )
)

Anyway, in If statement you could list all possibilities and the corresponding result, and the last one is the else result.

Additionally, is there any relationships among the three columns? For example while Cat is selected, only Big and Small could be selected, then only one item could be selected in the dropdown 3?

If it is like my example, you will need to create cascading dropdowns. Then please reference to the official document

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/dependent-drop-down-lists

and other threads like https://powerusers.microsoft.com/t5/Building-Power-Apps/cascading-dropdown-lists/m-p/43123

Since there is not enough info of your scenario, if you have further questions, please let us know.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.