cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
virtualrw
Regular Visitor

People field from Sharepoint List not showing in default app

I created an app from the drop down option in a sharepoint list. The app works find but on the BrowseGallery screen I do not see the people filed as an option in the data (Data Source). It looks like it only shows text fields - none of the others data type show up either. 

 

How can I get the people field to show as an option?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ACC
Frequent Visitor

Re: People field from Sharepoint List not showing in default app

Hi,

 

I am able to display the people from a People or Group field in a SharePoint list.  If the the list has a People field named Approver the add a text field to the gallery with the Text value of ThisItem.Approver.Email  which would display the email address or .DisplayName for the display name.  I have implemented this on a "Blank" gallery layout.

View solution in original post

6 REPLIES 6
ACC
Frequent Visitor

Re: People field from Sharepoint List not showing in default app

Hi,

 

I am able to display the people from a People or Group field in a SharePoint list.  If the the list has a People field named Approver the add a text field to the gallery with the Text value of ThisItem.Approver.Email  which would display the email address or .DisplayName for the display name.  I have implemented this on a "Blank" gallery layout.

View solution in original post

Community Support
Community Support

Re: People field from Sharepoint List not showing in default app

Hi @virtualrw,

 

It is true that with the new patch, people and group column doesn't show in the list of data source window:

Capture.PNG

 

The method @ACC provided works for me, please have a try. 

 

Regards,

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.
virtualrw
Regular Visitor

Re: People field from Sharepoint List not showing in default app

Thanks - that worked!

kbirstein1 Advocate III
Advocate III

Re: People field from Sharepoint List not showing in default app

This worked for me a couple of days ago and now it's not working, even when I add the Outlook 365 User Connection. Looks like it's broken again. Getting the error "The property expects Text values, but the rule produces incompatible Table values". VERY FRUSTRATING! 

 

Anybody got this working? as of February 7, 2018?

kbirstein1 Advocate III
Advocate III

Re: People field from Sharepoint List not showing in default app

I had to add  a DROPDOWN field and then choose "DisplayName" from value and then make the Chevron color WHITE and border "0" so that the field would appear as a text box. Really stupid workaround. Hope this gets fixed soon!!

Rick72 Impactful Individual
Impactful Individual

Re: People field from Sharepoint List not showing in default app

In my case, I did not have to add a text control. I selected the layout Title and subtitle and updated the property Text of the control Subtitle with:

 

ThisItem.Employee.DisplayName

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (5,823)