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

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

@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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

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