web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Load user dispay name ...

Power Apps

Answered

Load user dispay name in a dropdown

(0) Share

Report

Report

Posted on by roby9390

105

Hi,

I have a gallery with data from my SharePoint list. I would like to, mediate a drop-down, the user can filter by the author of the record. Obviously I will need the Distinct function to make sure there are no duplicates if a User has created multiple records but I do not know how to set the formula in the Item property of the drop-down.
Can anyone help me?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@roby9390 - if you just need a list of distinct display names sorted alphabetically:

Sort( Distinct( 'Your List', 'Your People Field'.DisplayName ), Value, SortOrder.Ascending )

However, if you also need the other attributes in the record (DisplayName, Email etc), then you can use:

Sort( ForAll( Distinct( 'Your List', 'Your People Field' ), ThisRecord.Value ), DisplayName, SortOrder.Ascending )

Please note the Distinct function is not delegable.

Was this reply helpful? Yes No

Join the conversation