Forum Discussion

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

Tanya Denton

Iron Contributor

Mar 27, 2019

@Norman thanks for such a quick reply. My problem is the JSON has gone (if it was there in the first place) in the Format VIEW, and there is no option on the Approval Status column to add a column format. This is why i am confused!

Norman Young

MVP

Mar 27, 2019

My custom JSON is working and so are my "Format Status column" settings.

Did the choice values happen to change?

Is there any JSON code listed in the list settings > edit column?

Tanya Denton
Iron Contributor
Mar 27, 2019
We have the OOTB Approvals switched on so the [Approval Stauts] column is provisioned automatically. I have just created a brand new view and it still shows the below so this tells me i must have used Column formatting and not View formatting (I think!)

The options I have for that column are

I have just used the browser developer tools and that shows I used .sp-field-customFormatter
- Norman Young
  MVP
  Mar 27, 2019
  I follow now. You are using the "Content Approval" feature.
  I don't see the OOTB format column feature, so you must have formatted via the view. I will try to reproduce.
  - Norman Young
    MVP
    Mar 28, 2019
    Can you send me a screen shot of your document library settings? Specifically the columns. I can't see how you are formatting the view with the Approval Status column when it doesn't show as a column.