Modify choice and choices values

  • 4 minutes

The simplest way to set a choice column value in a table is to use an Edit form. When you add a choice column to the form, it sets up the field to complete the following tasks:

  • Set up as either a dropdown menu (for a single choice) or a combo box (for more than one choice). (When you add an Edit form, Power Apps will set up both with a combo box.)

  • Use the Choices() function to populate the list of values that the user can select. (Again, this is done automatically when using an Edit form).

  • Set the control's current value from the row's column value.

  • Save the value to the table by using the SubmitForm function on a control, such as a button.

Screenshot of a partial Edit form. The single choice column label is Customer Type, showing Family selected. The multiple choice column label is Contact Preferences, showing multiple values of Email, Letter and Phone Call.

When a column is added to the form, it's editable by default. If you want to display the choice column on the form but not have it editable, you can select the control's DisplayMode and change it to DisplayMode.View. (You may need to first navigate to the Advanced tab in the Properties pane on the left side of the canvas and Unlock to change properties.)

Screenshot of the Control type expanded, showing the View option set multi-select and the Edit option set multi-select options.

Use Patch to create or update

You can also create or update choice column values by using the Patch() function. This approach is suitable when updating only a few fields that require little or no user input. For example, on a gallery item you can have a button that, when selected, will use the OnSelect behavior to run a Patch() function to update the row.

The following example shows that a button has been set up on the gallery item to make the account a preferred customer. When the button is selected, the goal is to set the row's Category choice field to Preferred Customer. To accomplish this task, we've added a Make VIP button to the gallery item.

Screenshot of a gallery containing the customer name, preferred delivery, and category information, with the Make VIP button highlighted.

The OnSelect property for the Make VIP button contains the Patch() formula, as shown below:

Patch(Accounts, ThisItem, {Category: 'Category (Accounts)'.'Preferred Customer'})

If your table column uses a Choice set, when you use Patch, you need to prefix your value with the Choice set name, else you get an 'OptionSetValue' error. You can learn what the Choice set name is by going to your Table in Dataverse, selecting that column in Edit mode, and looking for the field Sync this choice with. Just below that column will be the name of the Choice set.

Screenshot showing the Edit column pane with Synch this choice with and the field of Category highlighted.

In a case like this, your Patch() on a button in a similar table would be similar to this:

Patch(Accounts, ThisItem, {'Customer Type': Category.Preferred})