Create and edit tables using Power Apps portal

The Power Apps portal provides an easy way to create and edit tables for Microsoft Dataverse.

The portal enables configuring the most common options, but certain options can only be set using solution explorer. More information:

View tables

  1. From the Power Apps portal, select Data > Tables.

    View tables.

    You can filter the tables you see using the following views in a list:

    table views.

View Description
All Shows all the tables
Managed Shows only managed and standard tables
Custom Shows only custom tables
Default Shows only the standard tables

You can also select Group to group tables by the Tags applied to them.

Create a table

While viewing tables, in the menu bar select New table. This will open the New table panel.

New table Panel.

Enter data for the following columns

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 display 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 customization prefix for the Dataverse solution publisher. You cannot change this after the table is saved.
Primary Name This is the only column visible at this point. Edit it if you want to change the Display Nameor Name of the column.
Display name This is the main user-friendly text identifier for your row (typically a name or a number). The value of this column is shown to users when they need to select from a list of rows.
Name This column is pre-populated based on the Display name you enter. It includes the customization prefix for the Dataverse solution publisher. You cannot change this after the table is saved.

Select Enable Attachments to append notes and files to rows for this table.

Select More settings. These settings are optional for a table.

Field Description
Description Provide a meaningful description of the purpose of the table.
table type and ownership Switch the table type to Activity table to create tables that can manage tasks. The type of Ownership defines who can perform operations on a row.
Collaboration Enable features to help users to more easily work together on this table.
Create and Update Settings You can enable quick create forms, giving your app a streamlined data entry experience. Duplicate detection lets you set duplicate detection policies and create duplicate detection rules. Change tracking provides a way to keep data synchronized in a performant way.
Dynamics 365 for Outlook Configure how this table appears in Outlook.

Select Create to continue, this will close the New table panel and display the list of columns.

The Primary Name column of the table is displayed in the list of columns. Select the Primary Name column to edit it if you want to change the Display Nameor Name of the column. The default values are shown below:

Primary Name panel.

Edit a table

While viewing tables, select the table you want to edit.

Select Settings from the menu if you want to edit the Display name, Plural display name or Description for the table.

table Settings.

For other items choose from the tabs.

Fields

See Create and edit columns

Relationships

See Create and edit relationships between tables

Business rules

See Create business rules and recommendations to apply logic in a form

Views

See Create or edit a view

Forms

See Create and design forms

Dashboards

See Create or edit dashboards

Charts

See Create a system chart

Keys

See Define alternate keys to reference rows

Data

View the data in the table. Use the Select view menu to choose from available views for the table or to show all columns.

Select view.

Use the Next Page and Previous Page commands at the bottom of the form to see more data.

Delete a table

As someone with the system administrator security role, you can delete custom tables that aren’t part of a managed solution.

Important

When you delete a custom table, the database tables that store data for that table are deleted and all data they contain is lost. Any associated rows that have a parental relationship to the custom table are also deleted. For more information about parental relationships, see Create and edit relationships between tables.

Note

The only way to recover data from a table that was deleted is to restore the database from a point before the table was deleted. More information: Backup and restore instances

While viewing tables, select the table and select Delete table from the menu.

Delete a table using the Power Apps portal.

If the table has dependencies that prevent it from being deleted you will see an error message. To identify and remove any dependencies, you will need to use the solution explorer. More information Identify table dependencies

See also

Create and edit tables in Dataverse
Create and edit tables using solution explorer