SharePoint column data not showing up. What is happening?

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.