cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stu_Griffin
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: - 

 

Distinct(TABLE NAME, COLUMN NAME)

 

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

10 REPLIES 10
mdevaney
Super User III
Super User III

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

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

Distinct(UserName.Name,Name)

 

Regards

Marvin 

@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

 

Regards

Marvin

Hi @MarvinBangert  

 

1.1.png

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.

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

@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

Announcements
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!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

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