cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
atha_anto
Regular Visitor

Dropdown menu problem - Multiple entries appearing instead of 1

Hello, 

 

I am trying to create a gallery in which I can search and select from the list, I have seen some video how to do this but I have a problem in one point. when I make the drop down menu and link it, each entry in the list appears multiple times instead of once as it should. As you can see below instead of the "LG" entry showing once and when I select it to show all the entries with "LG" it shows the word "LG" several times in the dropdown. The same happens with all entries.

atha_anto_0-1660037747130.png

 

I created the gallery from a sharepoint list. The sharepoint is from an imported excel.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Nogueira1306
Super User
Super User

Use the function Distinct()

 

https://powerusers.microsoft.com/t5/Building-Power-Apps/Distinct-values-on-a-filtered-drop-down/td-p...

 

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-distinct

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

View solution in original post

4 REPLIES 4
Nogueira1306
Super User
Super User

Use the function Distinct()

 

https://powerusers.microsoft.com/t5/Building-Power-Apps/Distinct-values-on-a-filtered-drop-down/td-p...

 

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-distinct

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

NandiniBhagya20
Solution Sage
Solution Sage

Hi,

Could you please share items property of dropdown field


Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Sorry i didnt understand, what you want to share?

That worked, i made a few mistakes but finally i made it! thanks a lot. Also i have "connected" the search box succesfully and now works with dropdown and search together. Easy for you.. first time for me. Again, thank you!

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (4,673)