web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sort a Gallery where C...

Power Apps

Answered

Sort a Gallery where Column is SharePoint Person

(0) Share

Report

Report

Posted on by VictorTek

127

Hi,

I have a SharePoint List which has 2 columns:

Title (Pod Name)
Name

Name is a Person column in SharePoint.

In PowerApps, I have a gallery which pulls through the names and Pod Names. I also have a Text Input to allow users to filter the gallery.

I want to sort the gallery in to Name alphabetical order. Here is my current code:

SortByColumns(
If(IsBlank(TextInput2.Text), 'PSMC Cover Pods', Filter('PSMC Cover Pods', TextInput2.Text in Name.DisplayName)),"{Name}")

This current sorts by Title (Pod Name) and not Name. Can anyone help?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@VictorTek

SortByColumns( Filter('PSMC Cover Pods',Len(TextInput2.Text)=0 || TextInput2.Text in Name.DisplayName), "Name",SortOrder.Ascending)

Was this reply helpful? Yes No
VictorTek 127 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Drrickryp - however the above returns an error saying "The function "SortByColumns" has some invalid arguments"

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@VictorTek

See if Intellisence suggests an alternative for your "Names" column. Is Names a complex type column?

Was this reply helpful? Yes No
VictorTek 127 on at

Like (0)

Report
Copy link

Link copied!

It is a Person column in SharePoint. It allows you add people from AD:

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@VictorTek

Then you may need to use AddColumns() to add the Value of the field to reshape the table so you can sort it.

With({_items:AddColumns('PSMC Cover Pods',"dname",Name.DisplayName)}, SortByColumns( Filter(_items,Len(TextInput2.Text)=0 || TextInput2.Text in dname ),"dname", SortOrder.Ascending ) )

Was this reply helpful? Yes No
VictorTek 127 on at

Like (0)

Report
Copy link

Link copied!

Thanks!!

Was this reply helpful? Yes No

Join the conversation