Excel

Excel is kind of a connection. To display Excel data in your app:

  1. Format the Excel data as a table.
  2. Store the Excel file in a cloud-storage account, such as Box, Dropbox, Google Drive, OneDrive, and OneDrive for Business.
  3. Connect to the cloud-storage account, and then add the Excel table as a data source.
  4. Display this information in your app by generating an app automatically or by adding and configuring, for example, a Gallery control.

Note: Once you connect to your Excel table from PowerApps, PowerApps will create a new column called __PowerAppsId__, with a unique ID for each row of your Excel table.

Overview of the cloud-storage connection shows you how to add the connection, add an Excel table as a data source, and use the Excel data in your app.

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

Known limitations

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