Forum Discussion

Tanya Denton's avatar
Tanya Denton
Iron Contributor
Mar 27, 2019
Solved

Approval Status Column Formatting - gone!

I may be having a senior moment, but the column formatting on a document library with Approval Status switched on has disappeared. It was there the other day but looking at it now it looks like this ...
SharePoint Online
  • escipion's avatar
    escipion
    Apr 01, 2019

    Tanya Denton  . We faced the same issue the same day, it seems that Microsoft have removed  that option. I managed to remove JSON format by going to hidden field in this way:  https://sbseguros.sharepoint.com/sites/facturacion/_layouts/15/FldEdit.aspx?List=%7B84A2577F-043C-4821-B9DC-2B7F871A6EA6%7D&Field=_ModerationStatus

    You can go  to another field's settings  of the same list and replace that field  name for  "_ModerationStatus" in the url. 

nz_archer's avatar
nz_archer
Copper Contributor
Mar 29, 2019

Hi Tanya Denton 

 

I am having the exact same issue.

 

This was how my Approval Status column was before:

And this is how it is now:

This is very frustrating I hope it gets fixed soon

  • escipion's avatar
    escipion
    Copper Contributor
    Apr 01, 2019

    Tanya Denton  . We faced the same issue the same day, it seems that Microsoft have removed  that option. I managed to remove JSON format by going to hidden field in this way:  https://sbseguros.sharepoint.com/sites/facturacion/_layouts/15/FldEdit.aspx?List=%7B84A2577F-043C-4821-B9DC-2B7F871A6EA6%7D&Field=_ModerationStatus

    You can go  to another field's settings  of the same list and replace that field  name for  "_ModerationStatus" in the url. 

    • Paprika_leja's avatar
      Paprika_leja
      Copper Contributor
      Apr 11, 2019
      escipionFormat in the column status Works great with you suggestion. However, the option export to Excel is not available now. It was an error when we try to get Excel sheet. It is not possible  get conection with SharePoint list. Do you know something about that?
    • Maggan Wåhlin's avatar
      Maggan Wåhlin
      Iron Contributor
      Apr 04, 2019

      escipion Awesome, thank you! Looks better now even though the col is empty... Hoping MSFT releases a fix shortly.

    • AlanJG's avatar
      AlanJG
      Copper Contributor
      Apr 03, 2019
      What a rockstar! Thanks!
      • Madhuko_MSFT's avatar
        Madhuko_MSFT
        Icon for Microsoft rankMicrosoft
        Apr 03, 2019
        Thanks all your feedback. We are going to bring back this feature very soon. Hoping it should be available ~3 to 4 weeks time however we don't have exact ETA
  • dennis78's avatar
    dennis78
    Copper Contributor
    Mar 29, 2019

    Tanya Denton Same here. Format column is gone, and just in the Approval Status column. Other columns format fine. Logging a support case.

Resources