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
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 (3,576)