Answered

Remembering recent searches in PowerApp search box

(0) Share

Report

Posted on by Carmour

I have a gallery on a form that pulls in data connected to an Oracle database. There are thousands of rows in this data set which contain info related to individual project numbers.

On the main form I have the Project Number and Project Name listed. I have a search box at the top that allows people to type in project numbers to find the exact one they are looking for. Once a number is selected this takes them to another detail form.

I was wondering if anyone knows if the capability exists for the search box to remember a user's past searches? So if they click in the search box, a list of recent project number searches will appear or they can type in a new one.

Thanks.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Carmour

We don't have this feature to keep the search history by default. Workaround to another table or some kind of data source to store all search keys/items.

Have a combo box (List existing, Search, and Manuel entry)
Set the items property to Sort(TableQueries.SearchItem,SearchItem)
OnChange of the combo box, need to check the data source whether the search item exists or not. If not exist then insert a new row.
And then navigate to form if the project exists.

Thanks,
Stalin - Learn To Illuminate
Carmour 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the info.
I just have a list box and a data source with all the project numbers.
I don't think this would be a viable solution for what I'm trying to do, as I'm having users search a test box for the data in the data connection. A combo box is not a viable option for me.
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Carmour

From your description, you have text control for the search and List box to display the project. In that case

Set the Default property of List control to
ProjectSearch.Text
Carmour 10 on at

Like
a
(0)

Report
Copy link

Link copied!

The list is a pre-defined BrowseGallery that pulls from a database. (See below)

There are two items in play here: the TextSearchBox and the BrowseGallery that pulls in the data.

Is there an option for the search box to remember what projects a user previously searched for? So they type in 9011999 one time and then come back to the screen and begin to type 90... and the number is available in the search box for them to see.
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

No option to keep the searched item in the cache for now.
Carmour 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. Maybe someday in the future!
CU31070845-0 on at

Like
a
(0)

Report
Copy link

Link copied!

I can provide an inconvenient but working solution. Just set some variables with an And() and the ComboBox' items to a table of those variables when the search is triggered. Be careful in ordering the initialization of variables. It is important to "save" older search terms before overwriting the last variable.

Example for remembering last 3 search terms:

varSearch* are variables
inp_SearchText is a text input control

Trigger's (Icon, Button, etc.) OnSelect:
And(
Set(varSearch3, varSearch2),
Set(varSearch2, varSearch1),
Set(varSearch1, inp_SearchText.Text)
)

ComboBox' Items (formatted as Table):
[varSearch1, varSearch2, varSearch3]