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)
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications