Answered

Filter Gallery by Last Name A - Z

(0) Share

Report

Posted on by Phineas

5,331 Moderator

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)

Sort by

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!

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 37,152 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

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