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 |
An Excel file with the data formatted as a table:
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.
At powerapps.com, expand Manage, and select Connections:
Select New connection, and select your cloud storage connection. For example, select OneDrive.
You are prompted for the user name and password of your cloud storage account. Enter them, and then select Sign in:
Once you are signed in, this connection is ready to be used within your apps.
In your app, open the Data sources tab of the right-hand pane, select your cloud storage connection, and then choose the Excel table.
Select Connect. When you do this, the table is listed as a Data source:
NOTE Remember, the Excel data must be formatted as a table.
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:
The gallery is automatically updated with information from your Excel table.
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
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.
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.