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?

Note

You can also create columns in your environment using these methods:

• For model-driven apps, select New table column in 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. Learn how to add data to a table in the Dataverse by using Power Query.
• A developer can use Metadata services to write a program to retrieve information about, create, and update columns.

Note

You can create a Lookup column in Power Apps by creating a one-to-many relationship on the table.

For more information about how to create a table column, go to Create and edit columns for Dataverse using Power Apps portal.

Community tools

Attribute Manager is a tool that XrmToolbox community developed for Dataverse. Go to the Developer tools and resources article for more community developed tools.

Note

The community tools aren't a product of Microsoft and Microsoft doesn't offer support for the community tools. If you have questions pertaining to the tool, contact the publisher. More Information: XrmToolBox

Related articles

Types of columns and column data types

Developer Documentation: Column definitions