Can I source the list items of a dropdown box from an excel sheet in Power Apps?

Question

I have a long list of codes that change monthly, that I would like to include in my app as a dropdown. However, I do not know how to import that list into Power Apps.

Answer 1

Of course, you can keep the Excel online from OneDrive, then change the content every month.

So now create a connection to the OneDrive file, load the excel content into collections using ClearCollect(YourCollectionNameHere,Table1) on App start.

Then bind the Table1 to your dropdown control values. Reference

Answer 2

You can keep the list in any data source supported by PowerApps and pull it in OnStart of the application. Create a collection using something like ClearCollect(colName, Filter(dataSource, condition = value)). Be sure to use a delegable data source if more than 2000 values are returned.

Some Data Source Ideas: (there are something like 200 available out-of-the box!)

• Excel (manually uploaded and app republished)
• Excel Online + OneDrive
• Sharepoint list
• Azure SQL table
• On-prem database table + OnPrem Data Gateway
• REST endpoint + custom connector

You could even use Flow to pull the table out of the text of an email body!

The sky is the limit in regards to extensibility. The question usually comes down to premium licensing costs. Do you want to pay for a better data source?