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. 

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
      • Charles Pritchard's avatar
        Charles Pritchard
        Copper Contributor
        Apr 08, 2019
        Hi, I can confirm that _ModerationStatus has broken rendering on all First Release and Standard Release tenancies. This is a breaking change for all of our users who use a modern view for approvals. Complete work stoppage for some; 3 - 4 weeks is out of the question for a fix.
        This would be fine if it was just JSON Column Formatting but is broken for default rendering now also.
  • nz_archer's avatar
    nz_archer
    Copper Contributor
    Apr 01, 2019

    escipion Thanks for the info, works great.

     

    I must say that it is very disappointing that this has been removed, it really was helpful when using large libraries.

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

    escipion  Works as advertised! Thanks!

    escipion wrote:

    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. 

     

  • Tanya Denton's avatar
    Tanya Denton
    Iron Contributor
    Apr 01, 2019

    escipion you absolute star!  Thank you so much for the solution. 

Resources