How do I use color hex value in the column to set background color in the formatting?

lilyvalley-8419 240 Reputation points
2025-04-02T02:04:37.17+00:00

I need to color formatting a calendar of meeting events. Each meeting has a column with the color hex value.

How do I use color hex value in the column to set background color in the formatting?

Microsoft 365 and Office | SharePoint | Development
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 51,836 Reputation points Microsoft External Staff
    2025-04-02T08:08:11.2166667+00:00

    Per my research, it is not possible to format a calendar view with color hex codes.

    JSON formatting capabilities are very limited for calendar view. You can only add additional classes to events using additionalEventClass and additionalEventClass only supports the naming conventions: ms-[location]-[color].

    References:

    https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/view-calendar-formatting

    https://devblogs.microsoft.com/microsoft365dev/mvp-article-using-theme-colors-in-list-formatting/

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.