cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jesenavaranjan
Level: Powered On

Power apps

Hi, I have a question about the Filter within a Browse Gallery.

I want to filter the gallery by search items by a dropdown menu.

I.e. I want the search to return the iterms that are searched within said catogeries

Can anybody please help  out?

There's an attached picture too.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Power apps

Hi Jes, What is the name of the column that will be showing in your dropdown control? What are the names of the columns that you wish to search for instances of the text that will be typed into the TextInput control?

View solution in original post

9 REPLIES 9
Super User
Super User

Re: Power apps

Hi @jesenavaranjan,

It sounds like you want to filter your datasource by the Dropdown control selection and then search the result by the text in the TextInput control in several fields.  

Search(Filter('Test list JN', Dropdown1.Selected.ID = YourFieldName.ID),TextInput1.Text,"SomeField","Anotherfield","YetAnotherField")

In the formula above, the ID is used just as an example.  You can match any value in the field with a value in the dropdown, even if it doesn't show in the window of the dropdown control.

 

However, you can also combine the formula in a single filter if you just wanted to filter the TextInput.Text in a single field.

Filter('Test list JN', Dropdown1.Selected.ID = YourFieldName.ID && TextInput1.Text in SomeField)
jesenavaranjan
Level: Powered On

Re: Power apps

HI!

 

I'm actually looking to filter the actual search text by the column selected in the dropdown?

So for example of 'Column 1' was selected. I want to the filter the gallery by the search data in column 1. 

 

So I'm a little confused still by what you said above 

 

1) The formula goes in the 'OnSelect' in the gallery right?

2) What is the YourFieldName.ID? Is that the text type?

3) What do you mean, "Some Field", Other etc.

 

Please and thank you very much 😄

Jese

jesenavaranjan
Level: Powered On

Re: Power apps

TO add to this, my drop down is COLUMN names not row entries

 

so COlumn 1, column2 etc

 

and then the search looks inside the column 1, 2 as specified 

TopShelf-MSFT
Level 10

Re: Power apps

Hi @Drrickryp thanks for your help with this thread so far. Could you review the updated information provided by @jesenavaranjan and some lend further assistance? 

 

@TopShelf-MSFT

Super User
Super User

Re: Power apps

Hi @jesenavaranjan,

I may be misunderstanding what you are trying to do.  It looks like you are trying to filter your datasource (Items property of the gallery) with the Dropdown control and then to Search the results of that filter with the text in your TextInput control.  This this correct?

jesenavaranjan
Level: Powered On

Re: Power apps

Yes - thats right


 Can you help with a solution?

Super User
Super User

Re: Power apps

II believe that I can help you but please specify the following: The name of your datasource The name of the Dropdown control you want to filter on The name of the TextInput control that will supply the text that you want to Search The name of the columns (fields) that you wish to search for the text in your TextInput control.
jesenavaranjan
Level: Powered On

Re: Power apps

The name of my data course 'Test List'

 

Dropdown control - 'Dropdown1)

 

TextInput Control (Text Input 1)

 

In the first instance - I want my dropdown1 to have its Item property as all columns within the database with a text field catogery)

 

Cheers

Super User
Super User

Re: Power apps

Hi Jes, What is the name of the column that will be showing in your dropdown control? What are the names of the columns that you wish to search for instances of the text that will be typed into the TextInput control?

View solution in original post

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,655)