How to create and modify Dataverse tables by using the Data workspace

You use the data workspace to create and modify Microsoft Dataverse tables directly in the Power Pages design studio.

Use the Data workspace

  1. Go to Power Pages.

  2. Select a site, and then select Edit.

  3. On the left tool belt, select Data.

Table designer

On the left pane of the Data workspace, the Tables in this site section lists tables that are used in basic forms created in the site. The Other tables section lists all Dataverse tables in the environment.

Data workspace table designer.

Create a new table

  1. Next to Data, select + Table.

  2. Select New table.

  3. In the window that appears, enter a name for your table. By expanding Advanced settings, you can modify the plural name of your table.

    Note

    The table will be created as part of the default solution.

  4. Select Create.

The table will be created in Dataverse. You can now begin to configure your table.

Configure a table

  1. From the Tables in this site or Other tables section, select the table you want to edit.

  2. In the table designer, modify any existing data rows. In addition, the following options are available.

Action Description
New row Create a blank row and enter in a new data row.
New column Create a new data column for the table. You'll need to specify the name, data type, and format along with other column configuration options. For a complete list of Dataverse column types, go to Types of columns.
Show/hide columns Select which columns you want to be visible or invisible in the table designer.
Refresh Reload the table data.
Edit table properties Change the name and other advanced properties of the table.

Next steps

Create and modify Dataverse views by using the Data workspace
Create and modify forms by using the Data workspace
Create and modify virtual tables by using the Data workspace

See also