cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jkeckard007
Helper III
Helper III

Filtering a Gallery

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
RezaDorrani
Dual Super User
Dual Super User

@jkeckard007 

 

Try 

StartsWith(  AssetTag,TextSearchBox1.Text)

View solution in original post

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

View solution in original post

3 REPLIES 3
RezaDorrani
Dual Super User
Dual Super User

@jkeckard007 

 

Try 

StartsWith(  AssetTag,TextSearchBox1.Text)

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

@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.

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,517)