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.