cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ElleVee
Helper I
Helper I

People Picker from SharePoint List

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-monli-msft
Community Support
Community Support

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-fie...

 

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

10 REPLIES 10
v-monli-msft
Community Support
Community Support

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-fie...

 

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

That worked. Thank You!!

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

Anonymous
Not applicable

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.

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 )

 

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

 

Anonymous
Not applicable

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?

Anonymous
Not applicable

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
Advocate II
Advocate II

Good resource on setting up a people picker control in PowerApps

 

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

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (2,162)