cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vaida
Helper II
Helper II

Multiselect Column not updating with checkbox selected values

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!

1 ACCEPTED SOLUTION

Accepted Solutions

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,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

4 REPLIES 4
v-jefferni
Community Support
Community Support

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,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Vaida
Helper II
Helper II

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.

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,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Vaida
Helper II
Helper II

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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