cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tsebold
New Member

Issue with Sharepoint list and Browser Screen in PowerApps

I have created a Sharepoint list and then had PowerApps create an app for it.  The list has both text and people fields in it. When I look at the browser screen, the app will not display the people field.  It is only pulling the text fields.  I am using the gallery with Title, subtitle and body.  I want the people field to show up in the body.  

1 ACCEPTED SOLUTION

Accepted Solutions

@tsebold - @NandiniBhagya20 has probably touched on the issue. I assumed this wasn't a multi select column as you had a field called DOB which would just be for one person.

 

Though it may be that your SPO List Person field has 'Allow multiple selections' enabled and it potentially shouldn't be enabled?

 

If so, just go in and change the settings, refresh your datasource in the app and then ThisItem.FullName.DisplayName should work.

 

If the multiselect was intentional, @NandiniBhagya20 has you covered with dealing with that nested table of people.

 

Hope this helps

 

 

View solution in original post

9 REPLIES 9
AmDev
Super User
Super User

@tsebold - When in edit mode in your app, select the top (template) row of the Gallery and select the bottom label in that row, which should be the Body label.

 

Then in the formula bar at the top, if you look to the top left, it should be defaulted to the 'Default' property. If it isn't, change the property to 'Default'. Then replace the current formula with the following:

 

ThisItem.YourPersonFieldName.DisplayName

 

Change the red text to match your person field

 

This should then show the name of each person from your data set in this field

 

Hope this helps

@AmDev  I don't see where to change it to default.  Sorry, this is the first app that I am trying to build.  Here is what I see:

tsebold_0-1658415101130.png

The people field is fullname.  Thanks

 

Sorry @tsebold - I was refering to a text input control.

 

Though for a label, which is what is shown on your screen, it's the text property shown at the top of the screen in the screen shot.

 

AmDev_0-1658415646277.png

Just change that from ThisItem.DOB to ThisItem.YourPersonFieldName.DisplayName

 

Change the red text to match your person field

Still no luck.  The error says that it looking for a text field.

tsebold_0-1658416655461.png

Somethings are not playing nice.

@tsebold - I'm assuming 'FullName' is the name of the column in your SharePoint List that you are trying to display?

 

Also, is FullName a 'Person' type field in Sharepoint? - If FullName is the name of your field and it's a person type field in SharePoint, what you have written in the formula bar should work.

 

However, if FullName is a single line of text field in SharePoint, which happens to display people's names, your syntax should just change to:

 

ThisItem.FullName

 

Hope this helps

NandiniBhagya20
Solution Sage
Solution Sage

Are you having a multi select people picker in your list ?
If yes, then use the below formula - Left(Concat(ThisItem.FullName, DisplayName & " and "), Len(Concat(ThisItem.FullName, DisplayName & " and ")) - 4)
You can use any other separator instead of "and" like "," or ";"


Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Yes, fullname is the name of the column in the Sharepoint list and it is a person type field.  I have never been able to get this column to show up in the browser screen.  When I have PowerApp create this 3 screen app, it has allows skipped over this column and picked the next text field.

NandiniBhagya20
Solution Sage
Solution Sage

Is this working - 
Text property of label -

Left(Concat(ThisItem.FullName, DisplayName & " and "), Len(Concat(ThisItem.FullName, DisplayName & " and ")) - 4)


Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

@tsebold - @NandiniBhagya20 has probably touched on the issue. I assumed this wasn't a multi select column as you had a field called DOB which would just be for one person.

 

Though it may be that your SPO List Person field has 'Allow multiple selections' enabled and it potentially shouldn't be enabled?

 

If so, just go in and change the settings, refresh your datasource in the app and then ThisItem.FullName.DisplayName should work.

 

If the multiselect was intentional, @NandiniBhagya20 has you covered with dealing with that nested table of people.

 

Hope this helps

 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,874)