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

Answered

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

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Sort(colPreisentwicklung,Value(Nummerierung),Ascending)
SM-20081418-0 54 on at

Like
a
(1)

Report
Copy link

Link copied!
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...
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Glad it worked out for you

Join the conversation