Browse Gallery and search box

[Davis89]

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! 

[Drrickryp]

Hi @Davis89 

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

[Davis89]

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 · Accepted solution]

@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 ‌‌👍