[1,2,3,4,5,8,9,10,11,12,15,16,17,18,19,22,23,24,25,26,29,30,31,32,33,36,37,38,39,40,41]
2. / 3.
You should be able to show different colors based on dropdown values in the CalendarEventsGallery (or items) fill property.
Keep in mind, that the calender by default only shows the logged users calendar.
Honestly I have no idea or concept at hand, to make it look like the excel sheet. Maybe you could hardcode the CalenderEventsGallery to the time ranges, like:
["08:00 - 08:30", "08:30 - 09:00", "09:00 - 09:30",...]
and then show Subject, startTime, etc. only if start endTimes match the range.
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
