Тёмный

SharePoint Modern Calendar with Form Formatting JSON 

Reza Dorrani
Подписаться 130 тыс.
Просмотров 37 тыс.
50% 1

#SharePoint #ListFormatting #CalendarView
In this video on SharePoint Modern Calendar with Form Formatting JSON, we will walk through an end-to-end solution of customizing SharePoint Events lists with the new form formatting JSON options for Header, Body and Footer.
We will also build a Modern Calendar View from the SharePoint Events List and add it to a Modern SharePoint Page along with the JSON formatted Events list form.
This newly released feature of form formatting uses the same logic as SharePoint List Formatting (column and view formatting). Hence, we can now customize the look and feel of our SharePoint columns, SharePoint views and SharePoint Forms using JSON and apply conditional formatting.
✅ Customize SharePoint List Forms Playlist video series - • SharePoint List Format...
✅ Download Formatting Samples for Events Lists:
github.com/rdorrani/SharePoin...
✅ Documentation: docs.microsoft.com/en-us/shar...
✅ PnP Samples: pnp.github.io/sp-dev-list-for...
⭐ ⭐ ⭐ Huge shoutout to / techan_k - My JSON formatting samples are inspired from his work. Follow him on twitter and subscribe to his blog - mynote365.hatenadiary.com/
Table of Contents:
00:00 - Intro
00:48 - Events List in a Modern SharePoint site
01:50 - Apply Body JSON form formatting for Events List
03:10 - Customize Header JSON form formatting for Events List
04:20 - JSON breakdown for the Calendar/Events List form formatting
06:52 - Make a Modern Calendar View
09:20 - Add a Modern Calendar View as a web part to a Modern SharePoint Page
11:44 - Subscribe

Опубликовано:

 

