Answered

Search Gallery Items by using Dropdowns and Search field

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a gallery that I can currently filter by the two dropdowns (program provider and term approved). The client has asked to be able to search the entire gallery (by ID, program provider, term approved, etc.) and I want to use the Filter by Search textbox for that. Here is my current Items formula for the gallery. How do I add to the formula using the search text field?

Filter('XXXXXXXXXXXXXXXX',If(Filter_ProgramProvider.Selected.Value="All",true,'Program Provider'.Value =Filter_ProgramProvider.Selected.Value), If(Filter_TermApproved.Selected.Value="All",true, 'Term Approved'.Value = Filter_TermApproved.Selected.Value))

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

h-nagao 392 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
To more reduce records by search string , you can use Search() function.
Search( Filter('XXXXXXXXXXXXXXXX',If(Filter_ProgramProvider.Selected.Value="All",true,'Program Provider'.Value =Filter_ProgramProvider.Selected.Value), If(Filter_TermApproved.Selected.Value="All",true, 'Term Approved'.Value = Filter_TermApproved.Selected.Value)) , TextInput.Text, "Search target field1","Search target field2",...)
Filtered results will be reduced by search string again.

Thanks.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@h-nagao For the search target fields, can I search for fields that are not in the gallery? I have about 12 fields, but I am only displaying 1/4th of them.
Verified answer

h-nagao 392 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Lp939,
It's possible to search by non-visible fields, since labels in gallery are just displaying data, Search or Filter are reducing data to display gallery.

Thanks,