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
ACC
Frequent Visitor

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
ACC
Frequent Visitor

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

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

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
Impactful Individual
Impactful Individual

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
Sbedford
Regular Visitor

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (30,131)