Answered

AddColumns with Sort for ComboBox

(0) Share

Report

Posted on by JR-BejeweledOne

5,836 Moderator

I am having a problem getting the Sort to work correctly on a combobox that is displaying an added column. The ComboBox is using the "DisplayName" column (added column) as the Display field and that works perfectly. It will not sort however.

Sort(
 AddColumns(
 GroupBy(Holidays,
 "Country", "Region", "Year", "Result"),
 "DisplayName", Country & If(!IsBlank(Region), " - " & Region)),
 "DisplayName", SortOrder.Ascending
 )

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@JR-BejeweledOne

Consider the following change:

Sort( AddColumns( GroupBy(Holidays, "Country", "Region", "Year", "Result" ), "DisplayName", Country & If(!IsBlank(Region), " - " & Region) ), DisplayName, SortOrder.Ascending )

Or use the SortByColumns function:

SortByColumns( AddColumns( GroupBy(Holidays, "Country", "Region", "Year", "Result" ), "DisplayName", Country & If(!IsBlank(Region), " - " & Region) ), "DisplayName", SortOrder.Ascending )

I hope this is helpful for you.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (1)

Report

Ok, this is my DUH moment of the day. Thank you

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@JR-BejeweledOne

Sometimes the mind blends everything together 🙂

Was this reply helpful? Yes No