How to Create and Modify Dataverse Tables Using the Data Workspace in Power Pages

🚀 How to Create and Modify Dataverse Tables by Using the Data Workspace

📌 Introduction

Microsoft Power Pages provides a powerful Data Workspace that allows makers and developers to create, manage, and modify Microsoft Dataverse tables directly from the Power Pages Design Studio.

Instead of switching between Power Pages and Power Apps, you can manage your business data structures from a single workspace, significantly improving productivity and reducing development time.

In this article, you'll learn how to create new Dataverse tables, configure existing tables, add columns, and manage records using the Data Workspace.

🎯 What You Will Learn

Create Dataverse tables directly from Power Pages
Configure table properties
Add and manage columns
Create and edit records
Understand Data Workspace best practices

🌐 Access the Data Workspace

Follow these steps to access the Data Workspace in Power Pages.

Power Pages › Select Site › Edit › Data

Available Sections

Tables in This Site – Displays tables currently used within the website.
Other Tables – Displays all Dataverse tables available in the environment.

💡 The Data Workspace acts as a centralized location for managing Dataverse tables without leaving Power Pages Design Studio.

➕ Create a New Dataverse Table

Creating a Dataverse table from the Data Workspace is quick and straightforward.

1 Select + Table
2 Click New Table
3 Enter the table name
4 Configure advanced settings if required
5 Click Create

🔑 Choose meaningful table names and follow your organization's naming standards to maintain consistency across environments.

⚙️ Configure an Existing Table

Select any table from either Tables in This Site or Other Tables to open the Table Designer and manage its configuration.

Available Actions

Action	Description
New Row	Add a new record to the table.
New Column	Create a new field with specific data types.
Show/Hide Columns	Manage column visibility.
Refresh	Reload latest table data.
Edit Table Properties	Update table settings and configuration.

🧱 Common Dataverse Column Types

Data Type	Purpose
Single Line of Text	Names and Titles
Multiple Lines of Text	Descriptions and Comments
Number	Numeric Data
Currency	Financial Information
Date and Time	Date Values
Choice	Dropdown Options
Lookup	Relationship Between Tables
File	Document Storage
Image	Image Storage

⭐ Best Practices

✔ Use meaningful table names.
✔ Configure required fields properly.
✔ Avoid duplicate columns.
✔ Create relationships where appropriate.
✔ Follow organization naming conventions.

🚀 Conclusion

The Data Workspace in Power Pages simplifies Dataverse table creation and management by providing a centralized and intuitive experience directly within the Design Studio.

Whether you're creating new tables, adding columns, managing records, or configuring table properties, the Data Workspace helps accelerate development while ensuring seamless integration with Microsoft Dataverse and the broader Power Platform ecosystem.