Function of If statement for dropdown based on the previous dropdown selection

(0) Share

Report

Posted on by NH-09100837-0

Hi Community!

I have to build two dropdown of which if the first dropdown is "A" then the second dropdown will set as "E"

The list of the first drop down:

The second dropdown based on selection :

A = E

B = F

C = G

D = H

How do we do this? and where to set it?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (1)

Report
Function of If statement for dropdown based on the previous dropdown selection

Hi NH-09100837-0,

To achieve this, you can make use of the Switch statement in the DefaultSelectedItems property of the second dropdown.

Items property of the First Dropdown:

["A", "B", "C", "D"]

Items property of the second Dropdown:

["E", "F", "G", "H"]

Here is the DefaultSelectedItems property of the Second Dropdown:

Switch( firstdrpdown.Selected.Value, "A", ["E"], "B", ["F"], "C", ["G"], "D", ["H"] )

Here's how it looks:

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
NH-09100837-0 4 on at

Like (0)

Report

Function of If statement for dropdown based on the previous dropdown selection

Hi @nandit,

It throw me an error. I might look noob here but may I know where do you put the switch statement? I dont find DefaultSelectedItems property.

Was this reply helpful? Yes No
Suggested answer

Ravindra Jadhav 342 Moderator on at

Like (1)

Report
Function of If statement for dropdown based on the previous dropdown selection

using the Switch function in Power Fx, We Can Achive this

Set the Items property of the second dropdown based on the first dropdown selection:

In the OnChange property of the first dropdown (let’s call it Dropdown1):

Switch( Dropdown1.Selected.Value, "A", "E", "B", "F", "C", "G", "D", "H", "" )

Set the Items property of the second dropdown (let’s call it Dropdown2) to this formula:

Table({Value: Switch(Dropdown1.Selected.Value, "A", "E", "B", "F", "C", "G", "D", "H")})

Please Closed the Question, Mark it Solved

If my answer helped resolve your issue, please consider marking it as solved to assist others facing the same problem. Additionally, giving it a like would be greatly appreciated and motivates us to keep helping

Thank You

Ravindra Jadhav

Please Subscribe to https://www.youtube.com/@jadhav_ravi_oo7

Connect On https://www.linkedin.com/in/ravindra-jadhav-powerplatform/

Was this reply helpful? Yes No