Practice Lab 2.3 - Export data

Scenario

You are a functional consultant working on the Fabrikam project. You need to export some data from your Dataverse environment.

Exercise 1 – Export data

In this exercise, you will export data using the maker portal.

Task 1.1 – Maker Portal Export

  1. Navigate to the Power Apps Maker portal https://make.powerapps.com.

  2. Make sure you are in your Practice environment.

  3. Expand Dataverse and select Tables.

  4. Locate and click to open the Project table.

  5. Click Export and select Export data.

  6. Wait for the data to be exported.

  7. Click Download exported data.

  8. Close the Export data pane.

  9. Open the folder the data was downloaded to.

  10. Right click on the exported zip file and extract the file.

  11. Open the exported CSV file.

  12. You should see all the exported Project rows.

  13. Close the CSV file.

  14. You may delete the exported files.

Exercise 2 – Export data from a model-driven app

In this exercise, you will export data from a model-drivel app using the maker portal.

Task 2.1 – Export to Excel

  1. Navigate to the Power Apps Maker portal https://make.powerapps.com.

  2. Make sure you are in the Practice environment.

  3. Select Apps.

  4. For the Environmental Management app, Click on the ellipses (…) and select Play. Sign in with your Microsoft 365 credentials if prompted.

  5. In the left-hand navigation of the app, select Projects.

  6. In the action bar, select the caret next to Export to Excel and then select Static Worksheet.

  7. Open the folder the data was downloaded to.

  8. Open the export Excel file.

  9. You should see all the exported Project rows.

  10. Close the Excel file.

  11. You may delete the exported file.