cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
keihimekawa
Helper III
Helper III

Checkboxes in gallery keeps refreshing when typing something in "search" textbox

Hi everyone. I have checkboxes incorporated in my gallery and a textbox which serves as "employee name search box".

The checkboxes allows users to select multiple rows and save them by batch. This is working just fine until I decided to type in something in the searchbox. The gallery searches for the employee but the initial items selected by the user got refreshed. All items selected by the users got unchecked.

Is there a way to not refresh/reset the checkboxes when the user searches for an employee name?

I have a filter in my gallery "textboxsearch.text in empnamecolumn"

 

1 - I select multiple items

1.png

 

2- I search for a particular employee name

2.png

 

3 - initial checked selection are gone when I clear the searchbox

3.png

1 ACCEPTED SOLUTION

Accepted Solutions
Mr-Dang-MSFT
Power Apps
Power Apps

Hi @keihimekawa ,

It sounds like:

  • You have a gallery for making selections.
  • The gallery's items change as the text in the search box changes.

 

In a scenario involving selection of items, it is best to hold the selection in a collection and not rely on the checkbox alone. Then you can set the Default property of the checkbox to see if it is in the collection. You will need actions on the checkbox to remove and add records to the collection upon checking and unchecking the box.

 

There's a good example of this pattern in the App in a Day workshop for Device Orders (see the PDF for Module 1):

https://aka.ms/AppInADay

 

  1. Download the zip file.
  2. Open the zip file.
  3. Browse the contents of the zip to find "01-Power Apps Canvas App Lab Manual.pdf"
  4. The content on checkboxes starts around page 28.

Let me know if you were able to implement the checkbox behaviors.

View solution in original post

5 REPLIES 5
Mr-Dang-MSFT
Power Apps
Power Apps

Hi @keihimekawa ,

It sounds like:

  • You have a gallery for making selections.
  • The gallery's items change as the text in the search box changes.

 

In a scenario involving selection of items, it is best to hold the selection in a collection and not rely on the checkbox alone. Then you can set the Default property of the checkbox to see if it is in the collection. You will need actions on the checkbox to remove and add records to the collection upon checking and unchecking the box.

 

There's a good example of this pattern in the App in a Day workshop for Device Orders (see the PDF for Module 1):

https://aka.ms/AppInADay

 

  1. Download the zip file.
  2. Open the zip file.
  3. Browse the contents of the zip to find "01-Power Apps Canvas App Lab Manual.pdf"
  4. The content on checkboxes starts around page 28.

Let me know if you were able to implement the checkbox behaviors.

View solution in original post

@Mr-Dang-MSFTyou are awesome! It worked! Thank you so much for sharing the "App in a day" workshop files!

Hi @Mr-Dang-MSFT - I added radio buttons on the gallery and a textbox wherein users can enter a comment if they selected "No".

Radioboxes also resets just like the checkbox before. Should I do a patch function on the collection for Selected items? I tried doing this but apparently, new items are added on the collection. Aplogies if I have too many questions. I'm still trying to familiarize my way around PowerApps.

Hi @keihimekawa ,

When a gallery's Items change due to it being filtered/searched, the values that have been typed or selected in its controls change as well. Those values are not saved anywhere. We use collections so that even if the gallery changes, the values in the collection remain the same.

 

You would be on the right track in using the Patch() function. If you are selecting a radio control and typing into a text box, you would set the OnChange property of the control to Patch the values to the respective columns in the collection.

 

Some caveats here: 

  • Is the gallery's Items property pointing to the same collection that you want to update?
    • If a gallery is set to a collection, and you make changes to that collection, the gallery may reload to reflect the changes.
    • If the gallery is set to another data source and you make changes to the collection, you won't be affected.
  • The OnChange property of the text input box will execute its actions (Patch in your case) even with changing one character. You might want to turn the DelayOutput property to true so that the actions don't execute until you press enter or leave the text input box.

Thank you @Mr-Dang-MSFT ! It worked!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,727)