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 / Powerapps Lookup Share...
Power Apps
Answered

Powerapps Lookup Sharepoint dropdown list to populate a people picker.

(0) ShareShare
ReportReport
Posted on by 13

Hello,

 

I have two lists, 1st one is named projectlist2 and the other one is named Admin.

In projectlist2, when a user selects a certain division. I want it to select both emails from the admin list based off of the division and populate the people picker.  I've been messing around with lookup but don't know the syntax very well yet. LookUp(Admin,Division= 

 

2021-11-17 14_31_55-_Untitled - Notepad.png2021-11-17 14_46_45-gtest - Admin - All Items.png2021-11-17 14_46_15-Window.png

 

 

Categories:
I have the same question (0)
  • cwebb365 Profile Picture
    3,294 Most Valuable Professional on at

    Need more info. Is it a single list? What is the column type admin is stored in, just text? You're gonna have to have some kind of way to split the items in Admin if it's text, based on delimiter or it needs to be a multiple select people column, then combo box used and populate default selected items property with the Filter(list,Division = divisiondropdown.selected.value).Admin or some form of that. 

  • sfairley69 Profile Picture
    13 on at

    Hello,

    It's two lists "projectlist2" and "Admin" and the field name for both lists is called StaffAdmin and both are a person or group. 

     

     

    2021-11-17 16_04_48-List Settings.png

  • cwebb365 Profile Picture
    3,294 Most Valuable Professional on at

    Ok, so you are trying to pick a division in one list and pull current admin's from the admin list? Is the people column in projectlist2 allow multiple choices? 

  • sfairley69 Profile Picture
    13 on at

    Yes it is

  • cwebb365 Profile Picture
    3,294 Most Valuable Professional on at

    Ok, so I don't know if there is an easier way to do this, but I think this is probably one of the few ways to do what you're trying to do. It makes it hard cause of multiselect etc. but this should keep the same formatting and search capabilities and allow multi choice. 

     

    You're first step is to create a collection with Person records. So for this, on the onSelect property for your Division Dropdown DataCardValue8 you'll want to do something like this: 

     

    ClearCollect(colDivisionAdmins,ForAll(Filter(Admin,Division= DataCardValue8.Selected.Value).StaffAdmin As Adminx, Adminx.StaffAdmin))

     

    This will create a collection of People records from the admin list that is usable in the existing DataCardValue25 combobox, so you can keep the formatting. The ForAll is used to go through each record from the filter table using the Table function to basically copy the "Record" for the StaffAdmin copy out of it and into the collection for use in the Combobox in next step. 

     

    Next, unlock the StaffAdmin Card on the CreateItem Form (Under advanced). Then select the DataCardValue25 and on the properties tab make sure Select Multiple and Allow Search is turned on. 

     

    Finally for the Items property of the combobox DataCardValue25 plug in colDivisionAdmins. 

  • sfairley69 Profile Picture
    13 on at

    Hello,

    So on DataCardValue8 onselect I added: ClearCollect(colDivisionAdmins,ForAll(Filter(Admin,Division= DataCardValue8.Selected.Value).Staff_x0020_Admin As Adminx, Adminx.Staff_x0020_Admin))

    Then added on datacard25 Item colDivisionAdmins. 

     

    No error but comes up as object and the collection show all three people.

     

     

    2021-11-18 06_36_43-ProjectList2 on gtest forms - Power Apps.png2021-11-18 06_38_07-ProjectList2 on gtest forms - Power Apps.png

  • Verified answer
    cwebb365 Profile Picture
    3,294 Most Valuable Professional on at

    Your field may be messed up from you playing with it previously. You may need to remove it. And add it back then do the steps again.

     

    check what’s in displayfields 

  • sfairley69 Profile Picture
    13 on at

    ok I'll try that

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 421

#2
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 278 Super User 2026 Season 1

Last 30 days Overall leaderboard