Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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:
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.
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.
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
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Create and manage columns within a table in Microsoft Dataverse - Training
Learn how to create and manage table columns in Dataverse.
Certification
Microsoft Certified: Power Platform Developer Associate - Certifications
Demonstrate how to simplify, automate, and transform business tasks and processes using Microsoft Power Platform Developer.