Share via

Visualize and work with complex data using copilot

  • Article

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview Early access General availability
Admins, makers, marketers, or analysts, automatically May 2024 - -

Business value

Makers will be able to create tables from scratch using various data sources including Excel files, SharePoint lists, or conversation 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 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 for 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 model consisting of several tables and relationships along with sample data in just a few clicks.