Checkboxes lose their value when editing them using a OneDrive Excel Sheet (EditForm)

[P-M]

Hello once again.

I am experiencing an issue that seems to lie within the fault of how PowerApps reads/saves Data out of an Excel Sheet stored in OneDrive (related to checkboxes).

I use forms to create a set of data, checkboxes working as intended, saving a "true" or "false" value with the right data format (the TRUE/FALSE data format from Excel, I have double checked this). 

The problem occures when trying to edit the data set I have just created. All values load in correctly, except the checkboxes, all of them appearing blank, giving me the error that they require a "true" or "false" value. 

The value is actually saved as "true", however the data format is probably loaded in a text format, not allowing the checkbox to regain its original saved value.

Below is an example showing the checkbox being empty despite the checkbox and the textbox loading the same default value, it being set to true.

(Saving the edited forms now would set each Checkbox to false, as they are now unchecked)

I believe there is no real way of working around this issue. The Checkbox is required to keep its current default value in order to update the EditForm correctly. However the default value cannot be loaded, making me unable to ever edit the Forms I have created within PowerApps, leaving the app I have created useless.

I am open for suggestions and possible work arounds. I was unable to find anything related and would like to keep working with Checkboxes, possibly seeing this issue fixed altogether.

Thank you for your time.

[v-siky-msft · Accepted solution]

Hi @P-M ,

It seems that ThisItems.SoftclientundHeadset code returns a Text value of "True", rather than a Boolean value of true.

The workaround is to apply the if logic to check the return text is "True" or "False" and then output the Boolean value, please try this.

If(ThisItems.SoftclientundHeadset="True", true, false) // Default property of Check box.

Hope this helps.

Sik

[P-M]

Thank you for your reply Sik.

When I've tried something similar like this, it didn't seem to work on the first try.

However after a few tests, it does seem to actually work.

I've always double checked the datas value with a text box, it giving contradicting Information, telling me that Data is being saved incorrectly. 

This is what confused me (This was after saving the data set and editing it again, ofcourse). 

Upon checking the Excel file itself, the checkboxes seem to show the actual value, Hardware being set to True and Softclient being set to False.

With your method all my problems seem to be solved.

Checkboxes that were true upon being saved stay true when they are edited and all data is saved correctly.

While this workaround proves to be useful and help in this kind of situation, I'd rather like if checkboxes were to simply load in the data were fed originally without having to create a workaround for each single one.

Again, thank you for your help.