Adding a Search Bar to a Gallery

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (33)

Answers (2)

WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @kevtun1982 ,

You actually search In the Items of the Gallery. Note that Search() is not Delegable, so you will get a Delegation warning and this will not work on data sets larger than your Delegation (500-2000) limit.

Search( Filter( YourListName, --- your gallery filter here --- ), "YourSearchBoxName.Text", "Listings" )

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.

Was this reply helpful? Yes No
AsanKani 710 on at

Like (0)

Report
Copy link

Link copied!

You can read this article. This will help you
How to search and filter records in PowerApps (inc delegation) (collab365.community)

Was this reply helpful? Yes No
kevtun1982 136 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
I am not 100% sure what you mean. I currently have code within my 'Items' of the Gallery. This is for some dropdown filters that I have.
I was hoping to add a search bar also. I am not a coder and I wouldn't know where to add the code you have provided.

Was this reply helpful? Yes No
AsanKani 710 on at

Like (1)

Report
Copy link

Link copied!
@kevtun1982 Gallery Items Property to use below formulae

If(IsBlank(TextInput_Search.Text),DataSource, Filter(DataSource,StartsWith(Column,TextInput_Search.Text)))

TextInput_Search.Text is using for Search Text

Did this post solve your problem? Please click Accept as Solution so that others may find it more quickly.
If you liked my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @kevtun1982 ,

What are the current Items of the gallery?

Was this reply helpful? Yes No
kevtun1982 136 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz
I have provided a snip of everything in the gallery. It is the same Gallery that I added the dropdown menu to.

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@kevtun1982 ,
I simply want the Items property of the Gallery (please provide it in Text) as you have not given this to date. I will then add the search syntax for you. Can you also provide the name of your Search Text box and confirm the field it is searching is Listings.

Was this reply helpful? Yes No
kevtun1982 136 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz
I am really sorry. I probably sound pretty dumb to you. This is entirely my first time messing with code.

So the Items property of the gallery is;

If(
StatusDropdown.SelectedText.Value="All",
NewNCR,
If(
CategoryDropdown.SelectedText.Value="All",
Filter(NewNCR, Status.Value = StatusDropdown.SelectedText.Value),
Filter(NewNCR, Status.Value = StatusDropdown.SelectedText.Value && Category.Value = CategoryDropdown.SelectedText.Value)
)
)

The search box is simply 'SearchBox1'

I was hoping that it could search all fields within the Gallery. I am trying to make it easy for the users to search for a word and for it to load anything with that word in it.

Is this possible?

Kevin

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,797 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi @kevtun1982 ,

Note that Search() is not Delegable, so you will get a Delegation warning on this

Search( Filter( NewNCR, ( StatusDropdown.Selected.Value="All" || Status.Value = StatusDropdown.Selected.Value ) && ( CategoryDropdown.SelectedText.Value="All" || Category.Value = CategoryDropdown.Selected.Value ) ), SearchBox.Text, "Listings", "OtherField1", "OtherField2" )

Replace your other fields on the last two and add any more.

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.

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @kevtun1982 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No