Multiselect Column not updating with checkbox selected values

[Vaida]

Hello

I have recently cleated checkboxes instead of combo box for multiselect column. When the checkbox is clicked - the value goes to the collection of that data card.

When the form is submitted for the first time - the column values are updated based on selected checkboxes, but when I update the same form again  - all selected checkbox values are cleared and the column values also.

Is there something additional that I have to do  next to changing the update/default card property, checkbox check/uncheck properties and on Screen OnVisible clear collection formula? Maybe I am missing something..

(Clear(colLabelingChanges); If(IntakeForm.Mode<>FormMode.New,Collect(colLabelingChanges,SharePointIntegration.Selected.'Changes on Labels & IFUs:')))

Thanks!

[v-jefferni]

Hi @Vaida ,

Could you please share more details about your scenario? What is the Items of Gallery that Check boxes are located in? What is the column type of 'Changes on Labels & IFUs:'? 

Best regards,

[Vaida]

Hi @v-jefferni ,

Thanks!

'Changes on Labels & IFUs:' is a multiselect choice column. It was a combobox initially, but I removed the combobox and added the checkboxes as listed below. I didn't used the Gallery, so coded each chekbox separately.

On the Checkbox itself:

1. OnCheck: Collect(colLabelingChanges,"CFN and/or GTIN information")

2. OnUncheck: RemoveIf(colLabelingChanges,Value="CFN and/or GTIN information")

3. Default property of the checkbox: If(IsBlank(Find(CheckboxLBLCFNGTIN.Text,LabelLBLChanges.Text)),false,true)

Properties of the data card where the checkboxes are placed:

1. Update: colLabelingChanges

2. Default : colLabelingChanges

OnVisible Property of the screen:  Clear(colLabelingChanges); If(IntakeForm.Mode<>FormMode.New,Collect(colLabelingChanges,SharePointIntegration.Selected.'Changes on Labels & IFUs:'))

There are no errors in formulas but when I click on the checkboxes  and submit the form for the first time, it is updating the table column data , but when I update the same form and click submit again (without changing anything on the checkboxes) - the checkbox selection (and data in the table column) disappears.

[v-jefferni · Accepted solution]

Hi @Vaida ,

Check the Default property of each Check box:

 If(IsBlank(Find(CheckboxLBLCFNGTIN.Text,LabelLBLChanges.Text)),false,true)

What is LabelLBLChanges.Text? According to my understandings, the Default of each Check box should look up in the collection and see if there is the same text value, as follows:

If(IsBlank(LookUp(colLabelingChanges, Value = CheckboxLBLCFNGTIN.Text)),false,true)

Best regards,

[Vaida]

Thanks @v-jefferni ! I added your formula under my checkbox defaults and it is not updating the Table column and does not delete the the column data even if I update the Form again. However, the checkboxes are not selected anymore after I open the form again, but it sent the values to the table column. 

I guess I am missing something to keep the selected checkboxes checked after I submit form