Answered

Checkbox Input in Form Collection

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am new to PowerApps. My App is collecting information from our employees to evaluate our Contractors performance. Everything is being run through CDS/Dataverse. One of the questions offers multiple choices in the form of Checkbox inputs.

Once the checkboxes are checked, how do I save that data/input to the Dataverse? What command or language should be entered on the OnCheck & OnUnCheck lines? How do I connect each box with the Choices I have in my Dataverse Table? I have scoured the internet looking for the answer, but it seems I can only find stuff on linking to SharePoint. I am trying to do this 100% in the Dataverse.

If this is common knowledge stuff, please forgive a newbie trying to learn.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Checkbox controls are saved as either true or false. If your have a series of choices that are mutually exclusive, then use a radio control. If can choose more than one, consider a list box or combobox, depending on the number of choices. They allow multiple choices.
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi@Urbain_Mora,

Do you mean that you want to save Checkbox value to the Choices field in the CDS?

A Choices field could not be used to compare with a Text value, this is forbidden by PowerApps. If I understand correctly, you have a Choices field and you want to display this options using multiple Checkboxes.

A key is that it is difficult to convert the Text to OptionsetValue which is forbidden by PowerApps.

For your needs, I think it over and update the reply as below.

Here is an alternative solution, I think you could consider a horizon Gallery to insert Checkbox values into the Choices.

Add a blank horizontal Gallery outside the form and insert a Checkbox into it.

Set Items property of the Gallery as:

Choices(QiTests.Check)

Set Text property of the Checkbox as:

ThisItem.Value

Set Default property of the Checkbox as:

If(Checkbox11.Text in ThisItem.Value, true, false)

Set Update property of the data card corresponding to the Check column as:

Filter(Gallery6.AllItems,Checkbox11.Value)

Note: My table name is 'QiTests' and my Choices column is 'Check'.

Then you just need to click the submit button to save the choices back to the Table.

Hope it could help.

Regards,

Qi