web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / SharePoint People Pick...
Power Apps
Unanswered

SharePoint People Picker and ComboBox

(0) ShareShare
ReportReport
Posted on by 284

Hello guys, 

 

I have a ComboBox where I want to filter by Employee.

I have a SP List where i have a People Column called Employee. Some users have multiple entries, some one, and the rest no entries. 

 

Now I want, that in the ComboBox Menu only those People show up, which has entries in the SP list.

 

Example.
User A - User Z

 

Entries have User A /User B / User C / User D.

 

if I use Choices(List.Employee) all Users A-Z show up, but I only want that I have to select between User A /User B / User C / User D.

Categories:
  • LukeShive Profile Picture
    66 on at

    There are couple ways to get what You want. You can either use Filter function to show only those with entries

    Filter(Choices(List.Employee),Value<>"no entries")

    or create already filtered collection and refer to it in ComboBox.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 271

#3
Mohsin Ali Profile Picture

Mohsin Ali 223

Last 30 days Overall leaderboard