Answered

SortbyColumns does not allow other columns to set the order of the list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi!

I am trying to use the SortByColumns function to sort the list in the app based on the priority of each item, but the function only allows me to sort by the title of the items.

I have no problems if I use the following function (I am also filtering the list items that area already completed):

SortByColumns(Filter(MyListName; StartsWith(Title; TextSearchBox1.Text) && Estado.Value <> "Completado" );"Title"; If(SortDescending1; Descending; Ascending))

But when I try to filter based on the Priority, it says it has an error but it doesn't specify which error it is. I only change the "Title" for "Priority".

SortByColumns(Filter(MyListName; StartsWith(Title; TextSearchBox1.Text) && Estado.Value <> "Completado" );"Priority"; If(SortDescending1; Descending; Ascending))

In my sharepointlist, the column is named "Prioridad" (it does not work with that name either), but in the sharepoint list I found that the original name of the column was Priority:

https://sitename/teams/MyListName/_layouts/15/FldEdit.aspx?List=%7B9937ACAF%2DE2C4%2D465D%2DA325%2D8EE5728BA612%7D&Field=Priority

does anyone know how to make it work with anything other than the Title?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

What kind of column is Priority?

If it is a choice column, then you need to alter your formula to account for that.

SortByColumns will only accept "real" names of columns (as you found in the list settings) and only simply types (text, number, etc).

So, if your Priority is a choice column, then this will give you the results you would like:

SortByColumns( AddColumns( Filter(MyListName; StartsWith(Title; TextSearchBox1.Text) && Estado.Value <> "Completado" ); "_priority"; Priority.Value ); "_priority"; If(SortDescending1; Descending; Ascending) )

I hope this is helpful for you.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

THANK YOU!!!! Yes, that was the solution to my problem!