Delivering Efficiency so you can complete your mission with precision. 

Menu

Create a canvas app with data from an Excel file

In this topic, you’ll create your first canvas app in Power Apps using data from an Excel table. You’ll select an Excel file, create an app, and then run the app that you create. Every created 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 Power Apps, you can sign up for free.

Watch this video to learn how to create a canvas app with data from an Excel file:

Prerequisites

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

 Important

Create the app

  1. Sign in to Power Apps.
  2. Under Start from, select Excel.

    Select Excel.

  3. If you don’t have a OneDrive for Business connection already, you’ll be prompted to create. Select Create to create the connection.
  4. Select OneDrive for Business connection.

    Select OneDrive for Business connection.

  5. Browse to the location where you have the Excel file—FlooringEstimates.xlsx in this example.
  6. Under Choose a table, select the table—FlooringEstimates in this example, and then select Connect.

    Choose your table.

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.

    For example, type or paste Honey to show the only record for which that string appears in the product’s name, category, or overview.

    Filter example.

  4. Add a record:
    1. Select the plus icon.

      Plus icon.

    2. Add whatever data you want, and then select the checkmark icon to save your changes.

      Save icon.

  5. Edit a record:
    1. Select the arrow for the record that you want to edit.

      Next arrow.

    2. Select the pencil icon.

      Pencil icon.

    3. Update one or more fields, and then select the checkmark icon to save your changes.

      Save icon.

      As an alternative, select the cancel icon to discard your changes.

  6. Delete a record:
    1. Select the next arrow for the record that you want to delete.

      Next arrow.

    2. Select the trash icon.

      Trash icon.

Recents Posts