cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jkeckard007
Level: Powered On

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
Dual Super User
Dual Super User

Re: Filtering a Gallery

@jkeckard007 

 

Try 

StartsWith(  AssetTag,TextSearchBox1.Text)

View solution in original post

jkeckard007
Level: Powered On

Re: Filtering a Gallery

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
Dual Super User
Dual Super User

Re: Filtering a Gallery

@jkeckard007 

 

Try 

StartsWith(  AssetTag,TextSearchBox1.Text)

View solution in original post

jkeckard007
Level: Powered On

Re: Filtering a Gallery

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

Dual Super User
Dual Super User

Re: Filtering a Gallery

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

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 214 members 5,341 guests
Please welcome our newest community members: