News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Adding a Search Bar to...

Power Apps - Building Power Apps

Answered

Adding a Search Bar to a Gallery

Like (0) Share

Report

Report

Posted on 23 Feb 2021 11:28:34 by kevtun1982

136

Is it possible to add a Search Bar that can search all Data within the Gallery.

For instance, if I search 'Open' it would provide me with listings of any item that has the word Open within it?

Categories:

General Questions

All responses Img

All responses (33)

Answers Img

Answers (2)

rroque 350 on 05 Jun 2024 at 11:44:28

Like (0)

Report

Re: Adding a Search Bar to a Gallery

Good morning Warren. This sample works perfectly thank you so much for your help.
Verified answer

WarrenBelz 148,805 Most Valuable Professional on 04 Jun 2024 at 21:24:19

Like (1)

Report
Re: Adding a Search Bar to a Gallery

@rroque ,

Should be like this - assuming ctx_sort_column is a Variable.

SortByColumns( Search( OPTrack_FormsInventoryEnhancedTables, txtSearch.Text, FORM_NO ), ctx_sort_column, If( ctx_sort_order, SortOrder.Ascending, SortOrder.Descending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
rroque 350 on 04 Jun 2024 at 21:20:25

Like (0)

Report

Re: Adding a Search Bar to a Gallery

I'm not sure I know what posting it together means. The two pieces of code is what I'm using now. I added the code to the items property of my list.
rroque 350 on 04 Jun 2024 at 21:19:09

Like (0)

Report

Re: Adding a Search Bar to a Gallery

I'm not sure I know what posting it together means. The two pieces of code is what I'm using now. I added the code to the items property of my list.
rroque 350 on 04 Jun 2024 at 21:13:12

Like (0)

Report

Re: Adding a Search Bar to a Gallery

Warren, here the commented code sorts the columns and the search below it. Both code I have in the items property of my list. So at the moment I can do one or the other but not both. By putting the code in the items property the second one types something in the search box the search kicks off and tries to find whatever is typed in the search box. I really like this behavior.
/*
SortByColumns(
OPTrack_FormsInventoryEnhancedTables,
ctx_sort_column,
If(
ctx_sort_order,
SortOrder.Ascending,
SortOrder.Descending
)
)
*/
Search(OPTrack_FormsInventoryEnhancedTables, txtSearch.Text, FORM_NO)
WarrenBelz 148,805 Most Valuable Professional on 04 Jun 2024 at 21:08:05

Like (1)

Report

Re: Adding a Search Bar to a Gallery

@rroque ,

Posting it all together would be much better.
WarrenBelz 148,805 Most Valuable Professional on 04 Jun 2024 at 21:08:03

Like (1)

Report

Re: Adding a Search Bar to a Gallery

@rroque ,

Posting it all together would be much better.
rroque 350 on 04 Jun 2024 at 20:58:06

Like (0)

Report

Re: Adding a Search Bar to a Gallery

Kevtun. Take a look at my code below you'll find what you're looking for.
WarrenBelz 148,805 Most Valuable Professional on 04 Jun 2024 at 20:57:50

Like (1)

Report

Re: Adding a Search Bar to a Gallery

Hi @rroque ,

Can you please post the code you attempted with both functions.
rroque 350 on 04 Jun 2024 at 20:13:12

Like (0)

Report

Re: Adding a Search Bar to a Gallery

Hi Warren. Because I added sort capable columns to the list items property the search function no longer works. So it's sort or search but not both. Any help would be greatly appreciated.