Answered

Checkboxes inside Gallery reset at after the button is clicked to filter the gallery

Like (0) Share

Report

Posted on 24 May 2023 20:31:55 by Annasuela

Hello - I have a gallery with check-boxes, the gallery is filtered by a set of buttons (located outside of the gallery), button1, button2, button3 etc. When I select the checkbox under button1, press button2, and go back to number one, the checkbox dissapears and the value of all items in the gallery is turned to true.

Checkbox onCheck property is:

Collect(SelectedItems,ThisItem)

Checkbox onUncheck property is:

Remove(SelectedItems,ThisItem)

What type of formula should the button have to retain the checked value of the gallery item?

Thank you

Categories:

General Questions

Using Apps Using Formulas

All responses (3)

Answers (1)

Verified answer

Annasuela 11 on 25 May 2023 at 13:21:43

Like (0)

Report
Re: Checkboxes inside Gallery reset at after the button is clicked to filter the gallery

Here's the solution to this problem:
Checkbox Property:
OnCheck
collect(name,thisItem)
OnUncheck
remove(name,thisItem)
Default Property:
If(IsEmpty(Filter(name, ID = ThisItem.ID)), false, true)
Annasuela 11 on 24 May 2023 at 20:57:29

Like (0)

Report
Re: Checkboxes inside Gallery reset at after the button is clicked to filter the gallery

Hi @mmollet - Thank you for the quick reply.

These checkboxes are located inside a gallery which is connected to a collection. The user will check the completed items and based on their response, the items will display to another gallery which will connect to a SP list. However, when I click any of the below boxes, the card turns to green checkboxes automatically disapear.

Here's an image of my checkboxes. In this instance:
I clicked on the Servers Button
Made my selection
Clicked Voice
Went back to Servers and this is my view
the boxes are supposed to be green and checked

Thank you again
mmollet 3,187 on 24 May 2023 at 20:40:45

Like (0)

Report
Re: Checkboxes inside Gallery reset at after the button is clicked to filter the gallery

I think what is happening is they are resetting bc it is fetching new data. I'm assuming that these checkboxes aren't tied to a column in the data source? If they aren't then you can add a column locally and make it default to false. Then use ThisItem.ThatColumn for the default values of the checkboxes.

Here is the syntax of the AddColumns function
AddColumns( Table, ColumnName1, Formula1 [, ColumnName2, Formula2, ... ] )
Table - Required. Table to operate on.
ColumnName(s) - Required. Name(s) of the column(s) to add. You must specify a string (for example, "Name" with double quotes included) for this argument.
Formula(s) - Required. Formula(s) to evaluate for each record. The result is added as the value of the corresponding new column. You can reference other columns of the table in this formula.

Something like:
ClearCollect(LocalSPListName, SPListName);
AddColumns(LocalSPListName, "isSelected", false);

Checkbox.Default -> ThisItem.isSelected