Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Drop down cant get to show data from excel

Hi hoping for some help,


Quite new to this but struggling to show data from excel table in a drop down. Currently using: - 




I've connected to the data source but when i preview it doesn't show any data.

Super User III
Super User III


You have the correct syntax so I would expect PowerApps to show some options.  Did you use this code within the Items property of the dropdown?


Can you please share a screenshot of your app?  Make sure the code you used in the Items property is displaying in the formula bar inside your screenshot. 


Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

@mdevaney , thanks for the reply



Attached data (blanked out for screenshot) and power apps screen shot with syntax

Hey @Stu_Griffin 

please add the column to your source within the Distinct like:





@MarvinBangert Thanks Marvin


Gave it a try but still not working

Hey @Stu_Griffin 

thanks for your feedback. If you click on the arrow under your formula bar, you would see a preview of your items. Is there any data shown?

Image 612.png




Hi @MarvinBangert  



Hi @Stu_Griffin ,

Just helping original responder @mdevaney here.

You need


Also "Name" is not a good title for a field as it is a reserved word.

100% agreed with @WarrenBelz here.

But the formula may not be the main problem here. I think the UserName datasource does not have any values in it.

Is UserName a SharePoint list or Excel? You might need to refresh the datasource. Click on the datasource name on the left side menu then click refresh.

If it’s a collection then you need to go back to where the data gets loaded into the collection and start figuring it out from there. It would be a good idea to take a look at the collections viewer in this case to inspect if there’s any data inside.

Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

@mdevaney @WarrenBelz @MarvinBangert 


Thanks all for your help.


I've managed to solve, turns out that if the excel document was open it wouldn't work. As soon as i closed the document it worked 🤔

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (76,740)