cascading with dropdowns and sharepoint list

[DAVIDPOWELL]

I have 2 dropdowns on a form  datasource is the same sharepoint list.

First dropdown1

Distinct(Sales_Commission_Category,Topics)

dropdown2

Filter(Sales_Commission_Category,Topics=Dropdown1.Selected.Result,Subtopic)

my problem:

Topics=Dropdown2.Selected.Result   should be   .Selected.Value   but the ".Value" method will not show up.

Thnks

David Powell

[eka24 · Accepted solution]

That is what you get when you use Distinct. So the formula should be:
Filter(Sales_Commission_Category,Topics=Dropdown1.Selected.Result)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[DAVIDPOWELL]

but now I have repeating values in dropdown2, that are not unique to dropdown 1 

[eka24]

In using cascading dropdowns, there should be a relationship between the dropdown1 and dropdown2. Do the unique values have a link with the other dropdown.

You can give a screen shot

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[DAVIDPOWELL]

attached is my sharepoint list in excel.

Strating with the Column "Topics"

[DAVIDPOWELL]

Distinct(Filter(Sales_Commission_Category,Topics=Dropdown1.Selected.Result),Subtopic)

this ended up working.