Filter based dropdown

[luisabsg]

Hello how are you?

So I can filter my gallery using the dropdown, right?

I have a dropdown on my form that is taken from my share points list and the dropdown column is of type Person.

Can I filter my gallery based on what I write in this dropdown?

Ex: I know that to filter using Text Input, I use this formula:

Filter('SPList';StartsWith(ColumnName.DisplayName;TextInput1.Text))

How do I do it using dropdown?

[Drrickryp]

@luisabsg 

Filter(splist,columnname.DisplayName=dropdown.Selected.Value) for a person type column.

[Abhilash_Swain]

Hi @luisabsg ,
Please try 
Filter('SPList';StartsWith(ColumnName.DisplayName;Dropdown1.Selected.value))

Please like to support and mark as a solution If this helps. 🙂 

[luisabsg]

Doesn't work it 😞

[luisabsg]

doesn't work it 😞

[Abhilash_Swain]

Hi @luisabsg ,
There is a syntax error in your formula in StartsWith section.

Check this.

Please like to support and accept if it answered your query.:) 

[luisabsg · Accepted solution]

I managed to solve it another way but thank u for help