Power Apps

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)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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
a
(1)

Report
Copy link

Link copied!
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