web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter choice column b...

Power Apps

Answered

Filter choice column based on dropdown selection

(0) Share

Report

Report

Posted on by JimmyW

2,567

Hi I am trying to create cascading dropdown menu from two Choice columns in a SharePoint list.

The first dropdown i have.

Distinct(Choices(CategoryData.Category),Value)

My second dropdown should filter based on the selection from the first.

Distinct(Filter(CategoryData,Category.Value = Dropdown1.SelectedText.Value),SubCategory1.Value)

Now the above seems to work but im not sure it is the correct way and do i need to use distinct or can i use only Filter?
Not sure if i should use Choices( or Distinct( or a combination.

I have tried using only filter and adding choices( but im new to this so the code keeps giving me errors or wont load any data.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@JimmyWork
In your first formula the DISTINCT function is redundant. The CHOICES function will already produce a list of unique values.

#1
Choices(CategoryData.Category)

The SELECTEDTEXT property has been deprecated. To ensure your app is future-proofed do not use it.

#2
Distinct(Filter(CategoryData,Category.Value = Dropdown1.Selected.Value),SubCategory1.Value)

Those are my two suggestions for improvement

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney Thank you so much for the help.
I have been using SelectedText, when i try to change this in some places i can only use for example Dropdown1.Selected
If i type Dropdown1.Selected.Value i get an error saying Expected Record value. If i only use Dropdown1.Selected it works fine but i wonder if that is the correct way.

Join the conversation