Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Dropdown and Combobox not sorting

(1) ShareShare
ReportReport
Posted on by 518
Hello
I have a custom page (canvas app) in a model driven App.
I want to sort the items in a dropdown (modern control) or a combobox (classic control).
Into items i put
SortByColumns(Filter(Themen_mit_Budgets,Projekt.Projekt=txt_aktProjekt.Selected.Projekt),"cr8ec_budget",SortOrder.Descending)
 
Anyway the sorting is ignored.
Any idea what could case the problem?
  • SLMR Profile Picture
    SLMR 518 on at
    Dropdown and Combobox not sorting
    Hi ANB
    (i can not select the user with at).
    That will not solve my problem, as i do not want to get the distinct values of buget.

    the table Themen_mit_budgets contains the columns:
    projekt (lookup to projekt)
    display (a text to be displayed)
    budget (a number value)
     
    The dropdown box is part of a gallery
    Dependend on the project of the gallery item, the items to be displayed should be filtered by projekt.
    Futher sorted by the column budget
    and the column display should be visible in the dropdown box.
     
    It is working so far that the values are filtered and right values are displayed in the dropdown box.

    But the valeus are not sorted
  • ANB Profile Picture
    ANB 7,060 on at
    Dropdown and Combobox not sorting
    Hi @SLMR,
     
    Have you tried using Distinct?
     
    Try this:
     
    SortByColumns(Distinct(
        Filter(
            Themen_mit_Budgets,
            Projekt.Projekt = txt_aktProjekt.Selected.Projekt
        ),
            cr8ec_budget
    ), "cr8ec_budget", SortOrder.Descending)
    If the "cr8ec_budget" gives you an error, try "Value" instead.
     

    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.


    Thanks,
    ANB

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard