ACALENDAR SYNCHRONISIEREN MIT OUTLOOK MANUAL
ACALENDAR SYNCHRONISIEREN MIT OUTLOOK CODE

The expression I used here is: addHours(outputs('Start_Time'),1) But converting time zones is something that I will address in a separate post. This is the wrong way of doing things of course.

ACALENDAR SYNCHRONISIEREN MIT OUTLOOK CODE

to correct this time I used the following code in a compose action. The time that I get for my shifts are 1 hours out. As we will see later on not all actions use the same time zone method. Time in this flow is going to be a bit of a pain. My current time zone is British Summer time and this will need to be corrected. if(equals(items('Apply_to_each_Shift')?,null), items('Apply_to_each_Shift')?, items('Apply_to_each_Shift')?) To get my start time I’m using the following expressions that will pickup the start time form the shared shift or draft shift. this means that sometimes I find my data for a shift in a json property sharedShift and sometimes in draftShift. Once a shift has been shared the format of the data changes. In Shifts, you can have draft shifts and shared shifts. I’m now going to collect the start and end time from the shift. This especially helps to debug the flow as the compose action displays my data for the shift that I’m processing. Now that I’ve got hold of the calendars and the Shifts I can step through my data.įor ease of use I’m now adding my shift by setting a compose action to items('Apply_to_each_Shift')

That way we avoid one of those unwanted apply to each steps making the overall Synchronize Shifts to Outlook Calendar events process that bit easier to understand.Īll I have to do is use the following expression: first(body('Filter_Calendar')) Process the shifts The compose action after the filter is there to turn the array into a single item. It’s possible to process all of these calendars and use a condition but why not filter the unwanted ones out. The Get Calendars will give us an array of calendars, even if we only have one calendar that we are interested in. But later in my flow I will filter out the right one. This is a bit of a clumsy action as I can’t filter it to the one that I want. Then i’m getting my calendars in Outlook for the service account that runs my flow. So I set the end time to 4 weeks from now using the following formatDateTime expression that then I managed to get a lot more shifts. This is not what I want.īy setting the end time as well this problem goes away. Most likely the most recently updated shifts. The odd thing however is that this will now only give me up to 50 shifts somewhere in the future. So I will restrict the action by setting the From start time using the utcNow function.

I’m also not interested in anything in the past. It will just depend on how much you have to schedule and how many shifts you want to synchronize. But this can of course be increased if you need to synchronize shifts beyond the first 50. In the below example of List all shifts, I’ve limited the number of shifts to 50. I will not synchronize shifts that are older. Then I want get all the shifts for everybody starting from today. Just hit that enter key once and you will have the job done! Getting the shifts The new Line action may look empty but it is not. For this I’m adding a compose action and rename this to New Line. Later on in the flow we will need to handle new lines.

ACALENDAR SYNCHRONISIEREN MIT OUTLOOK MANUAL

I’m running this flow on a schedule of every 30 minutes.ĭuring the development I used a manual starting flow, but in the long run I want to run this flow on a regular basis. Just imaging if he could synchronize shifts to outlook in an automated way! The TriggerĪll flows in Power Automate start with a trigger and this synchronize shifts flow example is no different. The events that I will create in this flow are owned by the service account and then the assignee is invited to the event. Now he would manually create a diary entry in the calendar and share that with the persons expected to complete the shift. Sets the start and end time and then that is it. My colleague stores the task details in the notes of a shift.

My response was of course, Yes! Power Automate can do all of that!įirst of all it is important to understand how Shifts is used before we look at synchronizing shifts. Shifts is an app in Microsoft Teams that can be used to schedule work for your team members. Today, one of my HybrIT Services colleagues asked me if it was possible to create calendar entries for people after their work was scheduled in Shifts.

Checking if a Calendar event already exists.

Acalendar synchronisieren mit outlook