Well that's another common problem fixed and off my list. Thanks Reza Next question I will get from customers will be formatting the events in the calendar to different colours and overlays like classic can handle but I guess we will have to wait for Microsoft to make that available or more options available for that. :) Brilliant work.
Thanks for the fabulous feedback. Calendar overlays, recurring events andmore features are missing in modern. Let's hope over time we get those features back.
Reza, we all don't like the old calendar and I have been waiting for an easy way to create modern calendar. You offered a great solution to change the old calendar to modern calendar. Thank you!
Reza, your content continues to help me every day in trying to use Microsoft's out-of-box functionality to achieve advanced outcomes. In my company, 'citizen developers' like myself are limited to what is available to us with our M365 suite and base SharePoint. This is probably the sixth or seventh video of yours that has immediately solved a problem for me. Thank you!
Fantastic video Reza. This helps a ton. I'd like to add a function that shows a view of conflicting events. When selecting or mousing over a date, can a view show events that one or more people are assigned, as well as any conflicts and what the specific conflict is between events (e.g. people on leave and not available to be assigned tasks, or tasks happening at the same time assigned to the same person and therefore showing a conflict of date availability)? Or, as a manager, I'd like to see what conflicts are occurring in the coming days/months for people, project event titles, and resources (i.e. personnel availability such as if people are on leave, or not enough qualified personnel, or other constraint requirements).
The calendar view is basic to start with. Using JSON formatting only provides info for current item. It cannot traverse items to provide conflict information.
Reza, this is exactly what I was looking for! Thank you so much. I'm more of a low code/no code person but I am trying to learn json. I really like what you have done with the header, and I was hoping you might have a sample of that code somewhere I could use to customize?
Video description has links to download the JSON samples. Link to my full playlist ruclips.net/p/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf Link to all my JSON samples github.com/rdorrani/SharePoint
Excellent, exactly what I needed... thank you. Need your advise, I added the attendees column in the Events list, however, it does not appear when adding a new event... need to change the JSON Body? & Header?
Not sure about new columns to be honest. It should show up in the form. I would recommend posting your query on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
@@RezaDorrani thanx for that clarification ... 👍. One more thing, how can I change the side panel to show events for that month, instead of the events for the day... thanx for ur help.
great video, very informative on my current calendar issue, is there json formatting for adding a resource checker? Or what happens when there are overlapping times choosen??
The sectioning is really helpful! Thanks! I just have problems with the Header: whatever I do and adjust to my columns, I can't bring it to show up like in your video. Will probs need to build it step by step to find my bug. But it's already impressive!
Awesome video again! Thank you. With Json, is it possible to add a "Button" in the event view pane or calendar view to start a workflow? (something similar you did in approval flows)
Thank you for this helpful tutorial. I'm looking to add some json to the form that specifies a hyperlink to create an appointment on the users Outlook Calendar (iCal).
I will have to try that out to provide any guidance. I would recommend you check on the forums in case some has done something similar at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Anoher great learning resource from one of the best! Thanks again Sir Reza. BTW I just notice that there is new Calendar Webpart available, but still yours can be customized, looking forward for your next videos :D
Thanks. No plans for PAD since it currently is an ever changing landscape. Every month there are new actions with new features. I had done a full series on UI flows last year that was well received. But it has all become obsolete now because of WinAuto and now PAD and probably more coming.
Thanks for the video. Question for header you have in json display": "=if([$Application] if my field is Application Name do I change it to ApplicationName together?
Use internal name - from what I can recollect. I have a playlist on SharePoint formatting on my channel. I do show how to get the column name in one of the videos.
@@RezaDorrani If I create a new calendar view and setup conditional formatting on Category, it doesn't get applied. All items in the calendar end up with the theme colors.
@@RezaDorrani Thanks Reza! Yes, that's what I usually do in lists, but using a Calendar view this seems impossible, it doesnt allow editing the view like any other view. That a shame...Thank you anyway!
@@giuliapanico2771 You may be able to do it in the List Settings -> View - choose the calendar view name . This takes you to Edit Settings -> Filter - maybe try filter column name by looged in user?
Hi Reza! Thank you for your videos, they are just great! I have a question, maybe you can help. Is there a way to change de view for the calendar once on the page? For example allow the user to see only one week or one day. Thanks again!
@@RezaDorrani Thank you for your reply. The problem is that to create the view in week or day mode I have to do it with the classic experience. I don't know how to do it in modern experience. There is no option to change it. 😞
@@jaimesoares5574 There have been some announcements at ignite related to calendar views. Check or post your query on the SharePoint community forums techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Thanks for sharing. Any improvements to Calendar overlays formatting? They have standard boring colours... is it possible format calendar overlays with JSON
Thank you so much! You saved my day!!!!!!!!! Big thanks!!!!! Just one question, is it possible to have "Add to my calander" function on the morden event calander? If not, can we insert a meeting link for users to download a .ics file in the event list?
a lot of meat today. thanks for the video. Sharepoint is again enhanced and will be receiving workflow updates soon. i wonder if microsoft is moving to change its office and power platform offers.
Thanks Marcelo. As for your question on full width on modern page, the embed web part cannot be added in that section. However, using SPFx we can build a full width web part that directly links to that view.
This is great. I am trying to retain the " + Add to calendar" feature that is in the classic event format but is not in a modern list. Is there a way to have that feature remain when using the modern format? So by opening the detail form that feature would be listed to download the ics file?
As always, great stuff. Thanks for sharing. Is there a way to format the fields in the sections as well. let's say i have a multiline text field and want it to span across two columns. Is there any way to do this at the moment?
Hi Reza, So many thanks for all your videos. Really makes this more accessible to low/no-code people like me. I'm using the Europe date string (so day/month/year) and it gives me the month back in the nice agenda lay-out. Although in the formula it is getmonth. Regards, Wolter
Interestingly, I’m trying to get this to work using Australian date formatting (our region settings are for en-Australia, and I’m seeing “invalid date” and NaN in the mini calendar. I’ve tried to correct using the ‘en-GB’ modifier of the toLocaleDateString() function, but that hasn’t worked. When I changed my region settings to US, it works fine, but we’re not used to working with dates in ‘mm/dd/yyyy’ format and would much prefer a solution that doesn’t involve changing our SharePoint site’s region setting. Anyone have any suggestions to make this JSON work for ‘dd/mm/yyyy’ formatted dates?
@@carrotte I haven't yet. For now, I've reverted to the classic calendar as other projects have become higher priority. I'll come back to this eventually and hopefully find a solution.
Great video! Do you know how to make the colour of an event conditional on the category in the new experience? Similar to calendar overlays in the classic experience is what I'm looking for.
Hello Reza! Another amazing video. I have a question.It didnt recognised the dates because my site settings were English(UK). How can I modify the json to make it work for English (uk)?
Ahhh! Not sure about that one. Might even be a bug. I will recommend checking on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint in case someone has done something similar.
Great video - really useful. Is there a way to customise the events with custom colour based on category selected on the event. Similar to overlay in previous SharePoint calendar view.
No options to customize the calendar view are available as of now. As far as the form formatting, the calendar header colors can be changed based on the category selected.
I liked the trick of taking a classic calendar list, which is compatible with Outlook, and adding the modern calendar view to either supplement or replace the classic calendar view. However, I don't think it works in Teams using the Lists app. This is a similar behavior when trying to add a classic list to a modern page. So, I recommend just starting with a modern experience list from scratch so that you can put this nice JSON prettified view on your page and have it show up in Teams with hassling users about access issues.
This looks great, however I had a couple of issues when I tried and I'm not sure if I missed something. 1) First issue was the dates were not recognised because my site settings were English(Australia). I changed to English (US) and it resolved the issue, but is there a way to modify the json to make it work for English (Australia)? 2) second issue is if you double click on a calendar entry in the view, the browser navigates to about:blank and downloads a 000 File (.000). Is there a way to fix this so that it launches the information pane?
Hello Reza. Thanks for this video, it's super useful. Is it possible to wrap text in calendar, so I can see all event name without pointing with cursor? Thank you!
There is no speicific Power Auotmate certification. But there are Power Platform certifications that include Power Automate. Here is the list: PL-900,PL-100,PL-200,PL-400 and soon to come PL-600.
Thanks a million , can you please advise when I format Body the list field is not taking the full size of the section (each section has 3) only last has only one which is multi line text .How can I change this? I formated column and still the same and in the default view I have 2 hidden fields do you think this affect width of last item in the section?
Excellent Reza..😊 Here I have one question to ask you if you see for Single day Events, Multi-Day Events and Recursive Events only single item is getting created in the Event List. When I tried to populate these Events in Gallery of PowerApps I can't able to filter the Multi-Day events if I select in-between days of Multi-Day event. Here I had used StartDate and EndDate DatePicker control to filter the Events Gallery. Need your inputs on this.
Modern calendar does not support recurring events. Even multi-day events have a bug currently. You would have to use the classic calendar as the modern one does not support these.
@@RezaDorrani .. Thanks for your prompt reply and taking time to look into the issue. 😊 You have saved lot of my time. You are a marvelous person and a great guide.
and for my dates I have the field name setup as Release Date and Time where in the json do i change that and should it all be together? For the header section. Many thanks!
@@RezaDorrani I figured it out. The JSON to include is: { "elmType": "img", "attributes": { "src": "='/_layouts/15/userphoto.aspx?size=S&accountname=' + [$Presenter.email]", "alt": "Presenter
Hi Reza! Great video! I would like to make the Blue Banner in your video an image from my item's column "Banner URL", how should i replace a part of your code to do this task? Any help is appreciated!
@@RezaDorrani I read over the documentation but still can't seem to get it. So far I have the Image inside of the blue box you created next to the Title but I would like the entire blue box to be the image. Is this possible?
Hi Reza, thanks for your great videos. I'm now doing timesheet on SharePoint and PowerApps and I would like to make selected month from dropdown then date auto detected. Could you advise?
@@RezaDorrani I use data source from sharepoint list and use powerapps to design form i would like to make drop-down list with month once selected month then show day of month
Great work man, I have a question though, when I select any day to add a new event, it opens the form empty How can I make the start date entered automaticlly?
Reza, excelente trabalho. Se eu quiser trocar os campos de texto para campos de escolha, eu tenho que mudar seu Json de cabeçalho? É possível não deixar salvar o evento se a data tiver no passado? Muito obrigado.
To change text to choice field, you would need to create a new column. To not let event save in past, you would need to look at validation settings in list.
@@RezaDorrani Reza, se eu trocar o campo para escolha, eu devo ajustar o Json de cabeçalho, correto? Tem um documento para compartilhar que me informe como ajustar o Json para esses novos campos? Muito obrigado.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani - Obrigado pelo feedback. Acredito que conseguiremos fazer essas regras dentro do Power Automate com histórico de alteração de colunas no SharePoint. Abraços.
Hi Reza, Thanks for the great video. I have two issues Title column is saving it as a number Recurrence and All day Events are not displaying on the form. Is their any way to add them
It's a useful video @reza dorrani. I have a query......in my sharepoint site we are using dd/mm/yyyy format.....but your code output showing in MM/DD/YYYY format. the calender preview is showing in NAN Error. Can u please suggest where we have to change the code?
I will have to look at your list / site settings and JSON code to provide any guidance. Check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Superb - though how do I change the data format - our site is set as dd/mm/yy. So when I add an event using yoru JSON for 6 feb 2024 - it shows 2 June 2024
So I am using the MS Issues Tracker template, I have modified it for my use but noticed that the "Days Old" column doesn't update automatically, is there a way to achieve this using a formula or JSON?
When I click on a day in the calender view, (let's say monday next week for example) and add a new event, how can I set the start date to this day instead of the current day?
When you select a day, the Start Time does show up as the date selected. Its the end time that shows todays date. This is the default behavior of the calendar and cannot be customized using JSON formatting.
Many thanks, Reza! At 11:15, you embedded the calendar into a page using an . No problem. You also have a lot of unused whitespace on either side of the calendar. How can you embed a calendar view into the full width of a page? When creating a new section in a page, we can select "full width section", which is fine. However, the only options we have there are "Image", "Hero" and "Countdown Timer"(?). In the "Hero" option, if we change it to show only one tile, and open a calendar page or the calendar list, all that is shown is an image and link to open a different calendar page or calendar list. We cannot use SPFx and cannot create new web parts to make the calendar full width. Any ideas? 🤷♂
@@RezaDorrani Yeah... thought so. 🙁 Thank you for responding. I was hoping there was a way to add a calendar just with "out of the box" features. Perhaps, I won't embed the calendar in a page but just open the calendar view in the menu. We shall see...
@@RezaDorrani For the project I'm doing, I can only use "out of the box" options, so no SPFx. I also read that a tenant admin can create a custom web part, with a few JSON changes, to allow lists or libraries to show in a full width. For now, I'll just open the list in calendar view from the top menu. I was going to use different colors for different list items, but I will remove them since I cannot add a legend to explain the colors to users. Oh, well...
Hello Reza, I get the modern view when I select all list view, but when I select +New to create a new task, I do not get the single event pane on the right, I get the old add event window? Could this be an entitlement issue?
Hi Reza, the given changes doesn't trigger in Edit form. I have to update my fields > save it > reOpen item > now it reflects but it doesn't update anything in header formatting if I change the dates. On other side, it work like charm in New form. Any idea where it might go wrong?
Is there a reason you can not add in the "Add Day" radial button? Tried a few different ways to include in the JSON script but was not successful. Thanks!
Hello Reza, thank you so much for your excellent video. However, I cannot change the Date format from US to Germany, eventhough I changed the regional seetings in German.
Not sure about the date format. I had another user report the same. I will recommend you check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Hi Reza, I have a customised SP Form. When I open the form in new or edit mode, it shows "Apply Label" field automatically, which is really annoying. Can you please advise, how I can hide that field in my form
Thanks Reza, this is exactly what I have been trying to set up. But I am having an issue. When I go to List Setting --> Advanced Settings and click on New Experience and then go back to All Items view. I still have the classic view. I cannot figure why. Any tips?
@@RezaDorrani Thank you . I got it working but a different way. I think we are using the latest version of Sharepoint and I went to the 3 dots to the right of the Events in All Site Contents and clicked on Details, then I installed the calendar app. From there I was able to get the list to be the modern view, add the JSON code and it seems to be working. BUT... I cannot figure out how to get an event to be recurring. A recurring option doesn't show up in the body of the JSON code and the recurrence column does show up in the All Items list view but it is read only. How can I get that to be editable?
Everything seems to work pretty well despite Microsoft's slowness. however the dates, location etc. do not show up on the header only the title? Is there something simple i am missing?
I will have to look at your JSON formatting & list columns (internal names and types) in action to provide guidance. I would recommend posting your query on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Here is the full schema definition - developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json I have not tried this but with some of the functions available, this could be possible.
Hey, how can I get the Time and Date from a column thats a date and time column. I tried: "elmType": "span", "txtContent": "=toLocaleString([$StartDate]) + ' - ' + toLocaleString([$EndDate])" even if I used currentField, nothing get displayed. So I have a normal List with two date/time columns. I dont have an event list. Thank you
@@RezaDorrani , I figure out now. But I have now a different problem. I am struggling with changing the Columns. If I change it to my Title Column and a second one the color formatting is working. If I apply it to any other column the formatting is not working anymore. Dont get it. Does anyone had the same struggles?
@@RezaDorrani I figured a work around and embedded the events calendar which has the recurring. It works but not as pretty aesthetically:/ a girl can dream!
Well that's another common problem fixed and off my list. Thanks Reza
Next question I will get from customers will be formatting the events in the calendar to different colours and overlays like classic can handle but I guess we will have to wait for Microsoft to make that available or more options available for that. :)
Brilliant work.
Thanks for the fabulous feedback.
Calendar overlays, recurring events andmore features are missing in modern. Let's hope over time we get those features back.
Reza, we all don't like the old calendar and I have been waiting for an easy way to create modern calendar. You offered a great solution to change the old calendar to modern calendar. Thank you!
You are so welcome!
Reza, your content continues to help me every day in trying to use Microsoft's out-of-box functionality to achieve advanced outcomes. In my company, 'citizen developers' like myself are limited to what is available to us with our M365 suite and base SharePoint. This is probably the sixth or seventh video of yours that has immediately solved a problem for me. Thank you!
You are most welcome! Thank You so much for the valuable feedback. My goal has been to create content covering real world scenarios.
You have helped me loathe calendars a little less Reza, thanks so much for this.
Happy to hear that :)
Thanks so much Reza!
I hope you make a more longer toturial for a full solution as a project management tool.
With tasks and sub tasks etc.
Your welcome.
Fantastic video Reza. This helps a ton. I'd like to add a function that shows a view of conflicting events. When selecting or mousing over a date, can a view show events that one or more people are assigned, as well as any conflicts and what the specific conflict is between events (e.g. people on leave and not available to be assigned tasks, or tasks happening at the same time assigned to the same person and therefore showing a conflict of date availability)? Or, as a manager, I'd like to see what conflicts are occurring in the coming days/months for people, project event titles, and resources (i.e. personnel availability such as if people are on leave, or not enough qualified personnel, or other constraint requirements).
The calendar view is basic to start with.
Using JSON formatting only provides info for current item. It cannot traverse items to provide conflict information.
Reza, this is exactly what I was looking for! Thank you so much. I'm more of a low code/no code person but I am trying to learn json. I really like what you have done with the header, and I was hoping you might have a sample of that code somewhere I could use to customize?
Video description has links to download the JSON samples.
Link to my full playlist ruclips.net/p/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
Link to all my JSON samples github.com/rdorrani/SharePoint
@@RezaDorrani Oops, totally missed your JSON samples link. Thanks!
Excellent tutorial Reza. Thank you !
Thank You
Fantastic work Reza. Appreciated!!!💯 of 💯
Thanks
Excellent, exactly what I needed... thank you.
Need your advise, I added the attendees column in the Events list, however, it does not appear when adding a new event... need to change the JSON Body? & Header?
Not sure about new columns to be honest. It should show up in the form.
I would recommend posting your query on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
@@RezaDorrani thanx for that clarification ... 👍. One more thing, how can I change the side panel to show events for that month, instead of the events for the day... thanx for ur help.
@@laikahmed7120 I dont think updates are allowed to side panel. It is out of the box behavior.
A big LIKE Thanks so much Reza. Still waiting for multiple colors?
techcommunity.microsoft.com/t5/sharepoint/how-to-create-a-modern-and-colorful-calendar-view-in-sharepoint/m-p/3557022
Like before watching because I am sure it will be awesome as usual 🌹
Thank You
great video, very informative on my current calendar issue, is there json formatting for adding a resource checker? Or what happens when there are overlapping times choosen??
JSON formatting is only for data for that list. Resource checking and overlays are not possible as of now. Power Apps might be an option.
The sectioning is really helpful! Thanks! I just have problems with the Header: whatever I do and adjust to my columns, I can't bring it to show up like in your video. Will probs need to build it step by step to find my bug. But it's already impressive!
Step by step, slow and steady will get you there. The JSON has to be perfect. One small syntax issue and it will not render.
great video, thanks! Quick question: how can I edit the calender view in order to ONLY show Monday-Friday and hide Saturday+Sunday?!?! Thanks!
Welcome! This video is related to form formatting only. Not sure if there is such an option available in view formatting.
Awesome video again! Thank you. With Json, is it possible to add a "Button" in the event view pane or calendar view to start a workflow? (something similar you did in approval flows)
I don’t think it works on events list.
Thank you for this helpful tutorial. I'm looking to add some json to the form that specifies a hyperlink to create an appointment on the users Outlook Calendar (iCal).
I will have to try that out to provide any guidance. I would recommend you check on the forums in case some has done something similar at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Anoher great learning resource from one of the best! Thanks again Sir Reza. BTW I just notice that there is new Calendar Webpart available, but still yours can be customized, looking forward for your next videos :D
Thanks.
I have a new video on list formatting coming tomorrow.
@@RezaDorrani Wow thanks for the heads up, cant wait to see! :)
@@NelsonONadal Not calendar related though but I hope it’s worth your time
@@RezaDorrani o i see, but Im sure its Worth watching and relevant since it is coming from you
This Json + forms series are gold.. great content as always. Are you planning on making pad series? Power Automate Desktop.
Thanks. No plans for PAD since it currently is an ever changing landscape. Every month there are new actions with new features.
I had done a full series on UI flows last year that was well received. But it has all become obsolete now because of WinAuto and now PAD and probably more coming.
Love the Vid, very informative. Is there a way to color code each dif category?
That option was recently announced.
Coming soon - twitter.com/sharepoint/status/1536394903566962688?s=21&t=R3Px4Ts3n2IgZ6EBM3IVlg
This is great. That would be great helpful if you also post Json code or any reference to Json code.
All references and links are in description of video.
Thanks for the video. Question for header you have in json display": "=if([$Application] if my field is Application Name do I change it to ApplicationName together?
Use internal name - from what I can recollect. I have a playlist on SharePoint formatting on my channel. I do show how to get the column name in one of the videos.
Great video Reza! Is it possible to use form formatting and conditional formatting (like you can do with column formatting in a list)?
Yes
@@RezaDorrani If I create a new calendar view and setup conditional formatting on Category, it doesn't get applied. All items in the calendar end up with the theme colors.
@@roundaboutchannel Its been a while since I have tried formatting with calendars. I’m not sure if this is a limitation
Hi Reza, nice video! I just have a question: is there a way to format the view of the modern calendar to show only events created by the logged user?
Not possible using JSON code.
I think if you edit the view in SharePoint, you can define filters there. Example: CreatedBy is [Me]
@@RezaDorrani Thanks Reza! Yes, that's what I usually do in lists, but using a Calendar view this seems impossible, it doesnt allow editing the view like any other view. That a shame...Thank you anyway!
@@giuliapanico2771 You may be able to do it in the List Settings -> View - choose the calendar view name . This takes you to Edit Settings -> Filter - maybe try filter column name by looged in user?
Hi Reza! Thank you for your videos, they are just great!
I have a question, maybe you can help. Is there a way to change de view for the calendar once on the page? For example allow the user to see only one week or one day.
Thanks again!
May be by creating multiple calendar views. But I don't think you can swap views based on users.
@@RezaDorrani Thank you for your reply. The problem is that to create the view in week or day mode I have to do it with the classic experience. I don't know how to do it in modern experience. There is no option to change it. 😞
@@jaimesoares5574 There have been some announcements at ignite related to calendar views. Check or post your query on the SharePoint community forums techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Thanks for sharing. Any improvements to Calendar overlays formatting? They have standard boring colours... is it possible format calendar overlays with JSON
We will have to live with the boring colors for now. Hopefully a future update will have options to customize the overlays.
Thank you so much! You saved my day!!!!!!!!! Big thanks!!!!! Just one question, is it possible to have "Add to my calander" function on the morden event calander? If not, can we insert a meeting link for users to download a .ics file in the event list?
Thanks.
I believe if you click on the event or double click on it, it will download the ics file.
@@RezaDorrani Thank you for your reply. Unfortunately, when I double click on it, it downloads a .000 file, and I can't open.
@@pengshandai4141 Hmmn. Im not sure about it. I will recommend checking on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
a lot of meat today. thanks for the video. Sharepoint is again enhanced and will be receiving workflow updates soon. i wonder if microsoft is moving to change its office and power platform offers.
Thank You
As always great video
Thanks Marcelo. As for your question on full width on modern page, the embed web part cannot be added in that section. However, using SPFx we can build a full width web part that directly links to that view.
This is great. I am trying to retain the " + Add to calendar" feature that is in the classic event format but is not in a modern list. Is there a way to have that feature remain when using the modern format? So by opening the detail form that feature would be listed to download the ics file?
I believe if you click on the event shown in calendar it does download the ics file.
We cannot change much in the UI at the moment.
As always, great stuff. Thanks for sharing. Is there a way to format the fields in the sections as well. let's say i have a multiline text field and want it to span across two columns. Is there any way to do this at the moment?
At the moment we do not have any formatting options for sections.
@@RezaDorrani Thank you!
Hi Reza, So many thanks for all your videos. Really makes this more accessible to low/no-code people like me.
I'm using the Europe date string (so day/month/year) and it gives me the month back in the nice agenda lay-out. Although in the formula it is getmonth. Regards, Wolter
Thank you
Interestingly, I’m trying to get this to work using Australian date formatting (our region settings are for en-Australia, and I’m seeing “invalid date” and NaN in the mini calendar. I’ve tried to correct using the ‘en-GB’ modifier of the toLocaleDateString() function, but that hasn’t worked. When I changed my region settings to US, it works fine, but we’re not used to working with dates in ‘mm/dd/yyyy’ format and would much prefer a solution that doesn’t involve changing our SharePoint site’s region setting. Anyone have any suggestions to make this JSON work for ‘dd/mm/yyyy’ formatted dates?
@@geoffmckeon5902 Hey, I am having the same problem as you, have you found anything to resolve this issue? Thanks!
@@carrotte I haven't yet. For now, I've reverted to the classic calendar as other projects have become higher priority. I'll come back to this eventually and hopefully find a solution.
Great video! Do you know how to make the colour of an event conditional on the category in the new experience? Similar to calendar overlays in the classic experience is what I'm looking for.
twitter.com/aaclage/status/1538988441710612487?s=20&t=8BqBTUp2av9h8ZPJQrtHVg
Great stuff Reza. Is there a way change the background color of the list form using json?
Currently, no formatting allowed for the form body.
Only header and footer can be formatted.
@@RezaDorrani OK thanks, I'm hoping we see something in that area soon.
@@alexegharevba1026 As soon as it comes, I will video blog about it
Hello Reza! Another amazing video.
I have a question.It didnt recognised the dates because my site settings were English(UK). How can I modify the json to make it work for English (uk)?
Ahhh! Not sure about that one. Might even be a bug.
I will recommend checking on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint in case someone has done something similar.
Great video - really useful. Is there a way to customise the events with custom colour based on category selected on the event. Similar to overlay in previous SharePoint calendar view.
No options to customize the calendar view are available as of now. As far as the form formatting, the calendar header colors can be changed based on the category selected.
I liked the trick of taking a classic calendar list, which is compatible with Outlook, and adding the modern calendar view to either supplement or replace the classic calendar view. However, I don't think it works in Teams using the Lists app. This is a similar behavior when trying to add a classic list to a modern page. So, I recommend just starting with a modern experience list from scratch so that you can put this nice JSON prettified view on your page and have it show up in Teams with hassling users about access issues.
I don't think you comment is related to this video. Video is about Form Control in Power Apps.
Thanks, mate!
You're welcome!
This looks great, however I had a couple of issues when I tried and I'm not sure if I missed something.
1) First issue was the dates were not recognised because my site settings were English(Australia). I changed to English (US) and it resolved the issue, but is there a way to modify the json to make it work for English (Australia)?
2) second issue is if you double click on a calendar entry in the view, the browser navigates to about:blank and downloads a 000 File (.000).
Is there a way to fix this so that it launches the information pane?
1 - not sure about the time zone issue.
2 - It is the default behavior of the calendar control. User will have to click the details icon.
THANK YOU FOR THIS!!!!
Most welcome!
Hello Reza. Thanks for this video, it's super useful. Is it possible to wrap text in calendar, so I can see all event name without pointing with cursor? Thank you!
I am not sure if that is possible
Great video ! I would love to know if there is some official certification for power automate, do you know ?
There is no speicific Power Auotmate certification.
But there are Power Platform certifications that include Power Automate.
Here is the list: PL-900,PL-100,PL-200,PL-400 and soon to come PL-600.
@@RezaDorrani thank you for taking the time to answer me sir will check them out
Thanks a million , can you please advise when I format Body the list field is not taking the full size of the section (each section has 3) only last has only one which is multi line text .How can I change this? I formated column and still the same and in the default view I have 2 hidden fields do you think this affect width of last item in the section?
The field size is not in control of JSON form formatting. That behavior is currently Out of the box and cannot be changed.
Hi Reza Thank you so much for this video can I please ask how do I prevent users to book particular date on the calendar?
You would need to look into column validation. JSON formatting is for UI only. It does not support validations.
Excellent Reza..😊
Here I have one question to ask you if you see for Single day Events, Multi-Day Events and Recursive Events only single item is getting created in the Event List. When I tried to populate these Events in Gallery of PowerApps I can't able to filter the Multi-Day events if I select in-between days of Multi-Day event. Here I had used StartDate and EndDate DatePicker control to filter the Events Gallery.
Need your inputs on this.
Modern calendar does not support recurring events. Even multi-day events have a bug currently.
You would have to use the classic calendar as the modern one does not support these.
@@RezaDorrani .. Thanks for your prompt reply and taking time to look into the issue. 😊
You have saved lot of my time. You are a marvelous person and a great guide.
@@shaiksamad1562 You are most welcome
and for my dates I have the field name setup as Release Date and Time where in the json do i change that and should it all be together? For the header section. Many thanks!
I have a full playlist on SharePoint formatting. In one of the videos, I showcase how to grab the column names for the header.
Thanks Sir!
Most welcome!
This is a great video! I want to add a Person field to the header and struggling on how to do so. Any tips?
Not something I have tried.
@@RezaDorrani I figured it out. The JSON to include is: {
"elmType": "img",
"attributes": {
"src": "='/_layouts/15/userphoto.aspx?size=S&accountname=' + [$Presenter.email]",
"alt": "Presenter
Fantastic!
Thank you! Cheers!
Hi Reza! Great video! I would like to make the Blue Banner in your video an image from my item's column "Banner URL", how should i replace a part of your code to do this task?
Any help is appreciated!
Check the documentation on how to work with Image columns.
@@RezaDorrani I read over the documentation but still can't seem to get it. So far I have the Image inside of the blue box you created next to the Title but I would like the entire blue box to be the image. Is this possible?
Hi Reza, thanks for your great videos. I'm now doing timesheet on SharePoint and PowerApps and I would like to make selected month from dropdown then date auto detected. Could you advise?
Are you using Power Apps or SharePoint form formatting?
And I did not understand the requirement on date auto detected based on month.
@@RezaDorrani I use data source from sharepoint list and use powerapps to design form i would like to make drop-down list with month once selected month then show day of month
Hey Reza, is there any way to display the modern calendar in a "Weekly" view rather than a "Monthly" one
Currently, calendar only has the monthly view.
Great work man, I have a question though, when I select any day to add a new event, it opens the form empty
How can I make the start date entered automaticlly?
I believe that is default behavior
@@RezaDorrani I traied it but it opened the form empty for me to fill it
@@abdelrahmangamal358 I mean by default it does not fill it seems.
Reza, excelente trabalho.
Se eu quiser trocar os campos de texto para campos de escolha, eu tenho que mudar seu Json de cabeçalho?
É possível não deixar salvar o evento se a data tiver no passado?
Muito obrigado.
To change text to choice field, you would need to create a new column.
To not let event save in past, you would need to look at validation settings in list.
@@RezaDorrani Reza, se eu trocar o campo para escolha, eu devo ajustar o Json de cabeçalho, correto? Tem um documento para compartilhar que me informe como ajustar o Json para esses novos campos?
Muito obrigado.
@@RezaDorrani Reza, tem algum material para configurar o campo para não salvar no passado?
Muito obrigado.
@@MemoryCompanyTI I do not have a video on this case.
Obrigado, Reza.
Abraços.
Excelente vídeo, Reza.
Como faço para não permitir salvar na mesma data do evento? Devo usar o Power Automate ou condição no SharePoint?
Obrigado.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani - Obrigado pelo feedback.
Acredito que conseguiremos fazer essas regras dentro do Power Automate com histórico de alteração de colunas no SharePoint.
Abraços.
@@MemoryCompanyTI Give it a try and check on forums as well.
Thanks Reza
Welcome Sundra
Hi Reza,
Thanks for the great video. I have two issues
Title column is saving it as a number
Recurrence and All day Events are not displaying on the form. Is their any way to add them
Title as number - check internal name of column.
Recurrence and All day Events are not supported in JSON at the moment.
It's a useful video @reza dorrani. I have a query......in my sharepoint site we are using dd/mm/yyyy format.....but your code output showing in MM/DD/YYYY format. the calender preview is showing in NAN Error. Can u please suggest where we have to change the code?
I will have to look at your list / site settings and JSON code to provide any guidance.
Check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Superb - though how do I change the data format - our site is set as dd/mm/yy. So when I add an event using yoru JSON for 6 feb 2024 - it shows 2 June 2024
Its been a long while since I did this video.
I would suggest exploring the json formatting documentation to see how to update formats.
So I am using the MS Issues Tracker template, I have modified it for my use but noticed that the "Days Old" column doesn't update automatically, is there a way to achieve this using a formula or JSON?
Days Old is a calculated column which is the part of the list template. You can go to list settings to check its formula.
When I click on a day in the calender view, (let's say monday next week for example) and add a new event, how can I set the start date to this day instead of the current day?
When you select a day, the Start Time does show up as the date selected. Its the end time that shows todays date. This is the default behavior of the calendar and cannot be customized using JSON formatting.
Many thanks, Reza!
At 11:15, you embedded the calendar into a page using an . No problem. You also have a lot of unused whitespace on either side of the calendar. How can you embed a calendar view into the full width of a page?
When creating a new section in a page, we can select "full width section", which is fine. However, the only options we have there are "Image", "Hero" and "Countdown Timer"(?). In the "Hero" option, if we change it to show only one tile, and open a calendar page or the calendar list, all that is shown is an image and link to open a different calendar page or calendar list. We cannot use SPFx and cannot create new web parts to make the calendar full width. Any ideas? 🤷♂
I am not aware of a way without spfx to achieve that.
@@RezaDorrani Yeah... thought so. 🙁 Thank you for responding. I was hoping there was a way to add a calendar just with "out of the box" features. Perhaps, I won't embed the calendar in a page but just open the calendar view in the menu. We shall see...
@@stefancochrane2723 I am sure there would be some option. This video was done a while ago. I have not revisited it since.
@@RezaDorrani For the project I'm doing, I can only use "out of the box" options, so no SPFx. I also read that a tenant admin can create a custom web part, with a few JSON changes, to allow lists or libraries to show in a full width. For now, I'll just open the list in calendar view from the top menu. I was going to use different colors for different list items, but I will remove them since I cannot add a legend to explain the colors to users. Oh, well...
Hello Reza, I get the modern view when I select all list view, but when I select +New to create a new task, I do not get the single event pane on the right, I get the old add event window? Could this be an entitlement issue?
Should not be. May be your list is not a modern list.
Hi Reza, the given changes doesn't trigger in Edit form. I have to update my fields > save it > reOpen item > now it reflects but it doesn't update anything in header formatting if I change the dates. On other side, it work like charm in New form. Any idea where it might go wrong?
I would have to look at your SharePoint calendar to know why. I would recommend to post your issue on the forums at powerusers.microsoft.com/
Is there a reason you can not add in the "Add Day" radial button? Tried a few different ways to include in the JSON script but was not successful. Thanks!
JSON form formatting script only allows formatting. Triggering actions is currently not supported.
Is it possible to give different colours
For each category event in the modern calendar view? Some what like overlays of classic calendar.
Sorry for redundant question..got the answer from other comments.
Btw nice video
Looks like you got answer from other comments :)
Thanks for watching
Hello Reza, thank you so much for your excellent video. However, I cannot change the Date format from US to Germany, eventhough I changed the regional seetings in German.
Not sure about the date format. I had another user report the same. I will recommend you check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Hi Reza, I have a customised SP Form. When I open the form in new or edit mode, it shows "Apply Label" field automatically, which is really annoying. Can you please advise, how I can hide that field in my form
I noticed this yesterday as well. It has to do with retention labels of Office 365. Currently, No way to remove it.
@@RezaDorrani Thank you!
Thanks Reza, this is exactly what I have been trying to set up. But I am having an issue. When I go to List Setting --> Advanced Settings and click on New Experience and then go back to All Items view. I still have the classic view. I cannot figure why. Any tips?
Try refreshing your browser cache. I have not faced this issue though.
@@RezaDorrani Thank you . I got it working but a different way. I think we are using the latest version of Sharepoint and I went to the 3 dots to the right of the Events in All Site Contents and clicked on Details, then I installed the calendar app. From there I was able to get the list to be the modern view, add the JSON code and it seems to be working. BUT... I cannot figure out how to get an event to be recurring. A recurring option doesn't show up in the body of the JSON code and the recurrence column does show up in the All Items list view but it is read only. How can I get that to be editable?
I dont think recurring option is supported with JSON customizations.
Great job with this, Thanks Reza. something weird with the 'Title' showing up as 1_.000, 2_.000. 3_.000, etc....
Looks like its showing the version number of item in your case. Check your JSON schema or Title column value.
@@RezaDorrani I went to check the Body JSON code and it was gone. The header was there. Added it again, and it would not SAVE.
I found an article about it to fix it.
Great!
Marie, Do you still have the link for this issue?
Everything seems to work pretty well despite Microsoft's slowness. however the dates, location etc. do not show up on the header only the title? Is there something simple i am missing?
I will have to look at your JSON formatting & list columns (internal names and types) in action to provide guidance. I would recommend posting your query on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Hi...how to know week number based selected date?
Here is the full schema definition - developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json
I have not tried this but with some of the functions available, this could be possible.
🙏🙋♂️
👍
How did you created the two columns for Time and Date? Mine is only showing one standard format date and time.
A calendar comes with start date and end date. Automatically those columns should show up.
Hey, how can I get the Time and Date from a column thats a date and time column. I tried:
"elmType": "span",
"txtContent": "=toLocaleString([$StartDate]) + ' - ' + toLocaleString([$EndDate])"
even if I used currentField, nothing get displayed. So I have a normal List with two date/time columns. I dont have an event list. Thank you
I would have to try it out to know how this one works. Il recommend checking the docs.
thank you for the quick response ... I tried with the docs but so far I dont have any progress@@RezaDorrani
@@RezaDorrani , I figure out now. But I have now a different problem. I am struggling with changing the Columns. If I change it to my Title Column and a second one the color formatting is working. If I apply it to any other column the formatting is not working anymore. Dont get it. Does anyone had the same struggles?
@@LauraLuisaRosenberg I have not faced any issues with it so not sure
How would I go about adding events recurring to this? It’s available in events but not list when I hit new
I believe the modern SP calendar does not support recurring event logic. Might be a feature that would be supported in future.
@@RezaDorrani I figured a work around and embedded the events calendar which has the recurring. It works but not as pretty aesthetically:/ a girl can dream!
Hi Reza, Are Recurrence options missing??? what can be the solution??
Missing
Anyone know how to get an event to span across multiple days. I have some events that span 5 days, but only display on the last day
Not sure about that
Can u please tell me how can they view category and location
They can select the item to open the form and view the details
when we add a calendar app and we in Month view, By default it shows from Sunday to Saturday. How do we make it show from Monday ?
I believe it gets that from site settings. There is some feature there that controls it.
If my column names have spaces in them, how do I represent that column in JSON?
I believe it takes internal names. Give the column internal name.
Go to list settings, click on column, url will have the internal name
It's a shame you cannot hide Saturday or Sunday. Seems like basic functionality that should be there.
Hopefully, in fullness of time.