Dropdown issue

(1) Share

Report

Posted on by CU29040305-0

I have a 'Category' dropdown and a 'Sub-Category' dropdown. When I pick a Category, the second one stays empty. I'm using a SharePoint list for both

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

@CU29040305-0

Step 1: Set Up the "Parent" Dropdown

First, ensure your Category dropdown (let’s call it drpCategory) is pulling the unique list of categories.

Property: Items

Formula: Choices(YourSharePointList.Category) or Distinct(YourSharePointList, Category)

________________________________________

Step 2: Configure the "Child" Dropdown

This is where the magic happens. You need to tell the Sub-Category dropdown (drpSubCategory) to look at what was picked in the first one.

Select drpSubCategory.

Go to the Items property in the formula bar.

Use the Filter function.

The Formula:

Code snippet

Filter(

SubCategoryList,

CategoryColumnInSP = drpCategory.Selected.Value

)

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@CU29040305-0,

List 1

List 2

Power Apps Drop Down 1

Formula Used Items Property of Drop Down 1 : Sort(Categories,Title,SortOrder.Ascending)

Power Apps Drop Down 2

Formula Used Items Property of Drop Down 2 :

Sort(Filter(SubCategories,Category.Value=Dropdown1.Selected.Title),Title,SortOrder.Ascending)

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Suggested answer

TechFreak 149 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

This is a common setup when working with dependent dropdowns in Power Apps using a SharePoint list.

What’s happening is the Sub-Category dropdown isn’t being filtered based on the selected Category, so it ends up showing nothing.

You need to connect the second dropdown to the first one using a Filter.

Assuming your SharePoint list has:

A column for Category

A column for Sub-Category

Set the Items property of your Sub-Category dropdown like this:

Filter( YourListName, CategoryColumn = DropdownCategory.Selected.Value )

If your Category column is a Choice column, then use:

Filter( YourListName, CategoryColumn.Value = DropdownCategory.Selected.Value )

Also make sure the Sub-Category dropdown is displaying the correct field:

DropdownSubCategory.Value = "SubCategoryColumnName"

A couple of things to double-check:

The Category values in SharePoint match exactly (no extra spaces or mismatched text)

The Sub-Category column actually has data linked to the selected Category

The DropdownCategory.Selected.Value is returning the expected value (you can test with a Label)

So basically, the second dropdown isn’t “empty” — it just needs the correct filter tied to the first dropdown.

Best regards,
Satyam Pandey

✅ If this helped solve your issue, please mark it as Accepted Solution so others can find it quickly.

❤️ If it was helpful, please click Yes on “Was this reply helpful?” or give it a Like.

🏷️ For follow-ups, feel free to tag @TechFreak

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No