Check your knowledge

1.

You want to create an Excel spreadsheet that contains the list of contacts that you manage in Dataverse. You select the Edit data in Excel option from the Contact table in the Power Apps portal to generate the file. The option to publish the changes back to Dataverse isn't available in Excel when you edit the file. What could cause this situation?

The valid option for this scenario is to select Dynamic Worksheet from a view of the Contact table.

The Microsoft PowerApps Office Add-in isn't activated in Excel for this user.

Edit data in Excel is available from model-driven apps only, not from the Power Apps portal.

2.

You receive a request to generate an Excel spreadsheet with the list of accounts that your organization partners with. This file must be shared with a service provider outside your organization that doesn’t have an account in your Dataverse environment. Two weeks after supplying the file, you receive a request asking that they have permission to update the list of accounts based on recent changes in Dataverse. How should you proceed?

Provide instructions to the service provider on how to use the Refresh All option in Excel.

Provide a new file that’s been generated by using the Dynamic Worksheet export option in your model-driven app.

Provide a new file that’s been generated by using the Static Worksheet export option in your model-driven app.

3.

You create a Dynamic PivotTable file based on the sales forecast for your organization. After working different what-if scenarios and updating some of the values in the file, you try to import the file back in Dataverse by using the Import from Excel option of the related model-driven app. The import process fails and generates an error, which doesn’t allow you to import the modifications back in the sales forecast table. What could cause this situation?

Exported files that are based on the Dynamic PivotTable option aren't in a valid format for the Import from Excel option.

The updated file must be imported by using the Import PivotTable option that’s available in the model-driven apps.

The sales forecast values have been modified in Dataverse after the file was exported to Excel.

Answer the following questions to see what you've learned.

Feedback