News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps SortbyColumns not work...

Power Apps - Building Power Apps

Answered

SortbyColumns not working correctly - what am i missign?

Like (0) Share

Report

Report

Posted on 24 Nov 2021 12:22:51 by SM-20081418-0

54

Hi, i'm confused, supposed to be a simple task so wtf.

A gallery is filled with data from a collection, im trying to sort the data with

SortByColumns(colPreisentwicklung;"Nummerierung";Descending)

The result:

the data in the collection is imported from an excel-file, i think that is the problem, somehow.

any suggestions=?

greetz

ste

All responses Img

All responses (3)

Answers Img

Answers (1)

zmansuri 6,048 Super User 2024 Season 1 on 24 Nov 2021 at 14:21:16

Like (0)

Report

Re: SortbyColumns not working correctly - what am i missign?

Glad it worked out for you
SM-20081418-0 54 on 24 Nov 2021 at 12:43:33

Like (1)

Report
Re: SortbyColumns not working correctly - what am i missign?

Okay, great, it works, i had this idea before, but it didn't work with SortByColumns and i need to sort several columns.
So my Solution looks like this now:
SortByColumns(Sort(colPreisentwicklung;Value(Nummerierung);Descending);"Jahr";Descending)

But i'm still confused, sortbycolumns works perfect with "Jahr", but not with "Nummerierung", totally strange...
Verified answer

zmansuri 6,048 Super User 2024 Season 1 on 24 Nov 2021 at 12:27:28

Like (1)

Report

Re: SortbyColumns not working correctly - what am i missign?

Sort(colPreisentwicklung,Value(Nummerierung),Ascending)