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