Filter Users Calender entries - Shared Calendar

[LeonPavesic]

Hello everyone,

I'm currently exploring the automation of an initiative proposed by one department in our company.

Our IT employees follow a schedule of 2-3 days in home office and 2-3 days in the office. The suggestion is to create a shared calendar accessible to the entire company, displaying which IT department members are working remotely or in the office.

The proposed workflow involves each IT employee adding a "whole day meeting - Home office" entry to their private calendar. Subsequently, these entries should automatically populate the shared calendar.

My question is: Can this be achieved using PowerShell and a scheduled task? Is there any other solution for that? How can I get started?

Kindest regards

Leon Pavesic

[#2]

Hi @LeonPavesic 

Are you using Exchange Online? It's already possible there

https://blog.icewolf.ch/archive/2023/05/17/work-hours-and-location/

I am not a big Fan of giving a ServiceAccount / ServicePrinciple Access to all the Calendars only to copy some Appointments from one Calendar to another.

And it's complex too:

- Changes of Appointments in the Source Calendar have to be tracked (move or delete)

- You need to take into account Appointment Series

If it's a small Number of Team Members is it not faster to just look at theyr Calendar?

If it is a big Number of Team Members the Shared Calendar will get messy and it will not be easy to figure out who is working from Home and not.

Kind Regards

Andres

[#3]

Hi @Andres-Bohren,

thank you for your input and the link to the Exchange Online blog. I agree with your concerns about using a Service Account/Service Principle with broad calendar access.

I initially also suggested using work hours as a potential solution, but the management team want to have a shared calender with automation.

Do you perhaps have a solution (or a reference) how to achieve this?

Kindest regards

Leon

[#4 · Accepted solution]

Hi @LeonPavesic 

Maybe this helps you on your way

https://blog.icewolf.ch/archive/2022/06/06/calendar-availability-freebusy-requests-with-microsoft-gr...

Kind Regards

Andres

[#5]

Hi @Andres-Bohren,

thanks for the answer and a reference link, it is a good starting point for me.

I am marking your answer as the best answer.

Kindest regards

Leon Pavesic