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
Super User


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

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (4,256)