Drop down cant get to show data from excel

[Stu_Griffin]

Hi hoping for some help,

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

Distinct(TABLE NAME, COLUMN NAME)

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

[mdevaney]

@Stu_Griffin 

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."

[Stu_Griffin]

@mdevaney , thanks for the reply

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

[MarvinBangert]

Hey @Stu_Griffin 

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

Distinct(UserName.Name,Name)

Regards

Marvin 

[Stu_Griffin]

@MarvinBangert Thanks Marvin

Gave it a try but still not working

[MarvinBangert]

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?

Regards

Marvin

[Stu_Griffin]

Hi @MarvinBangert  

[WarrenBelz]

Hi @Stu_Griffin ,

Just helping original responder @mdevaney here.

You need

Distinct(UserName,Name)

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

[mdevaney]

@Stu_Griffin
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.

[Stu_Griffin]

@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 🤔