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.
Solved! Go to Solution.
@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
@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:
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.
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.
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
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 ";"
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.
Is this working -
Text property of label -
Left(Concat(ThisItem.FullName, DisplayName & " and "), Len(Concat(ThisItem.FullName, DisplayName & " and ")) - 4)
@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
User | Count |
---|---|
121 | |
88 | |
88 | |
75 | |
66 |
User | Count |
---|---|
215 | |
180 | |
138 | |
96 | |
82 |