Create and edit global choices overview

Note

Effective November 2020:

  • Common Data Service has been renamed to Microsoft Dataverse. Learn more
  • Some terminology in Microsoft Dataverse has been updated. For example, entity is now table and field is now column. Learn more

This article will be updated soon to reflect the latest terminology.

A choice (picklist) is a type of column that can be included in a table. It defines a set of options. When a choice is displayed in a form it uses a drop-down list control. When displayed in Advanced Find it uses a picklist control. Sometimes choices are called picklists by developers.

You can define a choice to use a set of options defined within itself (locally) or it can use a set of options defined elsewhere (globally) which can be used by other choice columns.

Global choices are useful when you have a standard set of categories that can apply to more than one column. Maintaining two separate choices with the same values is difficult and if they are not synchronized you can see errors, especially if you are mapping table columns in a one-to-many table relationship. More information: Mapping table columns

Note

If you define every choice as a global choice your list of global choices will grow and could be difficult to manage. If you know that the set of options will only be used in one place, use a local choice.

There are two designers you can use to create or edit global choices:

Designer Description
Power Apps portal Provides an easy streamlined experience, but some special settings are not available.
More information: Create a choice
Solution explorer Not as easy, but provides for more flexibility for less common requirements.
More information: Create and edit global choices for Microsoft Dataverse using solution explorer

Note

You can also create global choices in your environment using the following:

Information in this topic will help you choose which designer you can use.

You should use the Power Apps portal to work with global choices unless you need to address any of the following requirements:

  • Assign colors to options
  • Change the order of options
  • Create a global choice in a solution other than the Common Data Service Default Solution
  • Set managed properties
  • Set properties used for virtual tables
  • View dependencies

See also

Create a choice
Create and edit global choices for Dataverse using solution explorer
Developer documentation: Customize global choices

Note

Can you tell us about your documentation language preferences? Take a short survey.

The survey will take about seven minutes. No personal data is collected (privacy statement).