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.
You can easily create a table using Power Apps (make.powerapps.com for most common situations, but not all capabilities are implemented there. When you need to meet the requirements described in Create and edit tables in Microsoft Dataverse, you can achieve them by creating or editing tables using the Solution Explorer.
The customization prefix is part of the name of any table you create. This is set based on the solution publisher for the solution you’re working in. If you care about the customization prefix, make sure that you are working in an unmanaged solution where the customization prefix is the one you want for this table. More information: Change the solution publisher prefix
From Power Apps select Solutions from the left navigation pane, and then on the toolbar, select Switch to classic. If the item isn’t in the side panel pane, select …More and then select the item you want.
In the All Solutions list open the unmanaged solution you want.
In the solution explorer Components node, select the Entities node.
While viewing tables, select New to open the form to create tables.
The form has two tabs. The General tab is for entity options. The Primary Field tab is for options about the special single line of text column that each table has that defines the text shown when there is a link to open the table in a lookup column.
For information about each section see the following:
Note
You can also make the table a custom activity. This choice changes some of the default option values. More information: Create a custom activity table
After you have set the required options for the table, click to create the custom table.
In the Primary Field tab you can usually accept the default values for the primary column, but you have the following options:
Field | Description |
---|---|
Display Name | Enter the localizable label that will be displayed for this column in forms and lists. The default value is Name. |
Name | Set the name used in the system for this column. The default value is <customization prefix>_name |
Maximum Length | Enter the maximum length for the column values. The default is 100. |
Note
These options do not apply if the table is an activity table. More information: Create a custom activity table
In the General tab, some of the options are required before you can save the table.
Field | Description |
---|---|
Display Name | This is the singular name for the table that will be shown in the app. This can be changed later. |
Plural Name | This is the plural name for the table that will be shown in the app. This can be changed later. |
Name | This column is pre-populated based on the display name you enter. It includes the solution publisher customization prefix. |
Ownership | You can choose either user or team-owned or organization owned. More information: Table ownership |
While viewing tables, select the table you want to edit, or continue editing a new table you have just saved.
Note
Standard tables or custom tables that are part of a managed solution may have limitations on changes you can apply. If the option is not available or is disabled, you are not allowed to make the change.
The following options can be set once and cannot be changed after you set them. Take care to only set these options when you need them.
Option | Description |
---|---|
Activities | Associate activities to records for this table. |
Business process flows | Create business process flows for this table. More information: Create a business process flow to standardize processes |
Connections | Use the connections feature to show how records for this table have connections to records of other tables that also have connections enabled. |
Feedback | Let customers write feedback for any table record, or rate table records within a defined rating range. More information: Enable a table for feedback/ratings |
Notes | Append notes to records for this table. Notes include the ability to add attachments. |
Queues | Use the table with queues. Queues improve routing and sharing of work by making records for this table available in a central place that everyone can access. |
Sending email | Send emails using an email address stored in one of the fields for this table. If a Single Line of Text field with format set to email doesn’t already exist for this table, a new one will be created when you enable sending email. |
The following properties can be changed at any time.
Option | Description |
---|---|
Access Teams | Create team templates for this table. |
Allow quick create | After you create and publish a Quick Create Form for this table, people can create a new record using the Create button in the navigation pane. More information: Create and design forms When quick create is enabled for a custom activity table, the custom activity is visible in the group of activity tables when people use the Create button in the navigation pane. However, because activities don't support quick create forms, the main form is used when the custom table icon is clicked. |
Areas that display this table | In the web application, choose one of the available sitemap areas to display this table. This setting doesn't apply to model-driven apps. |
Auditing | When auditing is enabled for your organization. Auditing allows for changes to table records to be captured over time. When you enable auditing for a table, auditing is also enabled on all its fields. You can select or clear fields that you want to enable auditing on. |
Change Tracking | Enables data synchronization in a performant way by detecting what data changed since the data was initially extracted or last synchronized. |
Color | Set a color to be used for the table in model-driven apps. |
Description | Provide a meaningful description of the purpose of the table. |
Document management | After other tasks are performed to enable document management for your organization, enabling this feature allows for this table to participate in integration with SharePoint. |
Duplicate Detection | If duplicate detection is enabled for your organization, enabling duplicate detection allows you to create duplicate detection rules for this table. |
Enable for mobile | Make this table available to the Dynamics 365 for phones and tablets apps. You can also make this table Read-only in mobile. If the forms for a table require an extension not supported in Dynamics 365 for phones and tablets apps, use this setting to ensure that mobile app users can't edit the data for these tables. |
Enable for phone express | Make this table available to the Dynamics 365 for phones app. |
Mail merge | People can use this table with mail merge. |
Offline capability for Dynamics 365 for Outlook | Whether data in this table is available while the Dynamics 365 for Outlook application isn't connected to the network. |
Primary Image | System tables that support images already have an Image field. You can choose whether to display data in this field as the image for the record by setting this field to [None] or Default Image. For custom tables, you must first create an image field. After you create one, you can change this setting to set the primary image. More information: Image columns |
Reading pane in Dynamics 365 for Outlook | Whether the table is visible in the reading pane for the Dynamics 365 for Outlook app. |
Use custom Help | When enabled, set a Help URL to control what page users see when they select the help button in the application. Use custom help to provide guidance specific to your company processes for the table. |
You can also make the following changes:
As someone with the system administrator security role, you can delete custom tables that aren’t part of a managed solution.
Important
While viewing tables, select the command on the toolbar.
While viewing a table use the delete command on the menu bar.
Warning
Deleting a table that contains data will remove all the data. This data can only be retrieved by backup of the database.
Note
If there are any table dependencies you will get a Cannot Delete Component error with a Details link you can use to discover information about why the table cannot be deleted. In most cases, this will be because of a dependency that has to be removed.
There may be more than one dependency blocking the deletion of a table. This error message may only show the first one. For an alternate way to discover dependencies, see Identify table dependencies
You can identify dependencies that will prevent a table from being deleted before you try to delete it.
Published dependencies will block deleting a table. Internal dependencies should be resolved by the system.
Note
A very common dependency is that another table form has a lookup column for the table you are deleting. Removing the lookup column from the form will resolve the dependency.
To create the table as an activity table, use the same steps described in this topic except select Define as an activity table.
An activity table is a special kind of table that tracks actions for which an entry can be made on a calendar. More information: Activity tables.
When you set this option some table properties are not compatible. An activity table has to conform to standard behaviors that all activity tables use.
The primary column Name and Display Name will be set to Subject and you cannot change this.
The following options are set by default and cannot be changed:
The following options cannot be set:
Some options are only used when creating a virtual table.
Option | Description |
---|---|
Virtual Entity | Whether the table is a virtual table. |
Data Source | The data source for the table. |
More information: Create and edit virtual tables that contain data from an external data source
Create and edit tables in Dataverse
Tutorial: Create a custom table that has components in Power Apps
Create a solution
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 tables in Microsoft Dataverse - Training
Explore secure data management with Dataverse, learning how to create tables and import data into a cloud-based storage system.
Certification
Microsoft Certified: Power Platform Developer Associate - Certifications
Demonstrate how to simplify, automate, and transform business tasks and processes using Microsoft Power Platform Developer.
Documentation
Table definitions in Microsoft Dataverse - Power Apps
Learn how to programmatically work with table definitions in Microsoft Dataverse.
Short video tutorial on creating new data columns - Power Apps
Learn to add new columns with our short video for enhanced data capture in your apps
Query and visualize hierarchical data with Power Apps - Power Apps
Describes how to query and visualize hierarchical related data.