Answered

PowerApps - Sort and Filter Galleries

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So I have the gallery before and I Want to sort Ascending/descending by the Employees Name (which is the Author column in SharePoint) but when i press the sort button, this is what happens:

Also for the search, i want to be able to type persons name in and it filters for them but that also doesn't work.

This is the formula:

SortByColumns(Filter([@'Compliance Team Leave Requests'],StartsWith('Title',TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

VeGETzX 367 on at

Like (0)

Report
Copy link

Link copied!
You must specify which column to search with your StartsWith function, and the Author column is a person column that contains all of the author including DisplayName, Email, etc. In this case you want to search by Author DisplayName, so use 'Author.DisplayName'.

And, for SortByColumns to work, you must replace "Title" with the column you want to use for sorting (Author.DisplayName), but you cannot use "Author.DisplayName." This is where AddColumns comes in; it will extract the Author.DisplayName from the person column and stored it in a new column called "AuthorDisplayName," which you can use for sorting.

Try put this code into Items property of your gallery.

SortByColumns( Filter( AddColumns( [@'Compliance Team Leave Requests'], "AuthorName", Author.DisplayName ), StartsWith( Author.DisplayName, TextSearchBox1.Text ) ), "AuthorName", If( SortDescending1, Descending, Ascending ) )

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

Like (0)

Report
Copy link

Link copied!

hi @Anonymous your function is sorting "Title" and not author hence the sequence you have, based on the title being annual leave and TOIL. replacing the title with author as per @VeGETzX it will sort as you want it to. the Author.DisplayName being the 'Employee Name'.DisplayName.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

Could you please tell me that if you want to search and sort by the 'Name of Employee' column in your list?

The StartsWith() function you provided should reference to the 'Name of Employee' column directly as below:

SortByColumns(AddColumns(Filter([@'Compliance Team Leave Requests'],StartsWith('Name od Employee'.DisplayName,TextSearchBox1.Text)),"EmployeeName",'Name od Employee'.DisplayName), "EmployeeName", If(SortDescending1, Descending, Ascending))

You should know that a Person column could not be supported in SortByColumns() function, so I add a temporary text column instead.

Was this reply helpful? Yes No