Breyta

Deila með


Connect to Excel from Power Apps

Excel is a connection that becomes a data source when added to Power Apps. To connect to Excel from Power Apps, follow these three steps.

Step 1 - Format your data as a table in Excel

Ensure that the Excel data you want to use in Power Apps is formatted as a table in Excel.

Step 2 - Store your Excel file in a cloud location

Store the Excel file in a cloud-storage account, such as Dropbox, Google Drive, OneDrive, and OneDrive for Business. There are two versions of the Excel connector. The newer version Excel Online (Business) of the connector can access more cloud locations.

Step 3 - Add Excel as a data source for your Power App

  1. Sign in to Power Apps.
  2. Depending on how you want to create your app, from the home screen, select one of the following options:
    • To create a single-page gallery app with a responsive layout, choose either:
      • Start with data > Connect to external data > From Excel.
      • Start with page design > Gallery connected to external data > From Excel.
    • To create a three screen mobile app, select Start with an app template > From Excel.
  3. Only one connection is shown at a time. To select a different connection, select on the ... button to switch connection or add a new connection.
  4. Enter the file location and select the table.
  5. When you're done, select Create app.

Use the Excel Online (Business) Connector

In the past, Power Apps used the OneDrive connector to connect and get data from Excel. The OneDrive connector provided access to files on OneDrive and to Excel. Now authors should use the new recommended Excel Online (Business) connector. The Excel Online connector allows multiple users to access it and improved functionality.

Other connectors

For information about how to connect to other types of data, see the list of connections for Power Apps.

Known limitations

For information about how to share Excel data within your organization, review these limitations.