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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,666)