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)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@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
a
(1)

Report
Copy link

Link copied!

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

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

Like
a
(1)

Report
Copy link

Link copied!

@JR-BejeweledOne

Sometimes the mind blends everything together 🙂

Was this reply helpful? Yes No