How to create and edit columns

In Microsoft Dataverse columns define the individual data items that can be used to store data in a table. Columns are sometimes called attributes by developers.

Watch this video for a quick overview about columns:

Before you create a custom column, evaluate whether using an existing column would meet your requirements. More information: Create new metadata or use existing metadata?

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

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

Note

You can also create columns in your environment using the following:

• In model-driven apps, select New Column from the form editor.
• Import a solution that contains the definition of the columns.
• Use Power Query to create new tables and fill them with data.
  More information: Add data to a table in the Dataverse by using Power Query.
• A developer can use Metadata services to write a program to create and update columns.

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

You should use the Power Apps portal to create and edit columns for Dataverse unless you need to address any of the following requirements:

• Create a Customer Lookup column.
  • More information: Different types of lookups
• Create a column in a solution other than the Common Data Service Default Solution.
  • More information: Solutions overview
• Define status reason transitions.
  • More information: Define status reason transitions for the Case or custom tables
• Edit multiple columns at once.
• Enable Auditing.
  • More information: Auditing overview
• Enable Column Level Security.
  • More information: Column security tables
• Select whether the column appears in global filter in interactive experience.
  • More information: Configure model-driven app interactive experience dashboards
• Select whether the column is sortable in interactive experience dashboards.
  • More information: Configure model-driven app interactive experience dashboards
• Set a column Requirement Level as Business Recommended.
  • More information: Create business rules and recommendations to apply logic in a model-driven app form
• Set managed properties for a column.
  • More information: Set managed properties for columns

Note

You can create a Lookup column in the Power Apps portal or in solution explorer by creating a One-to-many relationship on the table. But only solution explorer offers the option to create this relationship while creating a column.

Community tools

Attribute Manager is a tool that XrmToolbox community developed for Dataverse. Please see the Developer Tools topic for more community developed tools.

Note

The community tools are not a product of Microsoft and does not extend support to the community tools. If you have questions pertaining to the tool, please contact the publisher. More Information: XrmToolBox.

See also

Create and edit columns for Dataverse using Power Apps portal
Create and edit columns for Dataverse using Power Apps solution explorer
Types of columns and column data types
Developer Documentation: Work with attribute metadata