search filter on button click search(not typed in search)

(0) Share

Report

Posted on by AmitLoh-Powerap

608

I am using below function in gallery

Search( IceCream, "choc", "Flavor" )

in gallery control items-

Sort(Search( mysource, searchBar.Text,"Description","Company","Country" ),Country)

Now with 100k records this does not return correct records with fast typing in search box.

What I want is a button next to search text box and then on click it should return.

When I put same Sort(Search( mysource, searchBar.Text,"Description","Company","Country" ),Country) on button click the gallery control does not bring the data.

How to bring searched data in gallery control on button click?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

AmitLoh-Powerap 608 on at

Like (0)

Report

Also How to combine search from a text box with other dropdown filters like country dropdown, product dropdown.
So it should do google type search within selected country and products(this is advance scenario)
search(filter(datasoource) on button clcik search

Was this reply helpful? Yes No
Verified answer

SpencerLynn on at

Like (2)

Report
You can set a context variable when the text changes in the text input.

For the OnSelect of the button
UpdateContext({ searchTerm: <TextInputControl>.Text })
Then you can use this value in your Items property for gallery

Search(<DataSource>, searchTerm, <SearchField>)
This will let you only search when the button is clicked.

Was this reply helpful? Yes No
AmitLoh-Powerap 608 on at

Like (0)

Report

thanks!
How do I combine. For example I have a search button to do google type search and I also have 4 dropdowns with filter exact match search.
I have below in gallery Items but how do I combine search click(do google type search) and if dropdowns are selected do below filter.
Filter(datasource,Country=DropdownCountry.Selected.Value || ProductGroup=Dropdown1.Selected.Value)

Was this reply helpful? Yes No
Verified answer

SpencerLynn on at

Like (0)

Report
You can use the output of the Filter function as the DataSource for the Search function, or vice versa, depending onwhich order you want the searching/filtering done.

Something like:

Search(Filter(<DataSource>,Country=DropdownCountry.Selected.Value || ProductGroup=Dropdown1.Selected.Value), <SearchTerm>, <SearchField>)

Was this reply helpful? Yes No