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

Barbara Blancquaert 21 Reputation points

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?


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

Accepted answer
  1. Echo Du_MSFT 16,836 Reputation points

    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:


    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.

    No comments

1 additional answer

Sort by: Most helpful
  1. Barbara Blancquaert 21 Reputation points


    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,

    No comments