I just completed an update to this video...addressing the most commonly asked questions. Also, some new features that were released since this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-E4Kp_JOp-eY.html
Hey there! Thanks for watching the video and letting me know about the update. I appreciate your feedback. If you have any specific questions or need more details about the new features, feel free to ask, and I'll do my best to answer them. Take care!
Hi do you know how to address the issue of seeing input on the week view but does not appear on the month view . Really stressing me out . Best regards
In case someone still looking for a way to make conditional coloring based on column name: In Teams -> ... -> Open in Sharepoint -> click on calendar name on the upper right -> Format Current View -> Conditional Formatting - Manage Rules -> Add Rule with condition, e.g. if column X = "Y" then define color. If you don't see all the columns then click on calendar name again and Add or Remove fields. Now in Teams when creating items it will auto-update colors (sometimes it takes a bit of manual refresh is needed).
Great content Deshon. I have created the Calendar exactly as you have demonstrated, but consecutive dates only show as 1. ex. In traing from 10/10 - 10/13 (3days) only displays on Calandar view as 1 day on 10/10. Is there a version issue or did I miss a step. Thanks
@@eamyrfrost1596 I had to create the calendar under my list, then use that as the template to add to an existing team. It seems that if you create the calendar under the existing team it only displays 1 day instead of the traditional multiple days type calendar.
ok, ok, I figured it out...actually someone on LinkedIN help me solve this. The issue is, in the video I am configuring the list using MS Teams in the browser. Using MS Teams desktop app, has an issue with the date range. Try launching MS Teams in the browser and then walk thru the configuration....let me know
Thanks for the great video. Is there a way to include a Time column separate from the date column when building a calendar? I've tried doing to the Date/Time in the same column but when I try to enter a date/time, it will not show in the calendar
great question, not sure if this is possible using datetime. You can use a standard 'single line text' column for the time only, and then use the calculated field trick shown here to show the time with the title of the entry ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nzsUOy6r73U.html
Thank you so much for your excellent guide. One question, are we able to colour code different categories so that it is showing different colour for different categories?
Yes! that feature is finally here. Check out the formatting rules once in calendar view. It may be a little tricky, but definitely doable....I'll shoot a video on some strategies.
This worked flawlessly, thank you alot! For future enhancements......Is there a way to make the calendar chang ecolor based on the type of entry? Like Vacation in one color, Sickleave in another color and soforth?
Hey there, I'm glad to hear that the team calendar setup worked well for you! As for changing the color of the calendar based on the type of entry, unfortunately, in the current version of Microsoft Teams, there isn't a built-in feature to do that. However, you may be able to achieve this by using some customization options available in SharePoint, such as conditional formatting or custom views. I would recommend exploring those options in SharePoint to see if they can help you achieve the color-coding you're looking for. Let me know if you have any more questions!
In Teams -> ... -> Open in Sharepoint -> click on calendar name on the upper right -> Format Current View -> Conditional Formatting - Manage Rules -> Add Rule with condition, e.g. if column X = "Y" then define color. If you don't see all the columns then click on calendar name again and Add or Remove fields. Now in Teams when creating items it will auto-update colors (sometimes it takes a bit of manual refresh is needed).
Thanks for watching...this was a common ask. So far you can't with this modern calendar, but you can with the classic calendar in the Events list.ill shoot a video showing how if needed.
This sounds like a job for power Automate...I love Power Automate for this...as the "connection" account only needs access to the list. Hope this sparks some ideas...let me know if we need a video on this.
@@DeShonClark are you saying use a list with a calendar view instead of the 365 outlook group calendar? I don't follow how anyone in the org could sync. It to to their outlook, if so.
Hello Deshon, thanks for sharing your knowledge! I was wondering is there a way to present the items on the calendar view with colors (for each category) as it’s showed on “All items” view ? Thanks
Hey Freddy, thanks for watching....I really do appreciate it. So far I have not found a way to format the calendar entries. I am sure this is coming, like you stated, Microsoft has this ability for the other views. I'm sure it is coming soon.
This is awesome. Thank you good sir! The only thing I'm trying to figure out is the color of the events within the teams calendar. Will play with it, and while it's usable now, I'd like to see some color :)
thanks for watching, this calendar solution does not yet support re-occurring events...hoping this will come soon. Check out the calendar view in the Events list...this does support re-occurring and integration with Outlook
oh! this is a fun idea. So let's break this down, because this is an interesting point. At the end of the day, this is just a SharePoint list displaying data in a calendar format. So....you can leverage any tech related or centered around SharePoint list data as in Power Apps, Power Automate, List Rules, Microsoft List mobile app, etc... In the scenario of a 9am alert of all of the PTOs for that day, that my friend, would be a Power Automate scheduled job. Absolutely doable. And I love the innovative thoughts....your idea is what make these techs super powerful
Hi DeShon, I'm not exactly sure how old this post is but I'm new to your channel and found this video to be very helpful. I do have a question though... originally, I was going to add a "Channel Calendar"; however, that was adding the OOO time as a meeting which included the meeting dial-in info etc and that's not what I wanted for that entry. I specifically wanted to enter someone's OOO time. My question is, once I create this new "group" calendar I believe it's called and I add an entry for someone's OOO. Could I also in this calendar add a "meeting" entry that would include the meeting dial-in info as it did in the Channel Calendar??? hope this makes sense.
thanks for watching. The calendar game is confusing. Channel Calendars, will only add MS Teams Meetings...they cannot be used otherwise. This "group" calendar is for group calendar entries only, and do NOT integrate with Outlook calendar nor the MS Teams calendar. It is really just to tracking items in a calendar view independent of Outlook and MS Teams...on the other hand, the Events list (in SharePoint) has a classic calendar view, and this one CAN be integrated with Outlook following these steps: sharepointmaven.com/sync-sharepoint-with-outlook/ but it will not have MS Teams meeting info...hope this helps
@@DeShonClark Hi DeShon! I, too, had this question. Can you please talk a little more about the calendar view for Events to integrate with Outlook? I LOVE your video and already created that Team calendar very easily, just wish it syncs with the Outlook calendar instead of manually creating it again.
This was super helpful for my staff. The only issue I'm running into is that we can only view items per month. I can see June inputs but I cannot see those that inputted time off in July and so forth. Any way to fix this? Thank you!!
thanks for watching Megan. Yes, you should be able to navigate to previous or future months. I am able to demo this in the video here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nzsUOy6r73U.html Not sure how it may be different on your side...is the month drop-down not showing?
@@DeShonClark The drop down months are showing. I can see on the listing that they are inputting time off for July, etc., but when I go to the calendar display mode, those dates aren't showing up. I can only see June's inputs on the calendar display as of right now.
@@DeShonClarkGreat video! I'm running with the same issue and there is no way to see the month drop-down. Is there any way to see it? Thanks again for your help!
@@DeShonClark Hi Deshon, Thanks so much for the video. I have just created a TEAM calendar for my own team. I have the same question regarding holidays and re-occurring events too. Thanks again for sharing.
Excellent content! Is possible to change the first day of the week in the lists calendar? Monday instead on Sunday for example? I tried and is not related to the regional configuration in the PC or O635 account.
I have not tried this. this will really just a calendar format for list data, so it will be missing a lot of the cool features we expect. Have you tried the calendar view on a Events list...it is the classic one, but have more calendar features
Hello DEshon, Thank you for this excellent presentation. I was hoping to see if there is a way to make some of the event's reoccurring. let's assume there is a training that happens every month and one needs to make it reoccur as against adding it every month manually. thank you in advance.
Great solution, thanks. I am trying to do something similar but with existing information from the staff calendars in Outlook. However, this is much better than what I've tried. The idea is to have a view that is generated from existing information and not having another solution to think about. Have you thought about something like that?
I think the two are solutions are different, a true calendar that integrates with outlook (i.e. external calendar that overlays) will be different than showing SP list data in a calendar view. For the latter, I would still use the Events list, as it uses the classic SharePoint calendar that can be integrated within SharePoint
@@DeShonClark This video is SO EXTREMELY helpful! What exactly is a "group" calendar? I thought this tutorial WAS how to create "group" calendar. I'm confused, could you elaborate please?
Thank you for great knowledge sharing. I have one question, if there are many event in 1 day, how can I show all event name in calendar view ? Currently, it shows only 1 event, for other events shown as "+ 2 more"
hi DeShon, thank you for this video. One question; is there a way to color the title on the calendar view? Example Madison would be Red and other team member Blue? Looking to provide some contrast on the calendar. Not a formula but maybe something I can add a Font Color when creating the calendar entry?
@@DeShonClarkif you use the MS Outlook calendar, or the Google calendar you can do this. But that's too easy for Microsoft to integrate. They have to make everything hard.
You're welcome! I'm glad you found the video helpful. Creating a team calendar in Microsoft Teams can definitely help your team stay organized and keep track of everyone's availability. Feel free to reach out if you have any more questions!
Thank you so much! I'm really glad that you found the video helpful. I hope your boss is impressed with your new knowledge! If you have any more questions or need further assistance, feel free to ask. Have a great day!
Thanks. Do guest accounts have access to the Calendar? Or, is it only for users within your organization? I ran into that problem and had to use the "website" app within Sharepoint and place that link from into Teams. P.S. I'm a newbie to Sharepoint.
Guest will be able to access this calendar as it is just a SharePoint list, that's part of the SharePoint site provisioned with the Microsoft teams. Just be careful with guest accounts as technically you only have five guest accounts for each license to account. But it is not strictly enforced, so not sure if this had anything to do with the issue you faced.
I was wondering if this can handle Calendar Overlays similar to Sharepoint. I saw you were using Categories but we are considering combining individual calendars into a combined calendar where only certain events with a certain "category" can be viewed. From your video, it looked like maybe this has a "View" function similar to Sharepoint. Thoughts?
Great video. One question regarding the date and times showing on the Calendar view. For some reason, time is showing on the calendar even though the times are turned off in begin date and end date. For example, when I make a OOO item, it will say "9PM" then the title category. It would be amazing if I could get any help to finish my calendar!
Hi DeShon, I have followed all of your steps exactly and for some reason whenever I put in a mult-day event it only shows it listed on the calendar on the day it begins. It doesn't show the lines crossing over multiple days for an event like yours does. I have no idea how to fix this! Thank you for your help!
with all of the comments on this same issue, I must have blew pass this step. Ensure your End date on calendar is set to the end date column...not the Begin Date column...check out this marker: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nzsUOy6r73U.html
I've looked into it briefly and did not see the option. All of the bits are there (aka list view formatting), just waiting for MS to enable it for the calendar view....coming soon (I hope)
Hi DeShon. Thanks so much for sharing. I ended up creating this for my group since my director wanted something like this for us to use. :) I do have a question - is there a way to set up recurring events? For example, I was asked to put in our team members birthdays so obviously we want those to occur annually. But I can't figure out how to set it up within the List Calendar. Any suggestions? Thx again!
Hello! I’ve got two questions, the first I noticed you set different colours for the different categories but when you went to calendar view they don’t reflect this. Is there a way for the different colours to display? Lastly, is there a way for my associates to add their dates, but not be able to view anyone else’s entries apart from their own?
Thanks for watching. The color piece is not yet supported for the modem calendar view. As far as only seeing only "your" entries, this is possible by setting item level security setting. Look at List Settings -> Advance -> item level security
Hello DeShon - this is great - thanks for sharing your knowledge! Besides OOO items, we'd want to add operational coverage / assignments for a shared inbox. Is there an option to add viewable instructions in the calendar? I noticed the Description field when you first created the calendar but not sure how to access that or if that's the best option. Thanks again!
this sounds like a very interesting requirement...can you provide more details. Will the operation coverage be an file attachment or a statement, like who to contact if there is an issue!?! I think each item in the day "square" links to the item detail, where you can add what is needed in the description field, as you mentioned.
Hi! Thanks for your content. I'd like to ask you something. I want to built an app in P. Apps, but I need sign a files. Do you know how I can do this it. Without premium connectors. This is possible? Thanks
Thanks for watching, signatures are kind of tricky. I use the pen control in power apps forefinger signing and then save its bytes as an image. That's the way to capture the image, but the challenge will be embedding that image on a document. I think this piece may require premium connector. I'm starting to learn not to shy away from premium connectors, there is a strategy with building your solution in a way to where you only need the premium license for a service account, and not ALL users using your app. I will try to shoot a video on this strategy.
at 12:54 I cant get my entry to show the full range of days being blocked out only books out the first day ( begin date ) how did you get it to show the range link that blocks it out from Begin to End date? Thanks
double check your end date field in the calendar view configuration, make sure the start and end options is NOT set to the same date field...this tripped me up at first as well
Hello! Is there a way to add recurring events? I'm trying to capture our teams working from home days since we are adopting a hybrid schedule, I've tried adjusting some settings with the sharepoint columns but can't figure it out-- Thank you!
Hi design, when I add this list calendar view in my teams I do not get the indicator bar showing the duration of the booking. How can I get that to appear?
thanks for watching. This is a common issue. Double check the "End Date" setting in the calendar view config, to ensure it is using you the column that has your end date...by default the Start and End configuration settings are the same column
This week l was trying to get an outlook calendar attached to a team into a tab. Got a video on that? I can't find the right url. I have been trying to add as a website tab. I want people to be able add events to personal calender, get notifications, getting Teams link, etc.
Great Video. Quick Question: I'm following the video to the t but I still can't get my rage of dates off to show in the calendar. It only shows the first day it begins. Is there a way to fix that?
hey Betty, I think it may be with the start and end date column config...here's a video on my thoughts: cooldemos-my.sharepoint.com/:v:/g/personal/clardo_o365_how/EUAfFDrqzeBGm5Trkg4ngrYBMbo73FM2Zx4OKJWwYCrVSg?e=xoIGRA
There's a different calendar solution if you want Outlook integration and standard meeting invite capabilities...use the "Events" list in the SharePoint site. I'll shoot a video on the same
Ciao DeShon, is there a limitation on what type of fields I can concatenate? I have a field type "Person or Group" and it doesnt show up as option in the "insert" section on calculated field. When I just enter it in the formular like the other fields, an error comes up. Do you know a work around. Create video btw. This works better for me than the actual calendar app
Yes, there are limitations with the supported column types for calculated fields...I found this article: spgeeks.devoworx.com/supported-fields-in-calculated-column-sharepoint/
Yes, you can add the group calendar in Microsoft Teams to your Outlook calendar. This will allow you to view the group calendar events as events in your Outlook calendar. To do this, you can sync the group calendar with your Outlook calendar. However, I will need to provide you with more specific instructions on how to do this. I will make a note to create a video or tutorial on syncing the group calendar with Outlook. Thank you for the suggestion!
Hello Frederick, this calendar type can NOT be connected to Outlook, but the Events List calendar type can be connected to Outlook. I will shoot a video this week explaining how
Hi! I'm having an issue adding categories to my organization's shared calendar, but no problem with adding them in my own calendar. Do you have a solution for this? It would be very helpful to set different colours for different meetings eg. Marketing - Yellow; BD - green
hi there...did you figure this out. The color coding and calendar overlay feature is only available for the classic calendars (Event List), the new modern calendar is lacking the color coding feature, calendar overlay feature, and the integration with Outlook capability...all of these features are only available in the classic calendar on the Events list
thanks for watching Byron, to delete a view, go into the "list settings" and at the very bottom of all the options will be the list of all the views, select the view you want to delete, and click the delete button....hope this helps
thanks for watching. You can set the hours...they just do not display. In the Date time field, when editing the column, look for the option to "include Time"
Thanks for watching...when you configured the calendar view, there's a section to specify which columns that calendar should use for start, end and title (more options). I suspect your start and end options are the same column
@@DeShonClark This worked for me too as I had the same question, deleted the view and started again set the options as you advised - Can't wait for MS to introduce Category Colours for Calendar View (Fingers Crossed!)
short answer is no, but there is an alternative and I posted the technique here for you...hope this helps cooldemos-my.sharepoint.com/:v:/g/personal/clardo_o365_how/EZ9Wt_CZ6v9Eu9UQTsuwCjEBag5M5fPfsYiS0qvGtNaZ8A?e=jRSpOq
Great work DeShon! Is there a way to combine a calendar with a pre determined number of days, so that when each person takes days off for vacation, these days will subtract from their yearly total. HRs definitely will benefit from such feature. Thanks for sharing your expertise
Thanks for watching, very cool requirement. Yes there is a way to capture this but it will take some calculations of total number of days taken and deduction of allotment. You will have to build this with Power App form to get the most control over the calculations and logic.
Great video. I have tried to use the ( ) but I keep getting an error. This is my formula that works =Title&" "&[Travel Type]&" "&[City, State - Event] but as soon as I try and put the Travel Type and the City, State - Event in () I get an error. Any suggestions?
Both the calendar bot and the calendar list have their own benefits, so it ultimately depends on your specific needs and preferences. The calendar bot is a chatbot that can provide information about upcoming events, schedule meetings, and send reminders. It can be a convenient option if you prefer interacting with a bot and want to have the ability to schedule and manage events directly within your chat platform. On the other hand, the calendar list is a feature within Microsoft Teams that allows you to create and manage a group calendar. It provides a visual representation of events and availability within a team, making it easier to schedule and coordinate activities. It can be particularly useful if you prefer a more traditional calendar view and want to have a centralized place to manage your team's schedule. Ultimately, you may want to consider the specific features and capabilities of each option and choose the one that aligns best with your team's needs and preferences.
if you can get a feed of the needed holidays...then use Power Automate to add them to this list...at the end of the day, it's just a SP list...so however you need to get the data into a SP list...
Thanks for your question! Yes, there is a way to exclude weekends from the calendar. Within the Microsoft Teams calendar view, you can click on the "Settings" option (usually represented by a gear icon) to customize your calendar preferences. From there, you can choose to hide or exclude weekends from the view, which will only show weekdays. Hope that helps! Let me know if you have any other questions.
