SharePoint column data not showing up. What is happening?

[PN3456789]

My Name column on SharePoint is not populating with the appropriate data fields. I can see the data when I click on an individual entry but I can't see the data in the column on SharePoint. I can also see it on gallery view but not on list view. 

Anyone know what's going on here? 

 

[#2]

@PN3456789,

1. What is the data type of Name column?
2. Is there any JSON formatting applied for this column in List view?

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

[#3]

@ganeshsanap
Thank you for replying.
1. It is a single line of text.
2. The JSON formatting is
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json"
}

[#4]

@PN3456789 This is the default reference to JSON formatting schema. This shouldn't be a problem in your case.

This is a strange issue. Never saw such type of issue in our SharePoint tenant. I will suggest you to open a support ticket with Microsoft, check: Get Online support 

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

[#5]

Hi @PN3456789,

Came across this issue myself, the following fixed it for me.

1)  Click on one of the heading and choose - "Column settings" then click on "Show/hide columns"

2)  Scroll through and look to see if you have two "Name" options.

3)  on the RHS window - Untick the currently ticked one "Name"

4)  Tick the "Name" which was unticked

5)  click "Apply"

Hopefully you already sorted this, and hopefully this helps others.

[#6]

Had the same issue, What solved it for me was to go to the Column that is not displaying values > Column Settings > Format this Column > erase the JSON code then save... worked like a charm. For me at the very least

[#7]

@Daryl1396 This just saved me!!! Thank you... there was some odd enduser data in the JSON code, maybe the enduser had the list open at the time I made format change... it was driving me nuts all weekend and our IT Dept was stumped too... I share your fix with them... it was a life saver thank you!!!

[#8]

@PN3456789 First, let's take a closer look at the column configuration. You mentioned that the column is a "Name" column with a single line of text data type. That's a common and standard column type, so the issue is likely not related to the column configuration itself.

However, the fact that you can see the data when clicking on individual entries, but not in the list view, suggests that there may be some formatting or display issues at play. The JSON formatting you described is a common way to customize the appearance of columns in SharePoint, but it's possible that there's something in the formatting that's causing the data to not display correctly in the list view. My recommendation would be to start by removing the JSON formatting entirely and see if that resolves the issue.

As suggested by one of the previous replies, you can do this by going to the column settings, clicking on "Format this column," and then simply deleting the JSON code and saving the changes. If removing the formatting doesn't work, you may need to dig a bit deeper. It's possible that there's an issue with the way the data is being retrieved or cached in the list view. In some cases, a simple refresh of the page or a full re-indexing of the list can help resolve these kinds of display issues.