cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Davis89
New Member

Browse Gallery and search box

 

Hi, I'm trying to get a gallery to be filtered by a value and then be able to use the Search box to filter further by asset number. Is this possible. 

 

I need to filter the Gallery by the below

Filter('Asset Manager', 'Asset area'.Value = "BB8"),

 

Then i'd like to use the search box to further filter, in a previous gallery i used this but i didn't require the first filter.

Filter('Asset number', TextSearchBox1_5.Text)), "Assetnumber")

 

Can the both be merged somehow ? I need BB8 Primary then Asset number for typing in the search box.

 

Thanks 

 

Please Help! 

1 ACCEPTED SOLUTION

Accepted Solutions
ganeshsanap
Memorable Member
Memorable Member

@Davis89 Try using below:

 

Filter('Asset Manager', 'Asset area'.Value = "BB8" && TextSearchBox1_5.Text in AssetNumber)

 


Please click Accept as solution & ‌‌👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

View solution in original post

3 REPLIES 3
Drrickryp
Super User
Super User

Hi @Davis89 

 

With({
       filtrd:Filter(
                     'Asset Manager', 'Asset area'.Value = "BB8"
               )
      },
  Search(
         filtrd,TextInput1.Text,"Field1","Field2",etc
  )
)

 

Hi @Drrickryp , 

 

I'm struggling a bit

 

With({
filtrd:Filter(
'Asset Manager', 'Asset area'.Value = "BB8"
)
},
Search(
filtrd,TextSearchBox1_5.Text,"Asset number",
)
)

 

I'm doing something wrong in the bottom search. 

 

Will this working in the same way as Startswith in a search box where it'll start filtering the asset numbers?

 

also i'm using a Sharepoint Online list.

Thank you so far.

ganeshsanap
Memorable Member
Memorable Member

@Davis89 Try using below:

 

Filter('Asset Manager', 'Asset area'.Value = "BB8" && TextSearchBox1_5.Text in AssetNumber)

 


Please click Accept as solution & ‌‌👍 if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

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.

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.

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 (2,571)