Dropdown Filtering

[ronanf16]

Hi,

I really need help with a formula. It should be very simple but i cant understand why mine is not working. I have a spreadsheet with a list of identities "HB" and a corresponding list of "Property". i simply want to select a single property from the first drop down (right now it is displaying duplicates which i don't want) and then for the second dropdown to display the "HB" related to the selected property only. 

Please help me with a formula that works, there is a time pressure with this.

Thankyou!

First Dropdown (Dropdown2) : Distinct(Table1,Property)

Second dropdown (Drodown3) : Filter(Table1,HB=Dropdown2.Selected.Property)

[troytec]

Hey @ronanf16 ,

I saw something Shane Young did using cascading dropdowns : https://www.youtube.com/watch?v=pkZG2boN7jQ&t=579s

Let me know if you get stuck after going through his steps, I'll try replicate and give you a hand.

[eka24]

Since dropdown 2 is distinct, try using;

Filter (Table1,HB=Dropdown2.Selected.Result)

On Dropdown 3

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

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.

[ronanf16]

the problem is even though i have Distinct in the formula on the first dropdown i am still getting duplicated results.

on the second dropdown i can only use .selected.property  as any other word eg. Value,Result,Text  is throwing up an error

[ronanf16]

@troytec i have tried following the step n the video and while the dropdowns still function it seems that no filtering is happening and no distinct fields are displaying, only the full listing for both.

[troytec]

Do you have a screenshot of your data? It will help check what it going on.

[ronanf16]

here is a screenshot of how the table looks, it is over 100 rows of data.

[troytec]

I've just replicated and works okay. If I use the "Selected.Value" it comes up as a number, so we need to use the "Selected.Result".

Can you check that the dropdowns you are referring to in the formulas are the actual ones you are filtering? You need to see this:

[ronanf16]

do you put this formula in the on select tab or the items tab?  

it seems that when i type "selected" that it only gives me the option of Property or HB.

can you show me the second formula?

if i share the App and Data with you could you fix this for me? it is not sensitive information and i am under real time pressure to et this fixed today.

[v-qiaqi-msft · Accepted solution]

Hi@ronanf16,

Do you want to populate the second dropdown(HB) based on the selected from the first dropdown(Property)?

I think there is something wrong with the syntax in your formula.

I have a test on my side, please take a try as below.

Set the Items property of the first Dropdown(Property) as below

Distinct(Table1,Property)

 Set the Items property of the second Dropdown(HB) as below

Filter(Table1,Property=Dropdown1.Selected.Result).HB

Note: Dropdown1 is the first Dropdown(Property), please check the GIF for reference.

Please take a try as above. Contact me at your convenience.

Best Regards,

Qi