Forum Discussion

PN3456789's avatar
PN3456789
Copper Contributor
Dec 13, 2021

SharePoint column data not showing up. What is happening?

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? 

 

  • tvoybatya's avatar
    tvoybatya
    Copper Contributor

    Had issue with missing 2 columns. Tried everything in this thread — did not help.
    Checked if issue appeared by data input from form connected to list or directly from list — issue was the same. Clearing cache/cookies helped only until page refresh was made. 

    Solution which helped — changed column type from single to multiple lines of text

  • kellymb's avatar
    kellymb
    Copper Contributor

    PN3456789 I had the same issue, I clicked on '+ Add new item', clicked on the area shown in the red "circle" on my attached image, chose 'Edit columns' and say that the missing field was unticked. I just ticked the field and saved, and it appeared in all my views. Hope this helps.

  • BarryGoblon's avatar
    BarryGoblon
    Iron Contributor

    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.

  • Daryl1396's avatar
    Daryl1396
    Copper Contributor
    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
    • nancmadi's avatar
      nancmadi
      Copper Contributor
      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!!!
  • knot_that_smart's avatar
    knot_that_smart
    Copper Contributor

    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.

     

    • IT_Manager-GZA's avatar
      IT_Manager-GZA
      Copper Contributor

      I was having this issue also and came across the answer that knot_that_smart gave. However, I did not have two fields with the same name. What ended up working for me was to hide the column and then un-hiding the column. After that, everything came back.

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

      2)  Untick the current issue field.

      3)  Click "Apply"

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

      5)  Tick the current issue field.

      6)  Click "Apply"

       

      After that, everything came back. It did appear all the way over to the right, but I just dragged it back to the correct position.

       

      • Andre_Oliveira's avatar
        Andre_Oliveira
        Copper Contributor

        IT_Manager-GZA I tried all the solutions proposed above, but the text in the title column is still not showing. I can only see what's in it after clicking in the individual entry. This started today. Yesterday everything was ok.

  • 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.

      • ganeshsanap's avatar
        ganeshsanap
        MVP

        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.

Resources