web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Setting the value of a...
Power Apps
Unanswered

Setting the value of a checkbox from an Excel data card value

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I think I must be missing something very obvious, but none of the other posts answer my question. 

I have an excel list with a yes/no text field. On my app I want to check a checkbox to toggle the value between yes and no. I have created a checkbox inside the Data card, and hidden the DataCardValue. It looks great and I added this code:

DataCard: Update > If(Checkbox.Value = true, "true", "false")

 

Adding and viewing a record:

I check the checkbox and the DataCardValue changes in the background. When I view the record the value of the DataCardValue is true or false based on if I checked or unchecked the box. 

 

Editing a record:

When I go into a record to edit it, the checkbox is always unchecked. I understand this is because the checkbox sets the Datacard, but the value in the datacard does not set the checkbox. I have tried to add this:

Checkbox: Default > If(DataCardValue33.Value = "true", true, false)

OR

CheckboxB: Default > If(DataCardValue33.Text= "true", true, false)

 

But both of these give me an error that "Name isn't valid. Value isn't regonized..." or "Text isn't regonized...".

Am I missing something to make DataCardValue33 visible to Checkbox? Is there another spot than on the Default property of the Checkbox to update it's value when I go into a record to edit it? 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard