Creating new tables in the Power Platform Data-verse is straightforward. To do this:

  • Navigate to Power Apps in the Microsoft 365 admin center, then select ‘Data’ > ‘Tables’.
  • Click on ‘New Table’ on the top-right corner.

After clicking, you will then provide three essential properties for the table:

  • Display Name: It is used to identify the table in the Power Apps in an easily readable format.
  • Name: It is the unique identifier of the table in the backend system and remains unchanged even if the Display Name is modified.
  • Primary Name column: It refers to the main data column in the table.

Table of Contents

2. Modifying Existing Tables in Power Platform

To modify an existing table, you need to:

  • Navigate to Power Apps in the Microsoft 365 admin center, then select ‘Data’ > ‘Tables’.
  • Select the table you want to modify and click ‘Edit Table’.

In the ‘Edit Table’ option, you can modify several aspects:

  • Table columns: You can add new columns by clicking “+ Add column,” supply the Display Name, Name, and Data Type. To modify an existing column, click on it and change whatever necessary.
  • Relationships: These allow tables to have connections with one other. You can create a new relationship by clicking “+ Add Relationship” and supply the Name, Display Name, and type of relationship.
  • Business Rules: These are the set of conditions that apply to the table. You can modify, add, or delete business rules by navigating to the ‘Business Rule’ area.
  • Keys: Keys are columns that act as unique identifiers of a record. You can add a new key by clicking “+ Add Key”.

3. Examples

Consider a scenario where you want to create a new table called “test_table” using the Power Platform. Here is how the setup would look like:

Display Name: Test Table
Name: test_table
Primary Name column: test_id

To add a new column to this table, navigate to the ‘Columns’ section of the table and add a new column called ‘test_column’ with a Data Type ‘Text Aera’.

4. Conclusion

In conclusion, creating and modifying tables in Microsoft Power Platform is a breeze once you understand the principles and the logic behind them. By mastering these skills, you’ll be in a stronger position to pass the PL-200 Microsoft Power Platform Functional Consultant exam and enhance the organization data management capability. Remember to practice these skills regularly, as continued use solidifies the knowledge.

References:

Practice Test

True or False? In Microsoft Power Platform, Entity records are used to model and manage business data in Dataverse.

  • True
  • False

Answer: True

Explanation: Entity records represent a set of records or information. They are used for modeling and managing business data in Microsoft’s Dataverse.

What can you use to create a new table in the Power Apps’ Dataverse?

  • A. Power BI
  • B. Power Query
  • C. Power Automate
  • D. None of above

Answer: D. None of above

Explanation: You cannot use Power BI, Power Query or Power Automate to create a new table in Power Apps’ Dataverse. Instead, it can be done within Power Apps’ Dataverse using the Create a new table option.

True or False? We cannot create relationships between tables in Microsoft Power Platform.

  • True
  • False

Answer: False

Explanation: Microsoft Power Platform allows users to create relationships between tables to manage, access and view data more effectively.

True or False? It is impossible to delete primary fields in Microsoft Power Platform.

  • True
  • False

Answer: True

Explanation: In Microsoft Power Platform, you cannot delete a primary field as it is required for every table to function properly.

Which of the following operations can you perform to modify an existing table in Microsoft Power Platform?

  • A. Add or delete a column
  • B. Change the data type of a column
  • C. Rename a column
  • D. All of the above

Answer: D. All of the above

Explanation: Modifying an existing table in Microsoft Power Platform includes adding or deleting a column, changing the data type of a column, and renaming a column.

True or False? Table permissions can be managed in Microsoft Power platform.

  • True
  • False

Answer: True

Explanation: In Microsoft Power Platform, you can manage data access permissions for an entity or table, restricting access to specific users or teams.

In Power Platform, where can you go to create a new table?

  • A. Power Automate
  • B. Power Virtual Agents
  • C. Power Apps’ Dataverse
  • D. None of above

Answer: C. Power Apps’ Dataverse

Explanation: In Power Platform, new tables can be created in the Power Apps’ Dataverse.

