Unanswered

SortByColumns Ascending/Descending not working properly

(0) Share

Report

Posted on by IsabellaFranco

Hello!

I'm having problems using the SortByColumns function, ascending and descending work correctly only for values below 10. Is it a bug or am I doing something wrong?

The code in the Gallery Items and table:

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

LaurensM 12,516 Moderator on at

Like (2)

Report
@IsabellaFranco this could be caused due to the prof_inicial being defined as text and not numbers.

Could you give the code below a try:
Sort(ColSondagem; Value('Prof_inicial'); Ascending)

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (2)

Report

hi @IsabellaFranco the solution by @LaurensM is 100%. you may want to consider changing the type of that column to a numeric one unless it needs to be text for a specific reason.

Was this reply helpful? Yes No
IsabellaFranco 44 on at

Like (0)

Report

Well, I found an alternative with the help of @LaurensM 's solution, but I still don't understand why the first code didn't work... The column was already numeric so I just used "Sort(ColSondagem; "prof_inicial"; Ascending)" and it worked. But is it correct not to work with SortByColumns?

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report

@IsabellaFranco I was unable to recreate that specific issue.

When the field is defined as numeric, both Sort() and SortByColumns() worked fine.
If the field was Text then I had a similar issue both for Sort() and SortByColumns().

Nevertheless, I am glad the issue is resolved.

Was this reply helpful? Yes No