SOLVED

Filter Users Calender entries - Shared Calendar

Silver Contributor

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

4 Replies

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

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

best response confirmed by LeonPavesic (Silver Contributor)

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

1 best response

Accepted Solutions
best response confirmed by LeonPavesic (Silver Contributor)