Share via

Visualize and work with complex data using copilot

  • Article

Important

This content is archived and is not being updated. For the latest documentation, go to Microsoft Power Apps documentation. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.

Enabled for Public preview Early access General availability
Admins, makers, marketers, or analysts, automatically Jun 23, 2024 - Sep 24, 2024

Business value

Makers will be able to create tables from scratch using various data sources including Excel files, SharePoint lists, or conversations with the assistance of copilot in the new data model visual editor. Multiple tables can be created at the same time with relationships set up leveraging the smart inference capability of copilot. Created tables and relationships will be visualized in ERD (entity relationship diagram) view to help makers better understand the data model. Makers can also invoke copilot inline to create new tables, update schema, or seek suggestions to improve their data model.

Feature details

Today, Power Apps has established a WYSIWYG pattern well perceived by its makers for app building. However, when it comes to setting up the data model behind the app for suitable business logic, makers, experienced or not, still have to deal with the plain schema view of their tables and relationships as the only possible option. Now, following the same philosophy we bear for app building experiences, we are introducing a new data modeling experience through a WYSIWYG editor, where makers can create multiple tables with relationships from scratch, external data sources, or conversation with the assistance of copilot. Through the new data model editor, tables and relationships will be visualized in an ERD (entity relationship diagram) view, making it easier than ever to understand how tables and various other data objects work hand in hand. Moreover, with the assistance of copilot, maker productivity will be further boosted as copilot makes it possible to create complex data models consisting of several tables and relationships along with sample data in just a few clicks.

Geographic areas

This feature will be released into the following Microsoft Azure geographic areas:

  • Germany
  • Norway
  • Singapore
  • South Africa
  • Switzerland
  • United Arab Emirates
  • Sweden
  • Qatar
  • United States
  • Europe
  • Asia Pacific
  • United Kingdom
  • Australia
  • Brazil
  • Canada
  • India
  • Japan
  • France
  • Korea
  • China

See also

Create a table (docs)