cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Anonymous
Not applicable

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

7 REPLIES 7
Anonymous
Not applicable

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.

v-monli-msft
Community Support
Community Support

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 @Anonymous 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.

Thanks - that worked!

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?

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
MVP

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

This unfortunately did not resolve my issue, or maybe I don't understand the steps.  But I am able to see the People column when I insert a Gallery or it shows up on Forms, but anytime I insert anything else (dropdown, etc), the People column is not an option at all.

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 (4,022)