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

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

@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

@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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,089)