Forum Discussion

Copper Contributor

Oct 10, 2023

Solved

SharePoint library choice column formatting

I am trying to format a JSON for a Choice column that has been set to "choice pills". I am trying to change things like font color, background color, border etc. So far trying to do this but doesn't ...

File Upload in Sharepoint Online

json

JSON formatting

JSON View Formatting

ganeshsanap
Oct 10, 2023
JohnBloggs950

Use [$__INTERNAL__] instead of @currentField in conditions like:

=if([$__INTERNAL__] == 'Sales', '#ff0000', if([$__INTERNAL__] == 'Marketing', '#006aff', if([$__INTERNAL__] == 'Warehouse', '#b882d7','green')))

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

ganeshsanap

MVP

Oct 10, 2023

JohnBloggs950

What is the issue exactly? Where are you facing issue while applying color or background color?

You may need to change the classes like "sp-css-backgroundColor-BgCornflowerBlue" in JSON as well which might be overwriting your colors applied via color and background-color properties.

You can also use the classes given here instead of using hex colors if these classes suits your requirements: SharePoint Online CSS Classes

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

JohnBloggs950

Copper Contributor

Oct 10, 2023

I'm trying to apply custom background colors using the specific hex colors but it only defaults to the hex color "green" or "#DAF7A6" as per this json code. How can I override the classes to use my own hex colors for background color of choice pills? (In a SharePoint library column, not list)

ganeshsanap
MVP
Oct 10, 2023
JohnBloggs950

Use [$__INTERNAL__] instead of @currentField in conditions like:

=if([$__INTERNAL__] == 'Sales', '#ff0000', if([$__INTERNAL__] == 'Marketing', '#006aff', if([$__INTERNAL__] == 'Warehouse', '#b882d7','green')))

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.