How to create and edit columns

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.

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.

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:

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:

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

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).