10-15-2019 11:51 AM
10-15-2019 11:51 AM
Our department of ~120-130 users had been using a Leave Approval system based on a SharePoint Calendar since about 2008. It was originally built on a MOSS 2007 calendar that was later updated to SharePoint 2010. Not everyone loved it, but it was reliable and being (or at least looking like) an actual Calendar, people "got" it.
Knowing that such "classic" things are bound to be deprecated soon(ish), I resolved to replace this with a "modern" solution based on SharePoint Lists using PowerApps and Flow as the UI and workflow components. What I built works pretty darn well. But, users (many of them) balk at it because it's not an actual Calendar. No problem, I can still create Calendar-type views of modern lists, right? Well, yeah, I can, but they don't work reliably. Also, they don't allow a lot of other things, like overlaying other calendar info, connecting to Outlook, etc. I totally understand why they don't, but that doesn't mean I have to like it.
Anyway, this video (https://www.youtube.com/watch?v=_7gfHO18AHE&t=0s) summarizes the issues I'm faced with. Namely, the calendar views not consistently/reliably loading as calendar-type views and the ability (thanks to those blasted calendar views) for users to bypass the beautiful and easy to use PowerApp to add items directly to the list.
My big concern is that we have 2 or 3 other departments (one of similar size, another much smaller) that want the same solution. If there's a better way to do this that will circumvent some of these problems, I'm happy to explore alternatives.
10-16-2019 02:31 AM
HIi @ChadKealey ,
We explored this extensively with a client recently and the best option was to use the classic calendars. Not ideal as they dont work well on Mobile etc but it was the best solution. Any editing was done through Outlook desktop client and all users could sync the calendar should they wish to with permissions on the SharePoint list controlling who could edit it.
We can still use the modern webparts to show a summary of the up and coming events on other pages so that worked well, for example to show summaries of the events on the homepage of the Intranet for example.
Just need to wait for the modern calendar, which may be on the way.
10-21-2019 01:01 PM
In any case, the good news is that I was able to at least get the calendar views to show up consistently by changing the List experience to "Classic". The bad news is that this means no modern views at all of the list, and all of the classic views have a "New" button at the top which completely bypasses the App and the customized form for the list. I was also able to create a Flow that will run when a leave entry is created directly in the list (not the App) to notify the submitter and then delete the event.
It's just very frustrating to end users (and us IT folks) when functionality is lost during "upgrades" to products. Don't get me wrong, there's a lot of good stuff in the whole "modern" experience, but the things that are missing are the ones that folks then to latch onto.
10-21-2019 01:22 PM
Your only other option would be to use something not out of the box, I have not used this but here is a modern calendar from the SharePoint Framework. If you needed a hand implementing it PM me.