cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
P-M
Helper I
Helper I

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

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. 

P-M_0-1596544112594.png

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.

P-M_1-1596544223623.png

P-M_2-1596544249360.png

(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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
v-siky-msft
Community Support
Community Support

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

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. 

P-M_3-1596696433353.png

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.

 

 

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,367)