web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps SortbyColumns not work...

Power Apps

Unanswered

SortbyColumns not working correctly - what am i missign?

(0) Share

Report

Report

Posted on 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

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

zmansuri 6,048 Super User 2024 Season 1 on at

Like (1)

Report

Sort(colPreisentwicklung,Value(Nummerierung),Ascending)

Was this reply helpful? Yes No
SM-20081418-0 54 on at

Like (1)

Report
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...

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report

Glad it worked out for you

Was this reply helpful? Yes No

Join the conversation