Let’s get started
Please enter your work or school account to get started.
You can automatically generate an app to manage data that is stored in Common Data Service. You can manage data in one of the many standard entities that are built into the model, or in a custom entity that you or someone else in your organization creates.
If you're unfamiliar with Common Data Service, see Understand entities.
This topic describes how to automatically generate an app that is based on a single entity that you specify. For information about how to build an app that is based on more than one entity, see Build an app from scratch.
By default, every app that Microsoft PowerApps generates has three screens:
Note: When you generate an app from Common Data Service, you don't have to create a connection from PowerApps, as you do for data sources such as SharePoint, Dynamics 365, and Salesforce. You must specify only the entity that you want to show, manage, or show and manage in the app.
Click or tap Connect to automatically generate an app.
At this point, you may be prompted to take an introductory tour. You can also take the tour later by clicking or tapping the question mark near the upper-right corner, and then clicking or tapping Take the intro tour.
In the right pane, click or tap the layout that shows just a heading.
Under the search box, click or tap the Text box control to select it.
In the right pane, select Surname of Given name in the dropdown list
The Text box control that you selected shows data from that field.
In the browse screen, select the gallery by clicking or tapping any name except the top name.
A selection box surrounds the gallery.
Copy the following formula by selecting it and then pressing Ctrl+C.
SortByColumns(Search(Contact, TextSearchBox1.Text, "Name_Surname"), "Name_Surname", If(SortDescending1, Descending, Ascending))
Near the upper-left corner, make sure that the property list shows Items.
In the formula bar, select the default formula.
Press Delete to delete the default formula, and then paste the formula that you copied. The names in the gallery are sorted alphabetically.
Optional: If the users of this app won't have touchscreens or mouse wheels, click or tap the Gallery tab, and then click or tap Show Scrollbar.
Note: If the Gallery tab doesn't appear, make sure that the gallery is still selected.
Near the upper-right corner, click or tap the sort button one or more times to change order that the names are listed in.
In the search box, type a letter to show only names that contain that letter.
Remove all text from the search box, and then click or tap the arrow to the right of the first name in the list.
The details screen opens and shows more information about the contact you selected.
Return to the design workspace by pressing Esc, or by clicking or tapping the Close button near the upper-right corner, under the title bar.
In the right pane, drag Name_Surname up, and drop it just under Name_GivenName.
The DetailScreen reflects your changes.
In the left navigation bar, click or tap the bottom thumbnail to show EditScreen, and then repeat the previous steps in this procedure so that EditScreen matches DetailScreen.