21 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 209   
@Worrelpa
@Worrelpa 3 года назад
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.
@RezaDorrani
@RezaDorrani 3 года назад
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.
@ppei2012
@ppei2012 3 года назад
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!
@RezaDorrani
@RezaDorrani 3 года назад
You are so welcome!
@AlexRathwyn
@AlexRathwyn Год назад
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!
@RezaDorrani
@RezaDorrani Год назад
You are most welcome! Thank You so much for the valuable feedback. My goal has been to create content covering real world scenarios.
@bootsbax
@bootsbax 3 года назад
You have helped me loathe calendars a little less Reza, thanks so much for this.
@RezaDorrani
@RezaDorrani 3 года назад
Happy to hear that :)
@chintandd
@chintandd 2 года назад
Fantastic work Reza. Appreciated!!!💯 of 💯
@RezaDorrani
@RezaDorrani 2 года назад
Thanks
@kimh3937
@kimh3937 3 года назад
Excellent tutorial Reza. Thank you !
@RezaDorrani
@RezaDorrani 3 года назад
Thank You
@Mahmoudalgindy
@Mahmoudalgindy 3 года назад
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.
@RezaDorrani
@RezaDorrani 3 года назад
Your welcome.
@Mahmoudalgindy
@Mahmoudalgindy 3 года назад
Like before watching because I am sure it will be awesome as usual 🌹
@RezaDorrani
@RezaDorrani 3 года назад
Thank You
@scotthoyt2773
@scotthoyt2773 2 года назад
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).
@RezaDorrani
@RezaDorrani 2 года назад
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.
@cptcavernicola
@cptcavernicola 3 года назад
As always great video
@RezaDorrani
@RezaDorrani 3 года назад
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.
@julianehack1336
@julianehack1336 3 года назад
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!
@RezaDorrani
@RezaDorrani 3 года назад
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.
@luvdogzz
@luvdogzz 2 года назад
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?
@RezaDorrani
@RezaDorrani 2 года назад
Video description has links to download the JSON samples. Link to my full playlist ru-vid.com/group/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf Link to all my JSON samples github.com/rdorrani/SharePoint
@luvdogzz
@luvdogzz 2 года назад
@@RezaDorrani Oops, totally missed your JSON samples link. Thanks!
@markjohnston2827
@markjohnston2827 Год назад
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.
@RezaDorrani
@RezaDorrani Год назад
I don't think you comment is related to this video. Video is about Form Control in Power Apps.
@shootu2003
@shootu2003 2 года назад
THANK YOU FOR THIS!!!!
@RezaDorrani
@RezaDorrani 2 года назад
Most welcome!
@richardr777
@richardr777 15 дней назад
Thanks, mate!
@RezaDorrani
@RezaDorrani 15 дней назад
You're welcome!
@NelsonONadal
@NelsonONadal Год назад
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
@RezaDorrani
@RezaDorrani Год назад
Thanks. I have a new video on list formatting coming tomorrow.
@NelsonONadal
@NelsonONadal Год назад
@@RezaDorrani Wow thanks for the heads up, cant wait to see! :)
@RezaDorrani
@RezaDorrani Год назад
@@NelsonONadal Not calendar related though but I hope it’s worth your time
@NelsonONadal
@NelsonONadal Год назад
@@RezaDorrani o i see, but Im sure its Worth watching and relevant since it is coming from you
@markherman9561
@markherman9561 2 года назад
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).
@RezaDorrani
@RezaDorrani 2 года назад
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
@berndkroon5147
@berndkroon5147 3 года назад
Fantastic!
@RezaDorrani
@RezaDorrani 3 года назад
Thank you! Cheers!
@vennaarjunprabhakar5834
@vennaarjunprabhakar5834 Год назад
Thanks Sir!
@RezaDorrani
@RezaDorrani Год назад
Most welcome!
@shanthan6995
@shanthan6995 3 года назад
This is great. That would be great helpful if you also post Json code or any reference to Json code.
@RezaDorrani
@RezaDorrani 3 года назад
All references and links are in description of video.
@sadabshaikh6365
@sadabshaikh6365 3 года назад
This Json + forms series are gold.. great content as always. Are you planning on making pad series? Power Automate Desktop.
@RezaDorrani
@RezaDorrani 3 года назад
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.
@radhikamarda9407
@radhikamarda9407 2 года назад
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)
@RezaDorrani
@RezaDorrani 2 года назад
I don’t think it works on events list.
@WolterRijks
@WolterRijks 3 года назад
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
@RezaDorrani
@RezaDorrani 3 года назад
Thank you
@geoffmckeon5902
@geoffmckeon5902 3 года назад
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
@carrotte 3 года назад
@@geoffmckeon5902 Hey, I am having the same problem as you, have you found anything to resolve this issue? Thanks!
@geoffmckeon5902
@geoffmckeon5902 3 года назад
@@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.
@LuisSalas-vi4ck
@LuisSalas-vi4ck Год назад
A big LIKE Thanks so much Reza. Still waiting for multiple colors?
@RezaDorrani
@RezaDorrani Год назад
techcommunity.microsoft.com/t5/sharepoint/how-to-create-a-modern-and-colorful-calendar-view-in-sharepoint/m-p/3557022
@kengami
@kengami 6 месяцев назад
great video, thanks! Quick question: how can I edit the calender view in order to ONLY show Monday-Friday and hide Saturday+Sunday?!?! Thanks!
@RezaDorrani
@RezaDorrani 6 месяцев назад
Welcome! This video is related to form formatting only. Not sure if there is such an option available in view formatting.
@fleurwilliamson5920
@fleurwilliamson5920 3 года назад
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?
@RezaDorrani
@RezaDorrani 3 года назад
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.
@Blobski247
@Blobski247 2 года назад
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.
@RezaDorrani
@RezaDorrani 2 года назад
twitter.com/aaclage/status/1538988441710612487?s=20&t=8BqBTUp2av9h8ZPJQrtHVg
@hudge5
@hudge5 2 года назад
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?
@RezaDorrani
@RezaDorrani 2 года назад
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.
@mervatelmansi7405
@mervatelmansi7405 3 года назад
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?
@RezaDorrani
@RezaDorrani 3 года назад
The field size is not in control of JSON form formatting. That behavior is currently Out of the box and cannot be changed.
@hpickus222
@hpickus222 Год назад
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?
@RezaDorrani
@RezaDorrani Год назад
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.
@mansukhirani5354
@mansukhirani5354 3 года назад
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.
@RezaDorrani
@RezaDorrani 3 года назад
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.
@kannank9251
@kannank9251 3 года назад
Thanks for sharing. Any improvements to Calendar overlays formatting? They have standard boring colours... is it possible format calendar overlays with JSON
@RezaDorrani
@RezaDorrani 3 года назад
We will have to live with the boring colors for now. Hopefully a future update will have options to customize the overlays.
@flois88
@flois88 2 года назад
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??
@RezaDorrani
@RezaDorrani 2 года назад
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.
@jaimesoares5574
@jaimesoares5574 2 года назад
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
@RezaDorrani 2 года назад
May be by creating multiple calendar views. But I don't think you can swap views based on users.
@jaimesoares5574
@jaimesoares5574 2 года назад
@@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. 😞
@RezaDorrani
@RezaDorrani 2 года назад
@@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
@bouseuxlatache4140
@bouseuxlatache4140 3 года назад
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.
@RezaDorrani
@RezaDorrani 3 года назад
Thank You
@guigamerboy
@guigamerboy 2 года назад
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)?
@RezaDorrani
@RezaDorrani 2 года назад
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.
@laikahmed7120
@laikahmed7120 2 года назад
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?
@RezaDorrani
@RezaDorrani 2 года назад
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
@laikahmed7120
@laikahmed7120 2 года назад
@@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.
@RezaDorrani
@RezaDorrani 2 года назад
@@laikahmed7120 I dont think updates are allowed to side panel. It is out of the box behavior.
@ThomasPoth
@ThomasPoth 3 года назад
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?
@RezaDorrani
@RezaDorrani 3 года назад
At the moment we do not have any formatting options for sections.
@ThomasPoth
@ThomasPoth 3 года назад
@@RezaDorrani Thank you!
@VirendraSingh-xb4iw
@VirendraSingh-xb4iw 2 года назад
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.
@RezaDorrani
@RezaDorrani 2 года назад
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
@hpickus222
@hpickus222 Год назад
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
@RezaDorrani Год назад
I have a full playlist on SharePoint formatting. In one of the videos, I showcase how to grab the column names for the header.
@sundrapillay6668
@sundrapillay6668 3 года назад
Thanks Reza
@RezaDorrani
@RezaDorrani 3 года назад
Welcome Sundra
@user-hi6gw4jb6d
@user-hi6gw4jb6d 3 года назад
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?
@RezaDorrani
@RezaDorrani 3 года назад
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.
@yaredtar5488
@yaredtar5488 2 года назад
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
@RezaDorrani
@RezaDorrani 2 года назад
Title as number - check internal name of column. Recurrence and All day Events are not supported in JSON at the moment.
@johnciarrochi1723
@johnciarrochi1723 2 года назад
Love the Vid, very informative. Is there a way to color code each dif category?
@RezaDorrani
@RezaDorrani 2 года назад
That option was recently announced. Coming soon - twitter.com/sharepoint/status/1536394903566962688?s=21&t=R3Px4Ts3n2IgZ6EBM3IVlg
@aniaw4009
@aniaw4009 Год назад
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!
@RezaDorrani
@RezaDorrani Год назад
I am not sure if that is possible
@Legacy-DC
@Legacy-DC 3 года назад
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!
@RezaDorrani
@RezaDorrani 3 года назад
JSON form formatting script only allows formatting. Triggering actions is currently not supported.
@MultiChris7777
@MultiChris7777 3 года назад
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?
@RezaDorrani
@RezaDorrani 3 года назад
Days Old is a calculated column which is the part of the list template. You can go to list settings to check its formula.
@giuliapanico2771
@giuliapanico2771 2 года назад
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?
@RezaDorrani
@RezaDorrani 2 года назад
Not possible using JSON code. I think if you edit the view in SharePoint, you can define filters there. Example: CreatedBy is [Me]
@giuliapanico2771
@giuliapanico2771 2 года назад
@@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!
@christopherlawes9286
@christopherlawes9286 2 года назад
@@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?
@ozifer7934
@ozifer7934 Год назад
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?
@RezaDorrani
@RezaDorrani Год назад
You would need to look into column validation. JSON formatting is for UI only. It does not support validations.
@area_2111
@area_2111 3 года назад
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
@RezaDorrani 3 года назад
Are you using Power Apps or SharePoint form formatting? And I did not understand the requirement on date auto detected based on month.
@area_2111
@area_2111 3 года назад
@@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
@plumpkin211
@plumpkin211 2 года назад
Hey Reza, is there any way to display the modern calendar in a "Weekly" view rather than a "Monthly" one
@RezaDorrani
@RezaDorrani 2 года назад
Currently, calendar only has the monthly view.
@pengshandai4141
@pengshandai4141 2 года назад
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?
@RezaDorrani
@RezaDorrani 2 года назад
Thanks. I believe if you click on the event or double click on it, it will download the ics file.
@pengshandai4141
@pengshandai4141 2 года назад
@@RezaDorrani Thank you for your reply. Unfortunately, when I double click on it, it downloads a .000 file, and I can't open.
@RezaDorrani
@RezaDorrani 2 года назад
@@pengshandai4141 Hmmn. Im not sure about it. I will recommend checking on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
@michaelc1042
@michaelc1042 2 года назад
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?
@RezaDorrani
@RezaDorrani 2 года назад
Should not be. May be your list is not a modern list.
@MrAustin308
@MrAustin308 2 года назад
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?
@RezaDorrani
@RezaDorrani 2 года назад
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
@chintandd
@chintandd 2 года назад
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?
@RezaDorrani
@RezaDorrani 2 года назад
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/
@Anilkumar-cd7yr
@Anilkumar-cd7yr 3 года назад
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?
@RezaDorrani
@RezaDorrani 2 года назад
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
@shaiksamad1562
@shaiksamad1562 3 года назад
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.
@RezaDorrani
@RezaDorrani 3 года назад
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.
@shaiksamad1562
@shaiksamad1562 3 года назад
@@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.
@RezaDorrani
@RezaDorrani 3 года назад
@@shaiksamad1562 You are most welcome
@roundaboutchannel
@roundaboutchannel Год назад
Great video Reza! Is it possible to use form formatting and conditional formatting (like you can do with column formatting in a list)?
@RezaDorrani
@RezaDorrani Год назад
Yes
@roundaboutchannel
@roundaboutchannel Год назад
@@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
@RezaDorrani Год назад
@@roundaboutchannel Its been a while since I have tried formatting with calendars. I’m not sure if this is a limitation
@RPAChampion
@RPAChampion 3 года назад
Great video ! I would love to know if there is some official certification for power automate, do you know ?
@RezaDorrani
@RezaDorrani 3 года назад
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.
@RPAChampion
@RPAChampion 3 года назад
@@RezaDorrani thank you for taking the time to answer me sir will check them out
@stefancochrane2723
@stefancochrane2723 Год назад
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
@RezaDorrani Год назад
I am not aware of a way without spfx to achieve that.
@stefancochrane2723
@stefancochrane2723 Год назад
@@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
@RezaDorrani Год назад
@@stefancochrane2723 I am sure there would be some option. This video was done a while ago. I have not revisited it since.
@stefancochrane2723
@stefancochrane2723 Год назад
@@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...
@MC-dk2st
@MC-dk2st 2 года назад
How did you created the two columns for Time and Date? Mine is only showing one standard format date and time.
@RezaDorrani
@RezaDorrani 2 года назад
A calendar comes with start date and end date. Automatically those columns should show up.
@alexegharevba1026
@alexegharevba1026 3 года назад
Great stuff Reza. Is there a way change the background color of the list form using json?
@RezaDorrani
@RezaDorrani 3 года назад
Currently, no formatting allowed for the form body. Only header and footer can be formatted.
@alexegharevba1026
@alexegharevba1026 3 года назад
@@RezaDorrani OK thanks, I'm hoping we see something in that area soon.
@RezaDorrani
@RezaDorrani 3 года назад
@@alexegharevba1026 As soon as it comes, I will video blog about it
@anjanr22
@anjanr22 2 года назад
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
@RezaDorrani
@RezaDorrani 2 года назад
I noticed this yesterday as well. It has to do with retention labels of Office 365. Currently, No way to remove it.
@anjanr22
@anjanr22 2 года назад
@@RezaDorrani Thank you!
@TheSujaypatel
@TheSujaypatel 3 года назад
Is it possible to give different colours For each category event in the modern calendar view? Some what like overlays of classic calendar.
@TheSujaypatel
@TheSujaypatel 3 года назад
Sorry for redundant question..got the answer from other comments. Btw nice video
@RezaDorrani
@RezaDorrani 3 года назад
Looks like you got answer from other comments :)
@RezaDorrani
@RezaDorrani 3 года назад
Thanks for watching
@nzuraw
@nzuraw 5 месяцев назад
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
@RezaDorrani
@RezaDorrani 5 месяцев назад
Its been a long while since I did this video. I would suggest exploring the json formatting documentation to see how to update formats.
@aliciagonzalez2648
@aliciagonzalez2648 Год назад
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
@RezaDorrani Год назад
Check the documentation on how to work with Image columns.
@aliciagonzalez2648
@aliciagonzalez2648 Год назад
@@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?
@DouglasP33
@DouglasP33 Год назад
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
@RezaDorrani Год назад
Try refreshing your browser cache. I have not faced this issue though.
@DouglasP33
@DouglasP33 Год назад
@@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?
@RezaDorrani
@RezaDorrani Год назад
I dont think recurring option is supported with JSON customizations.
@LauraLuisaRosenberg
@LauraLuisaRosenberg 4 месяца назад
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
@RezaDorrani 4 месяца назад
I would have to try it out to know how this one works. Il recommend checking the docs.
@LauraLuisaRosenberg
@LauraLuisaRosenberg 4 месяца назад
thank you for the quick response ... I tried with the docs but so far I dont have any progress@@RezaDorrani
@LauraLuisaRosenberg
@LauraLuisaRosenberg 3 месяца назад
@@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
@RezaDorrani 3 месяца назад
@@LauraLuisaRosenberg I have not faced any issues with it so not sure
@nzuraw
@nzuraw 4 месяца назад
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
@RezaDorrani
@RezaDorrani 4 месяца назад
Not sure about that
@Bakasphotography
@Bakasphotography Год назад
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 ?
@RezaDorrani
@RezaDorrani Год назад
I believe it gets that from site settings. There is some feature there that controls it.
@nerdgal
@nerdgal Год назад
How would I go about adding events recurring to this? It’s available in events but not list when I hit new
@RezaDorrani
@RezaDorrani Год назад
I believe the modern SP calendar does not support recurring event logic. Might be a feature that would be supported in future.
@nerdgal
@nerdgal Год назад
@@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!
@sachinmangalwedhe8194
@sachinmangalwedhe8194 3 года назад
Hi...how to know week number based selected date?
@RezaDorrani
@RezaDorrani 3 года назад
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.
@hitasajil3869
@hitasajil3869 Год назад
Hi Reza, Are Recurrence options missing??? what can be the solution??
@RezaDorrani
@RezaDorrani Год назад
Missing
@keithb2684
@keithb2684 2 года назад
If my column names have spaces in them, how do I represent that column in JSON?
@RezaDorrani
@RezaDorrani 2 года назад
I believe it takes internal names. Give the column internal name. Go to list settings, click on column, url will have the internal name
@MemoryCompanyTI
@MemoryCompanyTI Год назад
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.
@RezaDorrani
@RezaDorrani Год назад
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.
@MemoryCompanyTI
@MemoryCompanyTI Год назад
@@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.
@MemoryCompanyTI
@MemoryCompanyTI Год назад
@@RezaDorrani Reza, tem algum material para configurar o campo para não salvar no passado? Muito obrigado.
@RezaDorrani
@RezaDorrani Год назад
@@MemoryCompanyTI I do not have a video on this case.
@MemoryCompanyTI
@MemoryCompanyTI Год назад
Obrigado, Reza. Abraços.
@vijayak7871
@vijayak7871 Год назад
Can u please tell me how can they view category and location
@RezaDorrani
@RezaDorrani Год назад
They can select the item to open the form and view the details
@MemoryCompanyTI
@MemoryCompanyTI Год назад
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.
@RezaDorrani
@RezaDorrani Год назад
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
@MemoryCompanyTI
@MemoryCompanyTI Год назад
@@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.
@RezaDorrani
@RezaDorrani Год назад
@@MemoryCompanyTI Give it a try and check on forums as well.
@aaaaa601
@aaaaa601 2 года назад
🙏🙋‍♂️
@RezaDorrani
@RezaDorrani 2 года назад
👍
@marieraymond6512
@marieraymond6512 3 года назад
Great job with this, Thanks Reza. something weird with the 'Title' showing up as 1_.000, 2_.000. 3_.000, etc....
@RezaDorrani
@RezaDorrani 3 года назад
Looks like its showing the version number of item in your case. Check your JSON schema or Title column value.
@marieraymond6512
@marieraymond6512 3 года назад
@@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.
@marieraymond6512
@marieraymond6512 3 года назад
I found an article about it to fix it.
@RezaDorrani
@RezaDorrani 3 года назад
Great!
@carolynncoy8606
@carolynncoy8606 2 года назад
Marie, Do you still have the link for this issue?
@tomrwills
@tomrwills Год назад
It's a shame you cannot hide Saturday or Sunday. Seems like basic functionality that should be there.
@RezaDorrani
@RezaDorrani Год назад
Hopefully, in fullness of time.
Далее
Strong cat !! 😱😱
00:19
Просмотров 1,4 млн
Transform Content Navigation With List JSON Formatting
11:10
Power Apps Calendar with SharePoint Data
28:44
Просмотров 56 тыс.