web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Browse Gallery and sea...

Power Apps

Answered

Browse Gallery and search box

(0) Share

Report

Report

Posted on by Davis89

6

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!

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Davis89

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

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

ganeshsanap 1,555 on at

Like
a
(0)

Report
Copy link

Link copied!
@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 ‌‌👍

Join the conversation