Unanswered

Dropdown and Combobox not sorting

(1) Share

Report

Posted on by SLMR

518 Moderator

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
SLMR 518 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No