Announcements
Hi,
I want to be able to filter this gallery by the manufacture and after that i want the user to be able to enter a partnumber to search the gallery. I have the search box working at the moment but not the filter.
Also is it possible to display the value in a combo box in a text box?
You can wrap a filter around the search function to include filtering by manufacturing.
Filter( Search( '[dbo].[AirTools]', TextSearchBox1.Text, "PartNumber" ) , ManufactureDropDown.Selected.Value = ManufactureSQLField )
You can display the selected value in a combo box in a text field. This example assumes the combo box isn't multi select.
ManufactureDropDown.Selected.Value
Hi Jeff,
That function doesn't seem to work. It dosnt like the "Selected.Value" part, saying the "." is invalid use.
Is ProductGroup the actual name of the control? In my example I called it ProductGroup based on the red arrow in the screenshot and assumed it was a dropdown control. Is the control a Dropdown or Combo box and is it single or multi select?
Yes, "ProductGroup" is the name of that drop down that has "Dotco" in it. To the right is the "TextSearchBox1".
Can you use the intellisense to see what values it is expecting. To do his remove ".Selected.Value" from ProductGroup and the type a period after ProductGroup and then intellisense should provide you with the valid options. One of those options should be "Selected". Select "Selected" and then type a period and then intellisense should provide you with just one or two options. In most cases you will see "Value" or "result". Select which ever option appears.
If "Selected" ends up not being an option then can you provide a screenshot of the property pane (both Properties and Advanced) for ProductGroup.
Once I placed "." after ProductGroup nothing was suggested. just blank.
Here are the details you asked for.
The screenshots you provided are of the gallery properties, can you post the properties for the ProductGroup control which looks like a drop down.
Sorry Jeff I rushed that response. Here are screenshots of the properties and advanced tab for the ProductGroup Dropdown.
Hi @Jeff_Thorpe,
I managed to get your function working. I removed that drop down box and replaced it with a combo box.
Thanks for your help.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 401 Most Valuable Professional
11manish 201 Super User 2026 Season 2
MS.Ragavendar 128 Super User 2026 Season 2
