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

Highlighted

@mdevaney , thanks for the reply

 

 
 
 

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

Highlighted

Hey @Stu_Griffin 

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

Distinct(UserName.Name,Name)

 

Regards

Marvin 

Highlighted

@MarvinBangert Thanks Marvin

 

Gave it a try but still not working

Highlighted

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

Highlighted

Hi @MarvinBangert  

 

1.1.png

Highlighted

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.

Highlighted

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

Highlighted

@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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,251)