Edit a table

You can edit any custom table that you create. Standard tables or managed custom tables may have limitations about changes you can make.

You can perform the following edits to a table:

• Table properties. More information: Edit table properties using Power Apps

• Columns. More information: Create and edit columns for Microsoft Dataverse

• Relationships. More information: Create and edit relationships between tables

• Keys. Define alternate keys to reference rows

You can also make changes to rows that support the table:

• Business Rules. More information: Create business rules and recommendations to apply logic in a form

• Views. More information: Create or edit a view

• Forms. More information: Create and design forms

• Dashboards. More information: Create or edit dashboards

• Charts. Create or edit a system chart

Note

Standard tables are common tables that are included with your environment that are not System or Custom tables. Managed custom tables are tables that have been added to the system by importing a managed solution. The degree to which you can edit these tables is determined by the managed properties set for each table. Any properties that can’t be edited will be disabled.

Edit table properties using Power Apps

In Power Apps, select Solutions, open the unmanaged solution you want, and then select the table you want to edit. To modify the table properties, select Settings on the command bar to view the Edit table pane as shown below:

For a description of the properties available to edit see, Create a table.

Note

Once enabled, not all table properties can be changed. More information: Table options that can only be enabled

The name of many standard tables may also be used in other text in the application. To locate and change text where this name was used, see Edit standard table messages

Edit a table using Solution Explorer

When editing a table using the solution explorer you need to find the unmanaged solution that you want to add it to.

Open an unmanaged solution

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

2. In the All Solutions list open the unmanaged solution you want.

Change the name of a table

Use the Display Name and Plural Name properties to change the name of the table in the application.

Note

The name of many standard tables may also be used in other text in the application. To locate and change text where this name was used, see Edit standard table messages

Change the icons used for custom tables

By default, all custom tables in the web application have the same icons. You can create image web resources for the icons you want for your custom tables. More information: Change icons for custom tables.

Table options that can only be enabled

The following table lists the options that you can enable for a table, but after these items are enabled, they can’t be disabled:

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.

Enable or disable table options

The following table lists the table options that you can enable or disable 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.

See also

Create a table
Create and edit tables using solution explorer