{"id":31730,"date":"2022-06-02T13:09:23","date_gmt":"2022-06-02T07:39:23","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=31730"},"modified":"2022-10-14T12:05:27","modified_gmt":"2022-10-14T06:35:27","slug":"the-new-look-of-dataverse-tables","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2022\/06\/the-new-look-of-dataverse-tables\/","title":{"rendered":"The new look of Dataverse Tables!"},"content":{"rendered":"

Introduction:<\/strong><\/h2>\n

In the recent Microsoft update, Dataverse Tables UI<\/strong> has been enhanced to help users edit\/manage data easily in Power Apps and focus more on their work.<\/p>\n

Now, let\u2019s explore the new UI of Dataverse Tables!<\/p>\n

Searching for Tables is now easier:<\/strong><\/p>\n

Now you can easily find the required tables based on the classification added as Recommended, Custom, <\/strong>and All<\/strong> as shown below:<\/p>\n

\"Dataverse<\/p>\n

Enhanced Table UI:<\/strong><\/p>\n

Microsoft has made changes in the Table UI and now when you open any table, it will look as shown below:<\/p>\n

\"Dataverse<\/p>\n

Table Properties<\/em><\/strong>: Here you can easily view basic Table Properties <\/strong>and to edit the table properties you can click on the Properties<\/strong> button.<\/em><\/p>\n

Schema<\/em><\/strong>: Here you can work with Columns, Relationships, and Keys that make up a schema or structure of the tables.<\/em><\/p>\n

Data experiences<\/em><\/strong>: Here you can work with Forms, Views, Charts, and Dashboards of the tables.<\/em><\/p>\n

Customizations<\/em><\/strong>: Here you will have Business Rules and Commands that have been added to customize the table further.<\/em><\/p>\n

Tools:<\/strong><\/p>\n

Using this new feature now with one click, you can easily copy the set name, schema name, <\/strong>and logical name<\/strong> of any tables and paste\/use it wherever needed.<\/p>\n

Also now it is easy to get the API link to table definition <\/strong>and table data<\/strong> with one click using this new feature.<\/p>\n

\"Dataverse<\/p>\n

Working on Table:<\/strong><\/p>\n

Using the \u201c+ New<\/strong>\u201d button, you can work on the respective tables by creating forms, views, relationships, and much more as shown below:<\/p>\n

\"Dataverse<\/p>\n

Create an App Button<\/strong><\/p>\n

Using this button now you can easily create a new app and on clicking of \u201cCreate an App<\/strong>\u201d button, you will get the below pop-up where you have to provide the app name and click on the \u201cCreate\u201d<\/strong> button:<\/p>\n

\"Dataverse<\/p>\n

Once you click on the \u201cCreate<\/strong>\u201d button, you will get the below pop-up that shows that the app is getting created from the selected table:<\/p>\n

\"Dataverse And once the app is ready, you will see that the respective table is automatically added to the newly created app and further you can customize the app as required.<\/p>\n

\"Dataverse<\/p>\n

\u2018Using this table\u2019 Button:<\/strong><\/p>\n

On click of this button, below pop-up window gets displayed which shows all the apps and flows related to respective tables i.e. display only Apps<\/strong> and Flows<\/strong> where the respective table has been used.<\/p>\n

Here you can view all the dependent apps and flow of respective tables and work or customize the same easily as per your requirement.<\/p>\n

\"Dataverse<\/p>\n

Account Columns and Data<\/strong>:<\/p>\n

It shows the rows and columns of the data where you can edit the columns and data by clicking on the Edit<\/strong> button shown in the top ribbon bar or the Edit<\/strong> button added in the \u201cAccount Columns and Data<\/strong>\u201d area section.<\/p>\n

\"Dataverse<\/p>\n

By clicking on Edit<\/strong>, it will open the below page that will display all the Account<\/strong> records in the system as shown below:<\/p>\n

\"Dataverse<\/p>\n

1. Edit Table<\/strong>: Using the \u201cEdit Icon<\/strong>\u201d or \u201cEdit table properties<\/strong>\u201d button, you can edit the table properties.<\/p>\n

\"Dataverse<\/p>\n

2. Create, Add and Remove Columns: <\/strong>Here you can create, add or remove columns that are displayed while working on the data in the Power Apps.<\/p>\n

\"Dataverse<\/p>\n

Also, you can perform the below actions on columns added by clicking the dropdown icon displayed beside the columns name as shown below:<\/p>\n

\"Dataverse<\/strong><\/p>\n

3. + New Row: <\/strong>Using this button, you can create a new record of the table from Power Apps as well, and once you click, a new row is displayed as you can see below:<\/p>\n

\"Dataverse<\/strong><\/p>\n

Fill the row details as you want and you can see the data being auto-saved (once you click anywhere outside the table data) at the top right corner of the window:<\/p>\n

\"Dataverse<\/p>\n

Once data gets auto-saved, you will see the \u201cData Saved<\/strong>\u201d at the top right corner:<\/p>\n

\"Dataverse<\/p>\n

4. + New Column<\/strong>: Using this button, you can create a new column on the table<\/p>\n

\"Dataverse<\/strong><\/p>\n

5. Insert row above and Insert row below:<\/strong><\/p>\n

\"Dataverse<\/strong><\/p>\n

This button gets visible only when you select any row of the table using which you can insert new row above or below the selected row as shown below:<\/p>\n

And if you insert the blank row and Refresh<\/strong> the data then you will get the below error as the blank row will not get saved.
\n\"Dataverse<\/p>\n

6. Delete record(s): <\/strong>Using this button, you can delete N number of rows of the tables as shown below:<\/p>\n

\"Dataverse<\/p>\n

Conclusion: <\/strong><\/h2>\n

As illustrated above, this new UI will surely make the user experience better while working on the Dataverse Tables.<\/p>\n

Save 1-2 hours or $800 monthly on scheduling and managing business travel with a geo-mapping App!<\/div><\/div><\/h2>\n

Maplytics<\/a> <\/strong>\u2013 Integrate Map with Dynamics 365 CRM and visualize data on the map, manage sales territories, auto-schedule appointments, get optimized travel routes, track field reps in real-time, and more<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction: In the recent Microsoft update, Dataverse Tables UI has been enhanced to help users edit\/manage data easily in Power Apps and focus more on their work. Now, let\u2019s explore the new UI of Dataverse Tables! Searching for Tables is now easier: Now you can easily find the required tables based on the classification added\u2026 Read More: The new look of Dataverse Tables! »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2354,16,2361],"tags":[2171],"class_list":["post-31730","post","type-post","status-publish","format-standard","hentry","category-dataverse","category-dynamics-365","category-technical","tag-dataverse"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t