Values not showing up in the dropdown

[Prats]

I am new to power apps trying to create a simple dropdown which populates field from a data source

But for some reason the values are not showing up.

Clicking on the dropdown nothing shows up 😐 

Need to know what am I doing wrong here

[WarrenBelz]

Hi @Prats ,

Try

Sort(
   Distinct(
      Table1,
      Organisation
   ).Result,
   Result
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Prats]

Hi@WarrenBelz ,First of all thanks for looking into this.

I tried adding the function you provided but I am still not able to get any values from the dropdown, still not sure what is missing. 

Is there something wrong in the table itself?

[WarrenBelz]

Hi @Prats ,

Try cutting and pasting the control in and out of the card Ctrl-X & Ctrl-V (sometimes resets it - there is nothing more in the formula you can do) - what are you using as a Data Source and how many records do you have in it?

[Prats]

@WarrenBelz  I am using an excel file made in table formatting, uploaded on OneDrive.

Organization is having one value for now but will be adding more 

then there is supplier column which is having around 28 distinct value.

Site column is having 78 values.

Idea is to create a cascading dropdown from selecting the org first then accordingly the suppliers and then the sites available in the supplier.

I am following the tutorials on this but some how I am stuck where the values are not showing up from the dropdown

I even tried for supplier values but they are also not populating.

Sort(
Distinct(
Table1,
Supplier
).Result,
Result
)

Let me know if you require anything else to know more about my issue 🙂

[WarrenBelz]

Hi @Prats ,

All I can say is that there should be values in your drop-down (I assume your formula is in the Items property)?

Your original formula should have worked, but I added the specific column to show as a precaution - there are no other formulas to try. Excel however is not a good data source - if you have SharePoint available I suggest you move to it.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.