Answered

Yes/No checkbox

(0) Share

Report

Posted on by biancadevera

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

biancadevera on at

Like (0)

Report
Copy link

Link copied!

Please help @StalinPonnusamy @WarrenBelz @RandyHayes

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @biancadevera

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

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @biancadevera

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!

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report
Copy link

Link copied!

Just to follow up, I'm taking from your original message you are using the Yes/No Type which is a boolean, so in your backend data this wont show as "yes" or "no", it will show as a tick, when yes and blank space when no as follows:

Was this reply helpful? Yes No
biancadevera on at

Like (0)

Report
Copy link

Link copied!
Hi @StalinPonnusamy

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

Was this reply helpful? Yes No
biancadevera on at

Like (1)

Report
Copy link

Link copied!

Yes it's boolean and my backend shows exactly like this.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @biancadevera

Set the default property of the checkbox to

ThisItem.ColumnName

Set the DataCard to
ColumnName

Was this reply helpful? Yes No
biancadevera on at

Like (0)

Report
Copy link

Link copied!

Yep. That worked! Thank you so much @StalinPonnusamy

Was this reply helpful? Yes No
biancadevera on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @biancadevera

Set Default property of Checkbox to
Parent.Default

Another way to set false for a new form
If(EditForm1.Mode=FormMode.New, false, Parent.Default)

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No