Create and manage tables in Dataverse

 Table in Dataverse:-

In Dataverse, a table is a logical structure containing records that are made up of rows and columns. Dataverse tables differ from a simple database table because they have nearly 100 properties that are used to define relationships between other standard tables and how the table is used within Dynamics solutions from Microsoft.

Types of tables in Dataverse:-

The four types of tables are:-

Standard - The base set of tables that are created for every instance of a Dataverse database. You can add more columns to any table, but you cannot delete any column from a standard

Complex - tables that contain complex, server-side business logic, including real-time workflows or plug-ins. To use complex tables, users are required to have a P2 or Dynamics 365 license

Restricted - Certain tables that are tied to Dynamics 365 application functionalities require each user to have the corresponding license for that Dynamics 365 application if they want to create, update, or delete rows within the restricted tables.

Custom - Are created for a specific business application.

Licensing requirements for each table type:-

1. Standard and custom table        -        microsoft365, Per app plan, Dynamic365
2. complex table                            -        Per User plan, Dynamic 365
3. restricted Table                          -         Specific Dynamic365 application licenses

 Create a custom table:-

1. Sign in to Power Apps.

2. On the navigation pane, select or tap Data to expand it and then select or tap Tables.

3. Select New table in the command bar.

4. In the New table panel, in the Display name box, enter the name of your new custom table.

5. To add a column to the table, use the following procedure:

1. In the command bar, select or tap Add column to open the column properties panel.

2. In the Display name box, enter the name of the column that you want to add.

3. From the Data type drop-down list, select the type of data that you want to add.

4. Select and change the Required dropdown if desired.

5. Select or tap Done.

Enable attachments within a table:-

1. Sign in to Power Apps

2. Select Data and then Tables on the menus on the left-hand pane.

3. Select a table and then select Settings.

4. Select the Enable Attachments check box.

5. Select Done.

6. Select Save Table at the bottom to save your changes.

•