web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps if value in dropdown i...

Power Apps

Answered

if value in dropdown is x then only show certain value in the next dropdown

(0) Share

Report

Report

Posted on by drossi

134

Hello,

I have two dropdowns which are choices in SP List. When a user selects something in 'Category' I then only want to show certain options in 'Sub Category 1'. So for example, if user selects 'Red' I want only 'Gas' and 'Water' to show in the next dropdown.

Any help greatly appreciated.

Category

Red

Blue

White

Sub Category 1

Gas

Water

Leak

House

Apartment

Office

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @drossi ,
Here's a YT Link by Reza Dorrani.
He has explained Cascading Dropdown which might help you in this scanario.
Hope this helps.
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @drossi :

I assume there is a SP list named DrossiList.

1\Set the Dropdown control 1(Dropdown1)'s Items property to

Choices(DrossiList.Category)

2\Set the Dropdown control 2(Dropdown2)'s Items property to

Switch( Dropdown1.Selected.Value, "Red", Filter(Choices(DrossiList.'Sub Category 1'),Value in ["Gas","Water"]), "Blue", Filter(Choices(DrossiList.'Sub Category 1'),Value in ["Leak","House"]), "White", Filter(Choices(DrossiList.'Sub Category 1'),Value in ["Apartment","Office"]) )

Best Regards,

Bof

Join the conversation