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.
Solved! Go to Solution.
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)
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 😄
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?
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)
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021