SharePoint: Approval state field is showing numbers (0,1,2) iso Approved, Pending or Rejected

Barbara Blancquaert 21 Reputation points
2021-11-09T11:31:19.37+00:00

We are working with SharePoint online. The value of the approval status field is suddenly showing a NUMBER (0,1,2) instead of Pending, Approved and Rejected. Yesterday everything was still ok.
How can I fix this and what could be the reason it changed suddenly?

147775-image.png

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,407 questions
{count} votes

Accepted answer
  1. Echo Du_MSFT 17,101 Reputation points
    2021-11-10T06:35:42.47+00:00

    Hi @Barbara Blancquaert ,

    Welcome to Q&A Forum!

    Are you applying JSON formatting on Approval Status column?

    If yes, this is the reason column showing values differently because SharePoint saves approval status column values based on the SPModerationStatusType Enum.

    For example:

    147962-test.gif

    Thanks,
    Echo Du

    ===========================================

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Barbara Blancquaert 21 Reputation points
    2021-11-10T07:26:28.413+00:00

    Hi,

    Thanks for the answer.
    I saw that conditional formatting was turned on. I turned it off and it worked!

    We don't use JSON formatting on our columns.

    It is strange. We have 6 libraries, and the conditional formatting was suddenly turned on in all the libraries.
    Any idea how that might have happened?

    Kind Regards,
    Barbara

    0 comments No comments