Create a canvas app from Microsoft Dataverse in Power Apps

Note

Effective November 2020:

  • Common Data Service has been renamed to Microsoft Dataverse. Learn more
  • Some terminology in Microsoft Dataverse has been updated. For example, entity is now table and field is now column. Learn more

This article will be updated soon to reflect the latest terminology.

In Power Apps, create a canvas app based on a list of sample accounts in Dataverse. In this app, you can browse all accounts, show details of a single account, and create, update, or delete an account.

If you're not signed up for Power Apps, sign up for free before you start.

Prerequisites

To follow this quickstart, you must be assigned to the Environment Maker security role, and you must switch to an environment in which a database in Dataverse has been created, contains data, and allows updates. If no such environment exists and you have administrative privileges, you can create an environment that meets this requirement.

Create an app

  1. Sign in to Power Apps and, if necessary, switch environments as specified earlier in this topic.

  2. Under Make your own app, hover over Start from data, and then select Make this app.

    Option to create an app

  3. On the Common Data Service tile, select Phone layout.

    Connection tile

  4. Under Choose a table, select Accounts, and then select Connect.

  5. If the Welcome to Power Apps Studio dialog box appears, select Skip.

Your app opens to the browse screen, which shows a list of accounts in a control called a gallery. Near the top of the screen, a title bar shows icons for refreshing the data in the gallery, sorting the data in the gallery alphabetically, and adding data to the gallery. Under the title bar, a search box provides the option to filter the data in the gallery based on text that you type or paste.

By default, the gallery shows an email address, a city, and an account name. As you'll see in Next steps, you can customize the gallery to change how the data appears and even show other types of data.

Browse screen

Save the app

You'll probably want to make more changes before you use this app or share it with others. As a best practice, save your work so far before you proceed.

  1. Near the upper-left corner, select the File tab.

  2. In the App settings page, set the app name to AppGen, change the background color to deep red, and change the icon to a checkmark.

    App settings page

  3. Near the left edge, select Save and then, in the lower-left corner, select Save.

Next steps

In this quickstart, you created an app to manage sample data about accounts in Dataverse. As a next step, customize the gallery and other elements of the default browse screen to better suit your needs.

Note

Can you tell us about your documentation language preferences? Take a short survey.

The survey will take about seven minutes. No personal data is collected (privacy statement).