Create a custom table
Adding a new table to a Dataverse database is a simple process.
Tip
Make sure that you always verify that the functionality of the table that you want to create already exists in the standard tables listed in the summary unit of this module.
After you have verified existing tables and have decided that you need a new custom table, follow these steps:
In your browser, go to https://make.powerapps.com, From the left navigation menu, select Tables. If you don't see the Tables on the left, you can select More and then in the flyout menu find and select Tables.
Select + New table dropdown at the top and choose Add columns and data.
In the Create a table page, select the pencil icon next to New table and enter the name of your new custom table.
Display name - This is the friendly name of your newly created table.
Plural name - This field is auto populated when you enter a display name, but you can change it if needed. The plural display name is the name of the table in the Dataverse WebAPI and is used when you're interacting with this table from Power Apps or Power Automate.
Schema Name - Under Advanced options, this column is also auto populated when you enter a display name. The prefix was set up when the environment was created and ensures that the tables you create can be exported and imported into other environments without conflicting with other table names. You can change this prefix by updating the prefix on your Publisher for the Dataverse Default Solution. To keep existing apps from breaking, you can't change the name after saving the table.
By default, every table contains a Primary Name column that is used by lookup columns when establishing relationships with other tables. Typically, the Primary Name column stores the name description of the data that is stored in a table's row. You can update the name and display name of the Primary Name until you create the table. Once the table is created, you can't update the name.
When you're finished, select Save.
To add a column to the table, use the following procedure:
In the command bar, select + New > Column.
In the New column properties pane, enter a Display name for the new column you're creating.
From the Data type drop-down list, select the type of column/data will be stored in this column.
Select or tap Save.
You'll learn more about columns in a later module.
Note
All tables have read-only system columns, you will see these by default in your list of columns for the table.
Tip
You will need to assign permissions to the new custom table in an existing or new user security role. This way, users can add, view, edit, or delete data in the table. Refer to unit four in module two if you need additional information on user security roles.