Unanswered

Sort Office 365 Direct Reports by user last name A-Z

(0) Share

Report

Posted on by Harry_rx

I have this query to show direct reports in gallery:

If(
 IsBlank(varSelectedUser),
 Filter(
 Office365Users.DirectReportsV2(User().Email).value,accountEnabled=true, Not("a user name" in displayName)),
 Filter(
 Office365Users.DirectReportsV2(varSelectedUser).value,accountEnabled=true, Not("a user name" in displayName))
)

I am trying to figure out the expression to sort the results by the user's last name A-Z. So far no luck. Hoping someone might be able to kindly assist.

Many thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

SebS 4,867 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
@RIYxWRK

try this way I think the column you looking for calls "GivenName" or something so try replace "surname" with it

SortByColumns( If( IsBlank(varSelectedUser), Filter( Office365Users.DirectReportsV2(User().Email).value, accountEnabled=true, Not("a user name" in displayName) ), Filter( Office365Users.DirectReportsV2(varSelectedUser).value, accountEnabled=true, Not("a user name" in displayName) ) ), "surname", Ascending )

Was this reply helpful? Yes No
Harry_rx 96 on at

Like
a
(0)

Report
Copy link

Link copied!

I'll give this a shot and update if it works. Thanks

Was this reply helpful? Yes No