Create and edit global choices overview
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
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:
|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
You can also create global choices in your environment using the following:
- Import a solution that contains the definition of the global choices.
- A developer can write a program to create them.
More information: Developer documentation: Customize global choices.
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