Create a canvas app from scratch using Common Data Service for Apps
Build a canvas app to manage data that's stored in Common Data Service for Apps, using standard entities (which are built in), custom entities (which your organization creates), or both.
When you build an app from the Common Data Service, you don't need to create a connection from PowerApps, as you do with data sources such as SharePoint, Dynamics 365, or Salesforce. You only need to specify the entities that you want to show, manage, or use for both activities in the app.
- Before you create an app from scratch, familiarize yourself with PowerApps basics by generating an app and then customizing that app's gallery, forms, and cards.
- Switch to an environment in which a database has been created with sample data. If you have an appropriate license, you can create an environment to meet this need.
- To create an app, you must be assigned to the Environment Maker security role.
Open a blank app
Sign in to PowerApps.
Under Make your own app, hover over the Start from blank tile for canvas apps, click or tap the phone icon, and then click or tap Make this app.
You can design an app from scratch for phones or other devices (such as tablets); this topic will focus on designing an app for phones.
Specify an entity
In the middle of the screen, click or tap connect to data and then, in the Data pane, click or tap the Common Data Service connection.
In the search box, type or paste the first few letters of Accounts to filter the list of entities, select the Accounts check box, and then click or tap Connect.
Close the Data pane by clicking or tapping the close icon in the upper-right corner.
Add a list screen
On the Home tab, click or tap the down arrow for New screen, and then click or tap List screen.
In the left navigation bar, click or tap TemplateGalleryList1 to select it, and then set the value of the Items property to this formula:
SortByColumns(Search(Accounts, TextSearchBox1.Text, "name"), "name", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
This formula specifies that:
The gallery should show data from the Accounts entity.
The data should be sorted in ascending order until a user clicks or taps the sort button to toggle the sort order.
If a user types or pastes one or more characters into the search bar, the list will show only those accounts for which the name field contains the characters that the user specified.
You can use these and many other functions to specify how your app appears and behaves.
Set the gallery's layout to show only the name of each account, and configure the title bar to show the word Browse, as Customize a gallery describes.
In the left navigation bar, hover over Screen1, click or tap the ellipsis icon (...), and then click or tap Delete.
In the left navigation bar, hover over Screen2, click or tap the ellipsis icon (...), and then click or tap Rename.
Type or paste BrowseScreen, and then rename the gallery in that screen as BrowseGallery.
Add a form screen
Repeat the first step of the previous procedure, except add a Form screen instead of a List screen.
Set the form's DataSource property to Accounts and its Item property to BrowseGallery.Selected, as shown on the Advanced tab of the right-hand pane.
On the Properties tab of the right-hand pane, click or tap Accounts to open the Data pane, and then select the checkboxes for these fields:
- Account name
- Address 1: Street 1
- Address 1: City
- Address 1: ZIP/Postal code
- Number of Employees
- Annual Revenue
Set the title bar's Text property to show Create/Edit.
The screen reflects your changes.
Rename this screen FormScreen.
On the BrowseScreen, click or tap the circular icon near the top of the screen, and set its OnSelect property to this formula:
Click or tap the plus icon, and set its OnSelect property to this formula:
NewForm(EditForm1); Navigate(FormScreen, ScreenTransition.None)
Click or tap the first arrow pointing to the right, and set its OnSelect property to this formula:
EditForm(EditForm1); Navigate(FormScreen, ScreenTransition.None)
On the FormScreen, click or tap the cancel icon, and set its OnSelect property to this formula:
Click or tap the checkmark icon, and set its OnSelect property to this formula:
SubmitForm(EditForm1); Navigate(BrowseScreen, ScreenTransition.None)
On the Insert tab, click or tap Icons, and then click or tap the Trash icon.
Set the Trash icon's Color property to White and its OnSelect property to this formula:
Remove(Accounts, BrowseGallery.Selected); Navigate(BrowseScreen, ScreenTransition.None)
Test the app
In the left navigation bar, select BrowseScreen, and then open Preview by pressing F5 (or by clicking or tapping the play icon near the upper-right corner).
Toggle the list between ascending and descending sort orders, and filter the list by specific characters in each account name.
Add an account, edit the account that you added, start to update the account but cancel your changes, and then delete the account.