SortByColumns Cant working for me

(0) Share

Report

Posted on by Kuszika54

SortByColumns(
Filter('DataBase_Name',
Status.Value="inprogress"
)
,SessionDate
,Descending
)

What is the problem?

Error message:

can you help me?

Thanks

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

FernandoTC 222 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Kuszika54

SortByColumns needs you to specify the columns between quotation marks. Try:

SortByColumns(
Filter('DataBase_Name',
Status.Value="inprogress"
)
,"SessionDate"
,Descending
)

Regards
Kuszika54 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunatly same error message.
FernandoTC 222 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok then I'll need more info.

Which data source are you using? Sharepoint, SQL?
Which data type is the Status field you are using in the filter?

Regards
Kuszika54 19 on at

Like
a
(0)

Report
Copy link

Link copied!

I use Sharepoint database. Status field is a dropdown.
Verified answer

FernandoTC 222 on at

Like
a
(1)

Report
Copy link

Link copied!

Ok.

The formula synthax seems to be ok. Maybe its the column name the thing that is failing. Sometimes if you change the name of a SP list column the old name remains untouched.

Since you are sorting by only one column, you can use the Sort() function instead.

Try:
Sort(
Filter('DataBase_Name',
Status.Value="inprogress"
)
,SessionDate
,Descending
)

Notice the Sort instead of SortByColumns and the column not between quotation marks. If this doesnt work, power apps sould suggest you the available column names you can use within the column parameter of the function.
akhaneja 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Fernando TC,

I'm also facing some issues with sort by column. The above Syntex works with some column names but not for others Column name, please see attached image.
This Condition Working:-
FirstN(
SortByColumns(
Filter(
OfficeBooking1,
BookDate = BookingDate_1.SelectedDate
),
"BookDate",
SortOrder.Ascending
),
10
)

But not for this column name:-
FirstN(
SortByColumns(
Filter(
OfficeBooking1,
BookDate = BookingDate_1.SelectedDate
),
"DeskName",
SortOrder.Ascending
),
45
)
Thank you