Unanswered

Filter Gallery by Last Name A - Z

(0) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

I have a Gallery that I am filtering using the following. There are some 600 items in the list, and I am filtering out 271 of them to display in the Gallery.

I am trying to get the items to show in A - Z order. Of the 271 items the first 220 appear in alphabetical order starting with 'C', by last name. The last fifty start again with the last names that start with 'A'. These 'A' names should be at the top of the Gallery.

Gallery1 items -

If(IsBlank(Name_Search_Fld.Text), Filter(DataCollection, PersonType="Teacher", Region = "North", Basis = "1",
FirstName,SortOrder.Descending),

Filter(DataCollection,FirstName=Name_Search_Fld.Text, Region = "North",Basis = "1",FirstName,SortOrder.Descending))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

LaurensM 12,516 Moderator on at

Like (1)

Report

Hi @Phineas,

You are currently filtering your gallery by first name descendingly (z - a). You will have to change this for both Filters to the Last Name column and SortOrder.Ascending.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Phineas

In addition to what @LaurensM says, you're also missing the actual call to the Sort function.

If( IsBlank(Name_Search_Fld.Text), Sort(Filter( DataCollection, PersonType = "Teacher", Region = "North", Basis = "1") FirstName, SortOrder.Ascending ), Sort(Filter( DataCollection, FirstName = Name_Search_Fld.Text, Region = "North", Basis = "1") FirstName, SortOrder.Ascending ) )

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

How do I squeeze in a StartsWith for the lower 'search' function, so that the Gallery populates when the first letter is typed into the search box, rather than having to wait for the entire name to be entered?

Was this reply helpful? Yes No
Verified answer

Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

I messed around and accidently stumbled over my answer.

If(IsBlank(Name_Search_Fld.Text),
Sort(Filter(
DataCollection,
PositionType="Teacher",
Region = "North",
Basis = "1"),
FirstName,
SortOrder.Ascending
),
Sort(Filter(DataCollection,
StartsWith(FirstName,Name_Search_Fld.Text),
PositionType = "Teacher",
Region = "North",
Basis = "1"),SortOrder.Ascending
))

Was this reply helpful? Yes No