Update Search Bar Text Using a Gallery OnSelect

(0) Share

Report

Posted on by Calheiro

Hi, everyone.

I need solution to a situation I've put myself in.

I have a search bar (1) which filters a gallery (2) and a button (3) to update my database.

The OnSelect property of the button (3) is to Patch a column of my database with SearchBar.Text
The Items property of my Gallery is: Filter(Database;StartsWith(DatabaseColumn;SearchBar.Text))

As you can see on the image and as mentioned above, my gallery is filtered by the first letters from my SearchBar.Text.
If I press the button (3) it will update my database with the incorrect text as I'm only typing the start of the string to filter my gallery. My objective is when I select an item from the gallery (2) it updates the SearchBar.Text with the label text inside the item for the user to press the button and patch the database (This is a way to ensure the user is typing the correct string for the update).

I can't seem to achieve this kind of interaction while still allwing the Seachbar(1) to filter the gallery.
Does anybody have a hint on what I need to do?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

jrletner 720 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Here is an example I put together showing how to update the value inside of an input when clicking on a text label. You could adapt this to serve your needs.

I have an input control and three text controls. When I click on any of the text controls, the input value updates.
In the Default property of the Input:

The Reset property of the Input:

The OnSelect property of the text labels:

The varReset triggers an update for the Input box, setting it to a Default value of the text in the label, if that variable is empty, then the Input is reset to "" blank.

Was this reply helpful? Yes No
Calheiro 65 on at

Like
a
(1)

Report
Copy link

Link copied!

That was an amazing answer!
I did almost exactly as you, but instead of creating VarReset I used the Reset() function at the OnSelect property of the gallery referencing my Searchbar. It worked as intended! Thank you so much!

Was this reply helpful? Yes No
jrletner 720 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Fantastic! Glad you got that all worked out 🙂

Was this reply helpful? Yes No