Answered

Checkbox - not able to save selection

(2) Share

Report

Posted on by HW-20050933-0

Hi.

I have some fields, where I have added check boxes and none of them keeps the selection, when I save the form. Next time I open the form, the checkbox is blank.

Does it make a difference if the field is Number or text? I delete the Datacard and add a checkbox instead.

Thanks a lot in advacence.

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Suggested answer

Valantis 5,581 on at

Like (2)

Report
Copy link

Link copied!

Hi @HW-20050933-0,

Yes, column type makes a big difference. A Checkbox control saves a boolean (true/false) value, but if your underlying column is Number or Text, the Patch or SubmitForm doesn't save correctly because the types don't match.

The fix depends on what you want:

If using Dataverse: use a Yes/No (boolean) column type. The Checkbox control maps directly to it and SubmitForm works without any extra configuration.

If using SharePoint: use a Yes/No column type in the SharePoint list. Same result.

If you must use a Number or Text column, you need to manually handle the value in the DataCard Update property:
- For Number: If(CheckboxControl.Value, 1, 0)
- For Text: If(CheckboxControl.Value, "true", "false")

Also check that you didn't just replace the DataCard content but left the DataCard Update property pointing to the old default. When you add a custom Checkbox, set the DataCard Update property explicitly to CheckboxControl.Value.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
Suggested answer

Haque 3,293 on at

Like (2)

Report
Copy link

Link copied!
Hi @HW-20050933-0,

Field data type matters if you use ShartePoint:

Checkboxes work best with Yes/No (Boolean) fields in SharePoint.

If your SharePoint field is a Number or Text type, the checkbox won’t bind correctly and won’t save/load as expected.

If using a standalone checkbox outside a form:

You must manually patch the value back to the data source on save.

Also, on form load, set the checkbox’s Default property to the current record’s value.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
Kalathiya 2,249 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @HW-20050933-0,

I have couple of questions:

#1. Could you please share the screen so we can review your implementation and try to help you?

#. Does it multi select choice column? If yes, Have you replaced dropdown control with Gallery with Checkbox field for handle multiple select choice? If yes, On check property have you stored value in collection. What is your collection name, choice set name and field name?
#3. If no, it's yes/no column there you have added checkbox?
#4. Assuming you have added checkbox inside the Datacard in form control.

Also you can refer below blog for how to store multiple select value in table?

Link: https://platformsofpower.net/patching-complex-dataverse-columns-with-power-apps/

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No
HW-20050933-0 30 on at

Like (1)

Report
Copy link

Link copied!

Sorry for not having provided enough details.

I use Dataverse and one of the fields, that is causing me problems, is Legal requirement, pls see below:

If the Checkbox is selected, the value if the field is 10 - Update on Datacard:

If(CheckboxCanvas2.Checked, 10, 0)

and this number is included in "Idea rating" (changes from 19 to 29). In the table, the field has Datatype "Whole number". So no multiselect for this field.

I have deleted the original datacard and added the Checkbox.

Hope this clarifies my problem :-)

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,249 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hello @HW-20050933-0,

Got it. Assuming this Yes/No data type column in Dataverse.

Field Datacard - Update Property:

If(CheckboxCanvas2.Value,'Is Test (Test tables)'.Yes,'Is Test (Test tables)'.No) //Replace with your - 'Is Test (Test tables)' - Choice Set name

Checkbox - Default Property:

If(_test.'Is Test' = 'Is Test (Test tables)'.Yes,true,false) //_test - Replace with your form item property variable name. //'Is Test (Test tables)' - Replace with your choice Set name.

Note: You can retrieve the choice value by staring the column name and then it will show in suggestion. For example, "Is Test" is the column name, and "Test Tables" is the my table name.

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No
HW-20050933-0 30 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kalathiya.

Thanks for your reply. The data type is Whole number for the column and I need to get the value 10, when box checked to be able to include the number in the calculation of "Idea rating".

Was this reply helpful? Yes No
Kalathiya 2,249 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hello @HW-20050933-0,

Could you please try this?

If(CheckboxCanvas2.Checked,Value(10),Value(0))

If this helped resolve your issue, please click “Does this answer your question?” so the solution is marked and easier for others to find.

Was this reply helpful? Yes No
HW-20050933-0 30 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kalathiya.

The value is now saved in the table (shows the value 10 on the selected project). Unfortunately, the selected value (checked) doesn't show on the form, when re-opening the project in the app. But we are getting close :-)

Was this reply helpful? Yes No
Kalathiya 2,249 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hello @HW-20050933-0,

Thanks for confirming.

Checkbox - For Default property code.

Parent.Default = Value(10)

If this helped resolve your issue, please click “Does this answer your question?” so the solution is marked and easier for others to find.

Was this reply helpful? Yes No
HW-20050933-0 30 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kalathiya

I can't find Default property for the Checkbox:

Am I missing something or just gone blind?

Thanks

Was this reply helpful? Yes No