Generate a canvas app from Excel in PowerApps

In this topic, you'll automatically generate your first canvas app in PowerApps using data from an Excel table. You'll select an Excel file, generate an app, and then run the app that you generate. Every generated app includes screens to browse records, show record details, and create or update records. By generating an app, you can quickly get a working app using Excel data, and then you can customize the app to better suit your needs.

The Excel file must be in a cloud-storage account, such as OneDrive, Google Drive, or Dropbox. This topic uses OneDrive for Business.

If you don't have a license for PowerApps, you can sign up for free.

Prerequisites

To follow this topic exactly, download the Flooring Estimates file in Excel, and save it in your cloud storage account.

Important

You can use your own Excel file, but the data must be formatted as a table. For more information, see Format a table.

Generate the app

  1. Sign in to PowerApps.

    PowerApps home page

  2. Under Make apps like these, hover over Start from data, and then select Make this app.

    Option to create an app

  3. Under Start with your data, click or tap Phone layout on the tile for your cloud-storage account.

    Option to create an app

  4. If prompted, click or tap Connect, and provide your credentials for that account.

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

  6. Under Choose a table, click or tap FlooringEstimates, and then click or tap Connect.

    Option to create an app

Run the app

  1. Open Preview by pressing F5 (or by clicking or tapping the play icon near the upper-right corner).

    Open Preview

  2. Toggle the sort order by clicking or tapping the sort icon near the upper-right corner.

    Sort icon

  3. Filter the list by typing or pasting one or more characters in the search box.

  4. Click or tap the plus icon to add a record, add whatever data you want, and then click or tap the checkmark icon to save your changes.

  5. Click or tap the next arrow for the record that you added, click or tap the pencil icon to edit the record, update one or more fields, and then click or tap the checkmark icon to save your changes.

  6. Click or tap the next arrow for the record that you added, click or tap the pencil icon to edit the record, update one or more fields, and then click or tap the cancel icon to discard your changes.

  7. Click or tap the next arrow for the record that you added, and then click or tap the trash icon to delete that record.

Next steps

Customize the default browse screen to better suit your needs. For example, you can sort and filter the list by product name, not category.