Announcements
I am trying to super simplify the ability to search a table. One though is that I could create dropdown that would list the column names of a table and provide a text field to enter text for a search on the column chosen. Is this possible? Either that or provide a second dropdown that had the results of the column chosen from the first dropdown.
Hi @futr_vision,
You can just use the Search function on the Items property of your gallery. Search only works with columns that are of type Text. This would looks something like:
Search('Data source', TextInput1.Text, "Column 1", "Column 2", "Column 3") // Change TextInput1 to your Text Iput name // Change Columns 1, 2, 3 to Columns in your Data source you would like to search
Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C
Hi @futr_vision ,
You can do it and it is possible. In my recent project I did the same.
I've created a dropdown and in that I manually entered the column names ( because I didn't need all columns) and had a text input next to it. then applied a filter formula.
Same way you can achieve it.
Do you want to select column names from dropdown?
Actually, we could using the following formula to achieve this:
ClearCollect( colTable1, TableName ); // get the column headers Set( varColumnNames, Distinct( Ungroup( MatchAll( JSON( colTable1, JSONFormat.IgnoreBinaryData ), "([^""]+?)""\s*:" ).SubMatches, "SubMatches" ), Value) )
Then populate the dropdown with the variable:
varColumnNames
This sounds like a super simple solution if I can use a single text box and search columns that are searchable and that I designate should be searched. I'll need to test this out as I get further down the road with this build.
Creating a dropdown to select a column to search could be overkill if I can just use a search box as @AARON_C suggested. However, I can see using a dropdown if I need to do something other than or in addition to a text search. For example, if one of my columns was a start date of the type date then selecting that in the dropdown might swap out the text field for search with a date picker.
I can see going this route if I want to programmatically grab the column names. I don't want all of the columns however. I think @swaminawale might have hit on a more simplistic and precise way of handling this although it does involve the manual input of the column names. I need to think about this a little more. Ideally I want to get to a solution that is going to save me real estate in my app since the results section is going to have a lot of data and I prefer not having to make the user scroll or navigate around alot.
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 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