True or False? All columns in a table are required fields and cannot be left blank.

  • True
  • False

Answer: False

Explanation: In Power Platform, not all columns in a table are required fields. Only the primary field in a table is the required field and cannot be left blank.

Which of the following can be used to modify an existing table in Power Apps’ Dataverse?

  • A. Power BI
  • B. Power Query
  • C. Power Automate
  • D. None of the above

Answer: D. None of the above

Explanation: None of Power BI, Power Query or Power Automate can be used to modify an existing table in Power Apps’ Dataverse. Instead, it can be done directly within the Dataverse.

True or False? Power Platform supports many-to-many relationships between tables.

  • True
  • False

Answer: True

Explanation: Power Platform does support many-to-many relationships between tables, allowing a record from one table to have multiple linked records in another table and vice versa.

True or False? Once a table is created in Dataverse, it cannot be renamed.

  • True
  • False

Answer: False

Explanation: You do have the option to rename a table in Dataverse – this is part of one’s ability to modify existing tables.

What is the minimum permission required to modify an existing table in Power Apps’ Dataverse?

  • A. Create permissions
  • B. Write permissions
  • C. Delete permissions
  • D. Read permissions

Answer: B. Write permissions

Explanation: Write permission is required to modify or update an existing table in Power Apps’ Dataverse.

Interview Questions

How do you add a new field to an existing table?

You can add a new field to an existing table in Microsoft Power Platform by following these steps: Go to Data -> Tables -> select the table -> Fields -> Add field -> Enter the properties for the field -> Save and close.

Is it possible to delete a table once it is created in Microsoft Power Platform?

Yes, you can delete a table. However, this will remove all the data within and any references to this table from other areas within the platform.

What is the purpose of the Managed Properties feature when modifying tables in Power Apps?

Managed Properties let you specify how a component (like a table) can be modified after you distribute it as part of a managed solution. You can restrict actions like delete, rename or customize.

Where can we view and manage all tables available in our app?

We can view and manage all tables under the ‘Data’ section in the Power Apps portal. Here, you can create, edit or delete tables as required.

How do you create a new table in the Microsoft Power Platform?

You can create a new table by going to the Power Apps portal, select ‘Data’ from the left-hand menu, choose ‘Tables’, and then click ‘+ New table’.

Are system-generated fields included when creating a new table in Power Platform?

Yes, system-generated fields such as “Created By”, “Created On”, “Modified By”, and “Modified On” are automatically included when creating a new table in Power Platform.

How can you associate or link two tables in Microsoft Power Platform?

To associate two tables, create a new relationship between them by going to the table design, select ‘Relationships’ and then ‘+ New relationship’.

What is the role of ‘Primary Name’ in table design in Power Platform?

In Power Platform, ‘Primary Name’ is an important property when designing a table. It defines the main field used to identify records when they’re displayed in a look-up, drop down or in certain views.

Is it possible to change the data type of an existing field in a table?

No, once a field has been created with a specific data type, it cannot be changed in Power Platform.

What will happen if a table that is in use by some apps is deleted?

Deleting a table that is in use by an app will cause the app to malfunction or stop working correctly, as it can no longer access the needed data. Extreme care should be taken while deleting tables.

How can you make a field mandatory in a table in Power Platform?

You can make a field mandatory by setting the ‘Required’ property of the field to ‘Yes’ in the table customization settings.

Can we hide a table in Microsoft Power Platform?

Yes, you can hide a table by setting the ‘Visible’ property to ‘No’ within the table customization settings.

How can you import data to a new table in Power Platform?

You can import data into a new table from various sources, such as Excel and SharePoint, by going to the ‘Data’ section, selecting ‘Get Data’ and following the import wizard.

Can we create a table without adding any custom fields to it?

Yes, you can create a table without adding any custom fields. The system automatically includes a few fields like “Created By”, “Modified By”, etc.

Is it possible to change the name of a table after it’s been created?

Yes, but changes made to the name after the table is created only affect the display name and plural name. The actual name (schema name) of the table cannot be changed.

Leave a Reply

Your email address will not be published. Required fields are marked *