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 / People Picker from Sha...
Power Apps
Answered

People Picker from SharePoint List

(0) ShareShare
ReportReport
Posted on by 30

The people picker from the SharePoint list is displaying 0 results. Does PowerApps support the people picker field? If so, how do i configure it to pull from Active Directory?

Categories:
I have the same question (0)
  • Verified answer
    v-monli-msft Profile Picture
    Microsoft Employee on at

    Hi Elle,

     

    If you mean the people and group column type, it should be supported now. If you would like to have text box to display the name of the person or group column type defined in Sharepoint list, we could change the Text function of the Text box with the formula below:

    ThisItem.People.DisplayName

     

    See here:

    https://powerusers.microsoft.com/t5/PowerApps-Forum/How-to-display-a-name-from-the-people-picker-field/td-p/12524

     

    Mona

  • ElleVee Profile Picture
    30 on at

    That worked. Thank You!!

  • lmauriceparker Profile Picture
    22 on at

    Is it possible to select another name to replace the original name in this field?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    What if you want the filed not within a gallery or a form?

     

    For example, just insert a text input field or a drop down field on a blank screen. How would it to act like a people/group picker field?

     

    My personal case is I have a SharePoint list with a people picker field and I want to put in a field for someone to select a person and then patch it in.

     

    Thanks.

  • esoPowerUser Profile Picture
    62 on at

    According to my knowledge, there is no sepearate lookup component against Office 365 profiles etc. However, I think I found a workaround to  get around your challenge of making a people picker you can place wherever you want on a PowerApp Card.
    (assuming you have access to create a SP List and connect it with your PowerApp in your scenario)

     

    I would suggest creating an additional "dummy" gallery and "dummy" edit form, but we're really only interested in showing a dropdown visible on edit form which act as an independent "People Picker" against Office 365

     

    Details:

    1) Create and connect to an SharePoint List with just one User Column

    2) Add an item  with a Random User ( this will show up as default in the people picker )
    3) Add an additional "dummy" Gallery and call it SPLookUpGallery. Set its "datasource" property to the SPList
    2) Add an additional "dummy" EditForm and call it for example "PeoplePickerDropdownForm"
    3) Set the "item" property of the EditForm to to SPLookUpGallery.Selected
    4) Hide the dummy gallery by setting "visible" to false and remove all fields  "Dummy Edit Form" except People dropdown

    5) Do some neccessary GUI adjustments to the dummy edit form until you only see the People Dropdown
    5) You should now have an people picker independent of any existing Galleries or Edit Forms
     

    It should be now quite easy to reuse the selected value where ever you want:
    Like: [DataCardValue Dummy Edit Form].Selected.DisplayName  <--- Click on the dropdown to get the name
    Now the selected User value ca be used for example in filters/ lookups or other components on the card

    and not just in an selected item in edit form connected to an gallery in use. ( thus the trick with the dummy gallery/ form )

  • esoPowerUser Profile Picture
    62 on at

     

    This seems like another and possible better and cleaner variant than my suggestion

    on creating a people picker.

     

    Rathanavel Subramaniam on his blog http://ratsubsharewall.blogspot.no/

     

    http://ratsubsharewall.blogspot.no/2017/11/people-picker-control-in-powerapps.html

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi Mona,

     

    I have checked the functions in the text box control and I do not have the Text function available as per the screenshot attached.

     

    Can you tell me where exactly I can find this?

    Text Field Missing.PNG
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi,

     

    In my scenario, My SharePoint list as a Poeple picker with multiple selections enabled. And there are couple of items on the its that has multiple users on people picker column.

    on PowerApp when i try to insert a datatable and get information from sharepoint list to the datatable on powerApps.

    The PeoplePicker colums is empty. i'm unable to get user info unto the column.

    Please let me know if you have any workarounds available.

     

    Thanks in Advance.

  • mbrocchi1 Profile Picture
    110 on at

    Good resource on setting up a people picker control in PowerApps

     

    https://youtu.be/-UKk6bXUW-g

     

  • AutoDealerAdmin Profile Picture
    2 on at

    I am having a similar issue. I have the People picker created and it works with no trouble and it adds the user after selecting them. Once done selecting the users i click next to go to the next screen. Again, that part works too. Where I am stuck is, how can I display or list the users i have selected in the next screen? I want to be able to have a  toggle or combo box control that can be selected that tells the person controlling the app if the people listed are available, In Appointment, W/Guest or Out. I am brand new to using PowerApps and have not done any programming type work in about 20 years so I am stuck. Any help would be GREATLY appreciated.

    PeoplePicker.JPG

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 899

#2
Valantis Profile Picture

Valantis 571

#3
11manish Profile Picture

11manish 499

Last 30 days Overall leaderboard