Overview of the Data Workspace in Microsoft Power Pages

The Data Workspace in Microsoft Power Pages provides a centralized environment for managing the business data used throughout your website. Built on Microsoft Dataverse, it allows makers to create and manage tables, forms, views, and solutions that power data-driven website experiences.

What is the Data Workspace?

The Data Workspace serves as the primary location for managing website data. It enables users to view, create, and modify Dataverse tables, forms, and views directly from Power Pages Design Studio.

Manage Dataverse tables.
Create and edit forms.
Configure views for data presentation.
Organize customizations using solutions.
Build data-driven applications without code.

Solutions in the Data Workspace

Solutions help organize and manage customizations within Microsoft Dataverse. Every table, form, view, and column created in Power Pages can be stored within a solution for easier deployment and lifecycle management.

Key Benefits of Solutions

Organize customizations efficiently.
Support application lifecycle management.
Enable easier deployment between environments.
Apply consistent publisher prefixes.
Improve maintainability.

By default, changes are stored in the Common Data Services Default Solution. However, makers can select a different unmanaged solution from the solution dropdown menu.

Working with Tables

Tables are the foundation of data storage in Microsoft Dataverse. The Data Workspace provides visibility into all tables being used throughout the website.

Tables in This Site

Displays tables actively used by your Power Pages website.

Other Tables

Shows additional Dataverse tables available within the environment and tables referenced by forms or other components.

Table Management Features

Create new tables.
Edit existing tables.
Add columns.
Manage relationships.
Configure business rules.
Design data structures.

Working with Views

Views determine how records are displayed within Power Pages lists and data-driven components. A view defines both the columns displayed and the records returned.

Benefits of Views

Control displayed columns.
Filter records.
Sort data.
Support list components.
Create user-friendly data presentations.

View Designer

Power Pages uses the Power Apps View Designer to create and edit Dataverse views. These views become the foundation for list components displayed on website pages.

Working with Forms

Forms allow users to create, view, and edit Dataverse records through Power Pages websites.

Supported Forms

The Forms tab displays portal-supported Dataverse main forms that can be used throughout the website.

Form Design Capabilities

Add fields.
Configure layouts.
Enable validation.
Add components.
Customize user experiences.
Support business processes.

Advanced form customization can be performed using the Power Apps Form Designer through the command bar.

Benefits of the Data Workspace

Feature	Benefit
Solutions	Organize and deploy customizations.
Tables	Store and manage business data.
Views	Control data presentation.
Forms	Enable data entry and updates.
Dataverse Integration	Secure and scalable data management.

Best Practices

Use dedicated unmanaged solutions for customizations.
Follow consistent naming conventions.
Design tables carefully before deployment.
Create optimized views for performance.
Keep forms simple and user-friendly.
Document all customizations.

Summary

The Data Workspace in Microsoft Power Pages provides a powerful environment for managing Dataverse data, forms, views, and solutions. By leveraging these capabilities, organizations can build scalable, secure, and data-driven websites that deliver rich user experiences while maintaining efficient data management practices.