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

6/14/2022


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.

Create a new table

1. Next to Tables in this site, select the plus sign (+).

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

 
     

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

 
             

 

Source: docs.microsoft.com