Create an app automatically based on data in an Excel file that you upload to a cloud-storage account, such as OneDrive. After you generate the app, customize it to better suit your needs, and then run it to make sure that it works as you expect.
Generated apps have three screens by default:
Note: You can also generate an app based on a custom SharePoint list.
To follow this tutorial exactly, download this Excel file.
Important: You can use your own Excel file if the data is formatted as a table. For more information, see Create an Excel table in a worksheet.
Upload the Excel file to OneDrive or another cloud-storage account.
In PowerApps Studio, click or tap New on the File menu (near the left edge).
Follow any of these steps:
- If your cloud-storage account doesn't appear under Start with your data, click the arrow at the end of the row of tiles. If your account appears in the list of connections, click or tap that entry. - If your cloud-storage storage account doesn't appear under Start with your data or in the list of connections, click or tap New connection, and then click or tap the entry for your account. Click or tap Connect, and follow the prompts to configure the connection.
Under Choose an Excel file, browse to FlooringEstimates.xlsx, and then click or tap it.
Under Choose a table, click or tap FlooringEstimates.
Click or tap Connect to generate the app.
If you're prompted to take an introductory tour, click or tap Next to get familiar with key areas of the PowerApps user interface (or click or tap Skip).
Note: You can always take the tour later by clicking or tapping the question-mark icon near the upper-right corner and then clicking or tapping Take the intro tour.
When an app is created, it has a default layout based on your data, but you can customize the gallery layout to fit your needs.
In the left navigation bar, click or tap an icon in the upper-right corner to switch to the thumbnail view.
Click or tap the top thumbnail to ensure that the browse screen (BrowseScreen1) is selected.
Click or tap anywhere in the gallery, such as the first image.
In the right-hand pane, open the Layout list, and then click or tap the layout that contains an image, a title, and a subtitle.
The layout of the app changes to reflect your choice.
Under Search items, click or tap Carpet to select the Label control.
The associated list is highlighted in the right-hand pane.
In the right-hand pane, open the highlighted list, and then click or tap Name.
Open the bottom list, and then click or tap Category.
BrowseScreen1 changes to show a name and a category for each record.
Note: By default, you can scroll through the list (called a gallery) by using a mouse wheel or by swiping up and down on a touch screen. To use either a trackpad or a mouse without a wheel, select the gallery, click or tap Show Scrollbar in the property list, and then replace false with true in the formula bar.
In the left navigation bar, click or tap the middle thumbnail to open the details screen (DetailsScreen1).
Click or tap the image to show options that are available to customize the form.
In the right-hand pane, drag the Name field to the top of the list.
The screen updates to reflect the changes you made.
In the left navigation bar, click or tap the bottom thumbnail to open the edit screen (EditScreen1).
Click or tap Overview.
This step selects the Overview card. Each card contains text that describes the purpose of the card. You can also customize the controls on a card. For more information, see Card control in PowerApps.
In the right-hand pane, click or tap the down arrow for the card, scroll down, and then click or tap Edit multi-line text.
This step shows an overview of each product in a control that's large enough to display the text.
As you customize an app, you can test your changes by running the app in Preview mode.
In the left navigation bar, click or tap the top thumbnail to open the browse screen (BrowseScreen1).
Open Preview mode by pressing F5 or by clicking or tapping the Play button near the upper-right corner.
On BrowseScreen1, click or tap the arrow to the right of a record to show the record in the details screen (DetailsScreen1).
On DetailsScreen1, click or tap the pencil icon in the upper-right corner to show the record in the edit screen (EditScreen1).
On EditScreen1, change the information in one or more fields, and then click or tap the check mark in the upper-right corner to save your changes.
Close Preview mode by pressing Esc (or by clicking or tapping the close icon below the title bar).
For information about how to share Excel data within your organization, review these limitations.