question

BarbaraBlancquaert-5087 avatar image
0 Votes"
BarbaraBlancquaert-5087 asked BarbaraBlancquaert-5087 answered

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


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


office-sharepoint-online
image.png (76.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @barbarablancquaert-5087 ,

This is a quick note to let you know that we are performing research on this issue.

Thanks,
Echo Du

0 Votes 0 ·
EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered

Hi @barbarablancquaert-5087 ,

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.




test.gif (583.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BarbaraBlancquaert-5087 avatar image
0 Votes"
BarbaraBlancquaert-5087 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.