Sharepoint Column not displaying correctly

Question

I have a sharepoint list that is connected to my corporate directory. Several of the columns in the list are "person" type columns. When entering data for a row, the directory works perfectly, but when the row is saved, the columns for all "person" column types displays [object object] instead of the person names.

I also have a connected Power app, which displays the data correctly, it is just the data in the list that displays the weird [object object] text.

Oddly enough, the created by and modified by columns display the user's name correctly, but all fields where a name is manual entered display the [object object] text.

The settings I have are in the screenshots provided. I would like the columns to display the selected person's name and not [object object].

Column settings

screen shot of the column's displaying the data incorrectly.

Answer 1

Hi Informatics RN,

First, my pleasure to assist you.

As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

It seems the column that has a "Person / Group " is showing as [object Object] and not the name of the Person.

I just tested from my side, and it seem I have no issue Person / Group coulmn. Here is my test image for your reference:

I believe, the Person/Group column appears as an object because if it has multiple fields: for example, city, state, first name, last name, etc. The data can, only show one field in each of the fields you select though.

As you mentioned, “I also have a connected Power app, which displays the data correctly, it is just the data in the list that displays the weird [object object] text” if issue only happened in SharePoint list, this is because person filed is treated as a lookup.

You may click on your problematic column>Column setting>Format this column and check JSON code to formating and there is a field called "txtContent", which can be given the value "@currentField". You may need to change “txtContent” field to” Person.title”

For example: “txtContent": "[$Person.title]"

I appreciate your understanding and stay safe!!

Best regards

Waqas Muhammad

Answer 2

Hi Informatics RN,

May I know if you have seen my reply? May I know if you still need help? If so, you can post back and we will also try our best to help you.

Best regards

Waqas Muhammad