Skip to main content

Notifications

Power Apps - Power Apps Experimental Features
Suggested answer

Drop down list issue

Posted on 9 Dec 2024 21:03:13 by 10
I have a problem with my drop-down list. 
linked to a sharepoint table and the column is a tpe choices but the list shows me all the elements of the column.
and when i use the Choices(). it doesn't show the desiref column 
I am able to filter with distinct() function. but it is not accurate when filtering 
thank you for your help
 
  • Suggested answer
    WarrenBelz Profile Picture
    WarrenBelz 143,595 on 14 Dec 2024 at 21:35:28
    Drop down list issue
    I assume this is a Lookup column - if you put this in the Combo Box Items
    DropColumns(
       GroupBy(
          Choices([@YourListName].YourFieldName),
          Value,
          Id,
          Data
       ),
       Data
    )
    you will get a distinct list and the rest of the functionality should also work. NOTE: it will only get complete results if the number of items in your looked up list is under your Data Row Limit. If it is bigger than this, I have a blog on an alternative method that may be of use.
     
    Please click Does this answer your question 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 a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    Buy me a coffee
  • Suggested answer
    Garima_PowerPlatform Profile Picture
    Garima_PowerPlatform 107 on 09 Dec 2024 at 22:59:24
    Drop down list issue
    Hi 

    If the Choices() function isn't giving the desired result, double-check the syntax

    Choices([@YourDataSource].ChoiceColumn)

    If you want to filter dropdown values based on another condition, you can filter the SharePoint list and extract distinct values.

    Distinct(
    Filter(
    Tasks,
    Client = Dropdown_Client.Selected.Value
    ),
    Status.Value
    )

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,595

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,098

Leaderboard

Featured topics