The New Data Experience (ERD) in Power Apps-Simplifying Data Management - Complex Data Models

-

Power Apps has introduced an exciting new data experience that streamlines how makers work with data sources and tables. This update brings significant improvements to data management, making it easier than ever to build powerful apps.

To build meaningful business applications, data models consisting of multiple tables are almost always essential. The public preview of a brand-new data experience that simplifies working with complex data models in an Entity Relationship Diagram (ERD) view with the assistance of Copilot. This innovative feature allows you to seamlessly work with data from a variety of sources, including natural language inputs, Excel files, and SharePoint lists, all through a simple drag-and-drop interface akin to how you currently interact with app visuals.

Accessing the ERD data experience

Navigate to make.powerapps.com>Select the required environment>Enable the new data experience feature


Once enabled, the new data experience can be accessed through various entry points. This includes the home page, tables page, app designers, and more. Essentially, it’s available anywhere you can create new tables today, offering a seamless integration into your workflow.

Also enable the copilot preview feature is on from power platfrom admin center.


The new data experience now enables you to interact with multiple tables in an ERD view through intuitive drag-and-drop actions. This visual ERD framework allows for a clear understanding of how your tables interconnect to form a robust data model. Moreover, it simplifies table and relationship management, empowers you to establish relationships between tables with just a few clicks.

Now lets go and create a data model with copilot 

To do this select Create New Table>from the options select start with copilot. 


We can describe the few lines to generate the tables. you might have to try few times to to get the desired output sometimes :-)

In this example I have asked the copilot to generate the tables for hotel room booing system. 


Based on my description, copilot has created the tables as below. 


We can ask more interactive questions in the copilot window to generate more tables, edit tables or create relationship between the tables, etc. 

I have asked the copilot here to create a customer tables and create relationship between bookings and customer. 


Benefits for Complex Data Models

This new experience is particularly beneficial for projects with intricate data structures. The visual representation of relationships is especially useful for complex data models within Dataverse environments

it's important to note that some functionalities may still be in development or have limitations. As with any new feature, users should explore and provide feedback to help shape its evolution.

Thank you for visiting this blog 🙏

Comments

Post a Comment

Popular posts from this blog

How to update 100000(hundred thousand) records with power automate flow by using chunk expression, Split the list and pass onto child flows.

-
Image
The Dataverse connecter returns up to 5000 rows by default, We can increase this up to 100000. To get more than 5,000 rows, turn on the Pagination and set the threshold up to 100,000 in Settings If you have more than 100,000 rows to process? you can get more than 100,000 rows from Dataverse, use the skip token to send another request until the skip token returns empty When we have thousand of records to update instead of doing list down the records and apply on each, I have approached this slightly different here.  We will build one parent flow and 4 child flows. So that we can divide the whole list into 4 identical list and pass on to child flows. This approach significantly reduces the time to update the total records.  Lets jump in and build a flows! Based on your requirement you can choose the type of flow you want, for example purpose I am using Schedule flow.  Since I am using the current date to filter down the records, I am initialize and format the date. use the ...
Read more

How to keep flows remain on if the flows don't run for 90 days

-
Image
This is a common requirement in power plat form world, flows turn off after 90 days if they don't run. We can address this issue by writing a scheduled flow and run every day.  I will explain how to write this flow.  Start with by selecting a schedule flow. Select Power automate management connecter- List flows as admin(V2) Once you select it will ask you to create a connection then Select your target Environment Next we need to filter the flows which we want to turn it on, Here I am using a unique display name which you have common for all the flows you want to check. In my case I am using "-Production-" to filter down the flows.  Select the value from the list flows Select edit in advance mode and enter the below expression @and(equals(item()?['properties/state'], 'Stopped'),contains(item()?['properties/displayname'],'-Production-')) In the next action, select apply on each , Select the output value from the filter array, Select the same ...
Read more

D365 CRM-Change Entity translations(Sub area) in Modern driven app.

-
Image
  Have you ever tried activating language packs in D365 CRM and tried to change the Entity names in Modern driven app? Normally When we activate the language pack for your preferred language Microsoft default translates all out of box entity names. If you want to change the translations for existing ones or create new for custom entities we need to update the translations.  You can enable the language pack under Administration>Languages Open the Modern driven app editor in classic version, select the Entity name you want to change the translations Select the language you want to update the translation and delete the existing translation and enter the new one.  Now the new translation name is updated.  Note: We cant update custom translations for recent and pinned fields in the left navigation at the moment. This is limitation from the Microsoft side at the moment.  Thank you for visiting this blog 🙏
Read more