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 / Filter People Picker f...
Power Apps
Unanswered

Filter People Picker field

(0) ShareShare
ReportReport
Posted on by

I have a PowerApp that uses SharePoint as a datasource. One of the fields in the SharePoint list is a People Picker field. I would like to filter the field in the app to select employees from a specific department. The filter is working, the field gets updated in the SharePoint list, but when I view any records, the name doesn't appear in the field on the PowerApp screen. The details listed below are what I am using, as described in another post.

Item Property of the combo box:
Filter(
Office365Users.SearchUser({searchTerm: violation_IssuedBy.SearchText, top:999}),
"Community Development" in Department
)

 

Update property of the datacard: 
{
Claims: "i:0#.f|membership|" & Lower(violation_IssuedBy.Selected.Mail),
DisplayName: violation_IssuedBy.Selected.DisplayName,
Email: violation_IssuedBy.Selected.Mail,
Department: "",
JobTitle: "",
Picture: ""
}

 

DefaultSelectedItems of the combo box:
LookUp(Office365Users.SearchUser(),DisplayName = ThisItem.IssuedBy.DisplayName)

 

I think the DefaultSelectedItems is where it falls apart, because the people picker field is filtered, the right data is written to the SharePoint list, but I can't see the data when looking at the record in my app. 

Any suggestions?

Categories:
I have the same question (0)
  • NandiniBhagya20 Profile Picture
    4,667 Super User 2024 Season 1 on at

    Hi @AnnetteM ,
    Try using below options in DefaultSelectedItems property - 
    1. ThisItem.IssuedBy
    2. 
    {
    Claims: "i:0#.f|membership|" & Lower(ThisItem.IssuedBy.Email),
    DisplayName: ThisItem.IssuedBy.DisplayName,
    Mail: ThisItem.IssuedBy.Email,
    Department: "",
    JobTitle: "",
    Picture: ""
    }

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard