Great video! A tip for troubleshooting if this doesn't work right away for a viewer; make sure you are referencing the column's "internal name" which may not be the same as how you named it in your list view. I ran into this and it took me a bit to resolve it. You can find the internal name by: 1. Go to "All Items" view 2. Filter the column you want to color code (filter by any entry in the list, it doesn't matter) 3. Look in the web URL link at the top of your window and look for "FilterField1=xxxxxxx". Your internal name will be shown instead of the x's and keep in mind that it IS case sensitive. 4. Use this internal name instead of your column name when you're switching out the Title field in your calendar conditional formatting JSON section.
THANK YOU, Shawn, for posting this! I thought I was going crazy trying this a few times with no color coding changing, the internal column name was different because I started from a list template. It works now, thank you again! :)
I tried to do this, but it still not works for me. I checked even the columns internal names with microsoft graph. Funny it is working for 2 columsn (Title and a Choice Column) and not for any other column, doesnt matter if choice or string.
Thanks April :) this was mega helpful. Accidentally, I also found another user friendly work around formatting. If you go List settings from the site cog in top right > then select the view you want to edit > you can then add fields to show. When you add these (technology say) you can then filter on them directly and means you don't have to edit the JSON. Thanks again
A better and simpler solution is to go into the list settings, edit the calendar view (bottom of the list settings page), enable the display option for the field you want to use, and save. Now when you add a condition the field will appear in the dropdown without the need to play with JSON code.
I learned more about MS Lists doing it both ways, but the JSON edit way does not show the color coding every time we view the calendar. We have to tap between views to get it to show as designed. When I did it through the List settings, it works every time we look at the calendar view. Thanks to both of you for taking time to share your knowledge!
Awesome! Another cool and handy tip there. Having moved away from SharePoint and focusing on the Power Platform in recent years, I haven't kept up with SP that much but good to pickup these tips every now and then. Yes, more of List formatting and handy SharePoint tips would be extremely welcomed.
@@EJA1969 take a look at Chris Kent's site & videos. He's a master of JSON formatting. Has a few videos about how you can reformat events cards, so might put you on the right track!
Thank you a lot for your video! However, it's 2024 now and apparently there is an option if you go to your calendar list (where All items and the Calendar view can be set) and at the bottom of the list there's an option called: Add or remove fields. If you select the field you want to color and click on apply on the top of the menu, you will find later in the formatting menu the option of the field you selected (as shows the video). All this without the workaround of the video. I found it out by chance and I decided to share it so it can be useful for others. @@AprilDunnam
Perfect!!! I really appreciate you sharing these to everyone. I do have one request, I was asked to show a column when that is not showing in the calendar box. How do i do that, example, a column called "room number" is in the SharePoint List but in the calendar view or in the Event List it only shows the start date, and the title.
Hi April, I tried the JSON cheat tips you provided. Loved this, however, my calendar didn't change colours? I've matched everything you've provided and it seemed like there's no differences. I use a different category name and used this to replace the "title" field. On preview and saving I just have the grey colour throughout. I've cancelled and retried with no luck. Any other workarounds you can suggest?
Brilliant! Many thanks, April. I also would love the ability to show multiple fields in the calendar view. While hopefully Microsoft will enable this functionality sooner or later, would you know a "workaround" until then, please?
Thank you a lot for your video! However, it's 2024 now and apparently there is an option if you go to your calendar list (where All items and the Calendar view can be set) and at the bottom of the list there's an option called: Add or remove fields. If you select the field you want to color and click on apply on the top of the menu, you will find later in the formatting menu the option of the field you selected (as shows the video). All this without the workaround of the video. I found it out by chance and I decided to share it so it can be useful for others.
Brilliant! I've watch tons of tutorial and yours standout by making a complex tasks easy. I created a leave request calendar and set the Calendar View - the only problem I have is that we can only choose one Filed yo use (example, Title or Technology Field) - It would be nice if the List in a Calendar View allows t wo or more Fields to Display.
If you add the field you want to reference to the view through the old Edit View interface (by clicking on the view name in List Settings) it becomes available as a choice in the simple conditional formatting, and you never need to edit the JSON!
Hi April, Great resource, thank you. One question I have is to add to visual formatting, is it possible for you to add additional information from the list to the events in the calendar view? In your example, the Technology column, would it be possible to add the words to the 'event card' on the right using JSON or other methods?
Thanks April. Any idea how to have this colour coding carry over to the List embedded as a tab in Teams? Colour coding disappears when the calendar is surfaced here.
At 5:40, instead of using the "Title" field to add the rules, you could have added the "Technology" column into the calendar view first. This would have added the "Technology" option when selecting the color codes. This way, there's no need to update JSON code directly.
Thank you for the helpful video. I have a problem showing the color code when using the list web part to show the calendar view. As soon as I publish the page, color codes disappear and revert back to the default color. Any suggestions?
Cool, it works, I just tried it out! But there is one flaw: When setting it as default view it doesn't show the colours. You need to first change view and then back to the calendar view to see the colours. But maybe something that can be fixed via JSON
Oooh that's an interesting quirk. I didn't try making it the default view. Good to know that the field with color coding info has to be there in the default view. I'll add that to my video description for clarification. Thanks for that!
wow thank you so much April! Sharepoint can be so good so why do they make it so difficult to use! maybe theyve tried to give as much functionality with a tight deploy date and are working on all these front end issues as we speak. getting into JSON shouldnt be normal practice for a team calendar! my colour coding didnt work even when switching views. I had to make a new view by Type of Time Off rather than the Title. make the colour coding , and then go back to edit view and change back to Title. Looks great now, but takes so much time fiddling and researching how to's. thanks!
Hi, thanks for your videos,. I have a question do you know or you have a video using app calendar? A need to change names, remove items from add new element in calendar. No a calendar from list, I need that from addig a new app calendar . Helpppp
Dear April, thank you so much for your terrific and inspiring video tutorials. Would you perhaps, please, know if and how we could change a condition to "field contains" vs. "==" which does not seem to work for me for a text field (choice does work)?
Can you add a filter to this calendar to only see Power Automate or Power Apps? I need to do something similar for my company but would like them to have the option to only view by "Specific Technology"
Is it possible to have multiple dates associated with a single item and have them each show as a single calendar entry rather than a range of dates on a calendar?
Hey I am really struggling, It works for 2 columns (Title and a choice column) but not all the others (string or choice columns). I checked for the internal names even with the microsoft graph. But still running into this issuse, dont know how to fix it. I have a normal SP List.
Strange, even though I set the colors for my Categories, one of the colors is different in both List and Calendar view, also how do you get a Legend on the side like the Classic Calendars had so you KNOW what you are doing???
@@AprilDunnam Hi April, is it possible to adjust lengths in calendar views? And what should I check (probably the formatting) if the coding that you give couldn’t works in our calendar? Thank you so much once again.
Close, but yet so far! Works great for something like this example where you use a text or choice field for the conditional formatting and a text or choice field to display on the calendar. Strangely, if you use a choice field for the conditional formatting and display a person field on the calendar the formatting doesn’t work. Using this to format a leave calendar requires you to copy the display name from the person field into a text field and use it to display. Also, the conditional formatting does not display when the calendar is on a Teams tab. Hopefully I am wrong and someone will correct me. Otherwise, the functionality will likely improve in future releases.
I tried this but I had to go into the classic list settings and add the columns that I substituted into the JSON to the list view. If I didn't do that, it would work when switching views but fail on a refresh (SharePoint online environment).
While this is great, the lack of recurring events on the modern calendar is reason enough to not use it, so I'm forced to use the classic calendar in my environment.
