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:

  • BrowseScreen1 shows a subset of one or more fields, a search bar, and a sort button that lets users easily find a specific record.
  • DetailsScreen1 shows more or all fields for a specific record.
  • EditScreen1 provides UI elements that let users create or update a record and save the changes.

Note: You can also generate an app based on a custom SharePoint list.

Prerequisites

Create an app

  1. In PowerApps Studio, click or tap New on the File menu (near the left edge).

    New option on the File menu

  2. Follow any of these steps:

    • If your cloud-storage account appears under Start with your data, click or tap Phone layout.

    Option to create an app from data - 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.

    Connect to OneDrive

  3. Under Choose an Excel file, browse to FlooringEstimates.xlsx, and then click or tap it.

    FlooringEstimates Excel file

  4. Under Choose a table, click or tap FlooringEstimates.

    Select FlooringEstimates table

  5. Click or tap Connect to generate the app.

  6. 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).

    Choose Next for tour

    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.

Change the gallery layout

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.

  1. In the left navigation bar, click or tap an icon in the upper-right corner to switch to the thumbnail view.

    Toggle the views

  2. Click or tap the top thumbnail to ensure that the browse screen (BrowseScreen1) is selected.

  3. Click or tap anywhere in the gallery, such as the first image.

    Select image

  4. 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.

    Select layout

    The layout of the app changes to reflect your choice.

    BrowseScreen1 with new layout

Change the data that appears

  1. Under Search items, click or tap Carpet to select the Label control.

    The associated list is highlighted in the right-hand pane.

    Select first label

  2. In the right-hand pane, open the highlighted list, and then click or tap Name.

    Set first label

  3. Open the bottom list, and then click or tap Category.

    Set category

    BrowseScreen1 changes to show a name and a category for each record.

    BrowseScreen1 with new content

    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.

Change the order of fields in a form

  1. In the left navigation bar, click or tap the middle thumbnail to open the details screen (DetailsScreen1).

    DetailScreen 1 Thumbnail

  2. Click or tap the image to show options that are available to customize the form.

    Select a card

  3. In the right-hand pane, drag the Name field to the top of the list.

    Move a card

    The screen updates to reflect the changes you made.

    Name at top of screen

Change a control

  1. In the left navigation bar, click or tap the bottom thumbnail to open the edit screen (EditScreen1).

    EditScreen1 thumbnail

  2. 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.

    Select overview card

  3. 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.

    Change card

Run the app

As you customize an app, you can test your changes by running the app in Preview mode.

  1. In the left navigation bar, click or tap the top thumbnail to open the browse screen (BrowseScreen1).

  2. Open Preview mode by pressing F5 or by clicking or tapping the Play button near the upper-right corner.

    Preview icon

  3. On BrowseScreen1, click or tap the arrow to the right of a record to show the record in the details screen (DetailsScreen1).

    Select an arrow on BrowseScreen1

  4. On DetailsScreen1, click or tap the pencil icon in the upper-right corner to show the record in the edit screen (EditScreen1).

    Edit a record

  5. 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.

    Save changes on EditScreen1

  6. Close Preview mode by pressing Esc (or by clicking or tapping the close icon below the title bar).

    Close Preview mode

Next steps

  • To save the app so that you can run it from other devices, press Ctrl-S.
  • Now that you've learned how to generate an app from data, you can create an app from scratch.
  • Share the app so that other people can run it.