cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
luisabsg
Helper V
Helper V

Filter based dropdown

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

6 REPLIES 6
Drrickryp
Super User
Super User

@luisabsg 

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

Abhilash_Swain
Super User
Super User

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

 

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

Doesn't work it 😞

luisabsg_0-1655214775755.png

 

doesn't work it 😞

luisabsg_1-1655214868489.png

 

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

Check this.

Abhilash_Swain_0-1655215525497.png

 

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

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

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,192)