Filtering a Gallery

[jkeckard007]

I have two Galleries on my page and one filters the other based on the selected Item.  This works.

I also filter my Second Gallery based on a Hard-Coded Value.   Now I want to also allow the Users to search through that gallery from a text box.  I would like the results from the first two filters to allow values to show and then do a secondary filter as the user types is this possible?

Here is what I have so far Filter(Assets,AssetType.Value= 'Filter Gallery'.Selected.Title, Disposed.Value= "No") 

I want to add something like    AssetTag=TextSearchBox1.Text ...but when I do that the items blank out completely.

Please help.

[RezaDorrani · Accepted solution]

@jkeckard007 

Try 

StartsWith(  AssetTag,TextSearchBox1.Text)

[jkeckard007 · Accepted solution]

Where in my string do I add that I tried that before but I think I got the () in the wrong place.

Thanks for your quick response.

Jennifer

[RezaDorrani]

@jkeckard007 

Filter(Assets,AssetType.Value= 'Filter Gallery'.Selected.Title, Disposed.Value= "No",StartsWith( AssetTag,TextSearchBox1.Text))

this will do an AND operation between the 3 queries

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.