Power Platform Community Forum Thread Details

Hi everyone,

I'm facing an issue with sorting a gallery in Power Apps that's connected to a SharePoint list. My current gallery items property code looks like this:

If(
 show_duplicate = "",
 Filter(PPS_Certification, StartsWith(Name.Email, usersetting_user_search.Text)),
 Filter(PPS_Certification, Name.Email = show_duplicate)
)

The gallery displays data from the "PPS_Certification" list. I want to sort it alphabetically by a column called "Name," but I'm running into problems because "Name" is a Person or Group column.

I came across another forum post where someone suggested creating a new calculated column in SharePoint to extract the display name and then sort by that column in Power Apps. However, when I try to create this calculated column, I get a syntax error. Here's the formula I'm using:

=Name.DisplayName

I'm not sure why this is happening. The column "Name" definitely exists and is a Person or Group type. Any help or suggestions would be greatly appreciated!

Categories:

Building Power Apps