PowerApps offers several cloud-storage connections. Using any of these connections, you can store an Excel file and use the information in it throughout your app. These connections include:

Azure Blob Box Dropbox Google Drive OneDrive OneDrive
for Business
Icon API Icon API Icon API Icon API Icon API Icon

What you need to get started

  • Access to powerapps.com or install PowerApps
  • Add the connection
  • Create an app from a template, from data, or from scratch

  • An Excel file with the data formatted as a table:

    1. Open the Excel file, and then select any cell in the data that you want to use.
    2. On the Insert tab, select Table.
    3. In the Save as Table dialog box, select the My table has headers checkbox, and then select OK.
    4. Save your changes.

Known limitations

If Data type unsupported or Not formatted as a table appears when you try to use an Excel connection in your app, format the data as a table.

If your Excel data includes a calculated column, you can't use it to build an app, and you can’t add that data to an existing app.

Connect to the cloud storage connection

  1. At powerapps.com, expand Manage, and select Connections:

    Select Connections

  2. Select New connection, and select your cloud storage connection. For example, select OneDrive.

  3. You are prompted for the user name and password of your cloud storage account. Enter them, and then select Sign in:
    Enter user name and password

    Once you are signed in, this connection is ready to be used within your apps.

  4. In your app, open the Data sources tab of the right-hand pane, select your cloud storage connection, and then choose the Excel table.

  5. Select Connect. When you do this, the table is listed as a Data source:
    Select the Excel table

    NOTE Remember, the Excel data must be formatted as a table.

Using the Excel data in your app

  1. On the Insert tab, select Gallery, and then select a With text gallery control.
  2. Set the Items property of the gallery to your Excel table. For example, if your Excel table is named Table1, then set it to Table1:

    Items property

    The gallery is automatically updated with information from your Excel table.

  3. In the gallery, select the second or third Text box control. By default, you see the Text property of the second and third text boxes is automatically set to ThisItem.something. You can set these text boxes to any column in your table.

    In the following example, the second text box is set to ThisItem.Name and the third text box is set to ThisItem.Notes:

    Second text boxe

    Third text boxes

    Sample output:
    Second and third text boxes

    NOTE The first box is actually an image control. If you don't have an image in your Excel table, then you can delete the image control, and add a text box in its place. Add and configure controls is a good resource.

Understand tables and records provides more details and some examples.

Helpful links

See all the available connections.
Learn how to add connections and add a data source to your apps.
Understand tables and records with tabular data sources.
Some additional gallery resources include Show a list of items and Show images and text in a gallery.