You’re offline. This is a read only version of the page.
I have 5 columns in SP list set to Yes/No type. In my app, whenever I check the checkbox (separate data cards), I want to show it as Yes in my data source. No if unchecked. How can I do this?
Trying to follow along here. Newbie building first power app for teams. Setup data fields in dataverse for teams building out ui or trying. This is not as easy as the videos show… so I have some fields that are yes/no. I want to use check box in UI. How do I tell the check box what data field I want it to record the yes if checked. Default I want to be unchecked for NO. I don’t want the value to be sent to the database until the submit button is pushed. I’m trying to use what powerapps built when I finished the data model. It threw up text fields for the database fields and want to swap a check box instead of text. This seems overly complicated. I guess making pancakes seems complicated if you’ve never done it. 😁
Set Default property of Checkbox to
Share
Report
All responses (
Answers (
19
Parent.Default
Another way to set false for a new form
If(EditForm1.Mode=FormMode.New, false, Parent.Default)
Thanks,
Stalin - Learn To Illuminate
Hi @StalinPonnusamy just a follow up question. How can I reset the checkboxes on New form? It looks like it saves the last entry when creating new one. Please advise. Thanks!
Set the default property of the checkbox to
ThisItem.ColumnName
Set the DataCard to
ColumnName
Yes it's boolean and my backend shows exactly like this.
It worked but how can I show the value on Edit form? After I saved the entry and edit it, it shows blank. I've already set the Update property to
CheckBoxName.Value
Once you have brought in your checkboxes to each data card, set their default to 'Parent.default', make sure the default in the Datacard is set to 'ThisItem.YourYNColumnName' and also change the 'Update' property of the datacard to 'Checkbox#.Value'.
If you want to show specific text for true vs false selection, you can set the 'Text' property of each checkbox to 'If(Self.Value, "true text", "false text")'.
Hope this helps - Good luck!
I assume you are looking to update Datasource right away. It means when you check and UnCheck the checkbox.
Set OnCheck property of Checkbox to
Patch(SPList,ThisItem,{ColumnName:true})
Set OnUncheck property of Checkbox to
Patch(SPList,ThisItem,{ColumnName:false})
Make sure to set the Default property of Checkbox control to
ThisItem.ColumnName
And you may need to Remove the Update property of the DataCard since we saved the data already.
Note: It will be lots of calls Datasource for each check and UnCheck.
If you are not looking to Save immediately then Set the Update property of DataCard to
CheckBoxName.Value
Thanks,
Stalin - Learn To Illuminate
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
