LOAD/EXPORT DATA AND CREATE DATA,DATA VIEWS IN DATAVERSE

How to view data in an entity

 To view data in an entity, follow these steps:

1.      Sign in to the Power Apps portal.

2.      On the left pane, expand Data and select Tables.

3.      Select the table that is associated with the data that you want to view.

4.      Select Data on the menu at the top of the screen.

5.      After activating the data screen, notice the option in the top menu called Open in Excel. If you select this option, you can work with all the data that is stored in this table by using Microsoft Excel. 

How to Load Data into a table 

To load data into a table, use the following steps:

1.      Prepare the file template.

a. Export the table data to the CSV file.

b. Define a plan to make sure that the data is unique. Use either primary keys or alternate keys.

c. Ensure that data is unique before you import it into a table.

2.      Copy data from your Microsoft Excel or CSV file into the template that you just created.

Import the data into a table.

a. Sign in to Power Apps.

b. On the left pane, expand Data and then select Tables.

c. Select the table that you want to import data into.

d. Select the ellipsis (...) or menu at the top. Select Get data and then select Get data from Excel.

e. On the Import data screen, choose whether to import data from an Excel or a CSV file.

f. Select Upload.

g. Choose your file. Follow the prompts to upload your file.

h. After the file is uploaded and mapping status is green, select Import in the top-right corner.

i. You can use Excel to add, update, or delete data and fix any mapping errors.

After the import finishes successfully, you will see the total number of inserts and updates that occurred.

 

How to Export data from an entity

You can quickly export data from an entity by using the built-in capabilities of Microsoft Dataverse.

1.      Sign in to Power Apps.

2.      On the left pane, expand Data and select Tables.

3.      Select the table that is associated with the data that you want to export.

4.      Select the Export data button on the top menu.

Dataverse will export all data from the table into a zip file. The zip file is then available to download and will contain the data in a .csv file.

Add, update, or delete data in an entity by using Excel:-

Microsoft Dataverse can help you add, update, or delete data in an table by using a Microsoft Excel add-in feature.

1.      Sign in to the Power Apps portal.

2.      On the left pane, expand Data and then select Tables.

3.      Select the table that is associated with the data that you want to export.

4.      Select the Open in Excel button on the top menu.

5.      Sign in to Dataverse by using the Excel add-in located on the right-hand pane.