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 Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,197)