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

Re: Drop down cant get to show data from excel

@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
Regular Visitor

Re: Drop down cant get to show data from excel

@mdevaney , thanks for the reply

 

 
 
 

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

Highlighted
Resolver III
Resolver III

Re: Drop down cant get to show data from excel

Hey @Stu_Griffin 

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

Distinct(UserName.Name,Name)

 

Regards

Marvin 

Highlighted
Regular Visitor

Re: Drop down cant get to show data from excel

@MarvinBangert Thanks Marvin

 

Gave it a try but still not working

Highlighted
Resolver III
Resolver III

Re: Drop down cant get to show data from excel

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
Regular Visitor

Re: Drop down cant get to show data from excel

Hi @MarvinBangert  

 

1.1.png

Highlighted
Super User III
Super User III

Re: Drop down cant get to show data from excel

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

Re: Drop down cant get to show data from excel

@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
Regular Visitor

Re: Drop down cant get to show data from excel

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

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,559)