Combobox sorting isn't working with Distinct

(0) Share

Report

Posted on by vermaaman

134

Hello,

I have a column data loaded into combobox from a collection. trying to apply sorting but doesn't work. Am i doing something wrong here. Below is my code.

Sort(
 Distinct(
 collResponseData,
 DateValue(StartDate)
 ),
 Result,
 Ascending
)

Your help is highly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

The result of distinct is string, so technically your formula works 🙂

Simply convert it back to date and time (DateTimeValue).

Was this reply helpful? Yes No
vermaaman 134 on at

Like
a
(0)

Report
Copy link

Link copied!

@Akser Just tried that, it is now converting to year to 2024 though i have data only for 2021, 2022 and 2023 also the sorting isn't in chronological order.

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
I assume you'd like to have distinct days?
Sort( Distinct( collResponseData, Text(StartDate, ShortDate) ), DateValue(Result), Ascending )

Was this reply helpful? Yes No
vermaaman 134 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Akser - Yes, i have distinct days, these dates are coming from collection. I tried your last code, still not sorting.

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Interesting. Let's see if sorting first will do the trick:

Distinct( SortByColumns( collResponseData, StartDate, Ascending), Text(StartDate, ShortDate) )

Was this reply helpful? Yes No
vermaaman 134 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Akser - Thanks for not giving up so far. Still not working.

Do you think there might be some conversion issue ?

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @vermaaman,

You are sure that 'StartDate' is of type date?

Was this reply helpful? Yes No
vermaaman 134 on at

Like
a
(0)

Report
Copy link

Link copied!

@Akser Getting JSON >> Manipulating it, converting type of StartDate and saving in collection. looks like it is still a text!!

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@vermaaman, that's a lot of columns... I also do not see where you convert StartDate to DateValue?

Anyway, now that we know it's a text column, let's try this:

Distinct( Sort( collResponseData, DateValue(StartDate) ), StartDate)

Was this reply helpful? Yes No
Blarue 76 on at

Like
a
(0)

Report
Copy link

Link copied!

I have the same problem with a much simpler data source. I have a basic collection with one column (Value) using this formula on my Items property and it does nothing.

Sort(Distinct(Col_GalProducts, Value), Value,SortOrder.Ascending)

Was this reply helpful? Yes No