Power Platform Community Forum Thread Details

Creating a Flow which blocks off my calendar after it is more than 50% full

Hello Power Users,

I am currently developing a Flow which I have set to block out my calendar after my day is more than 50% populated.

The one thing I am struggling to overcome is having it count only the time spent in meetings out of an 8-5 workday, as currently it is counting every event for that day, even if there is overlap of events on a single time slot.

Another issue is preventing an unwanted loop, where when this flow creates an event it triggers this process to run again. My solution was to have it only run if I myself haven't created the event, and also by limiting the max minutes to less than 480. Looking for other suggestions to this.

The steps I am having it run are:

When a New Event is created by someone other than myself begin the flow
Retrieve the event that was just created
Creating a startTime variable at the beginning of that event's day
Creating an endTime variable for the end of that event's day
Retrieving the calendar view of events which fall under both start and end time variable
creating a totalSum variable and starting it with 0
Running a For each condition to run through all events for that day and converting the time difference of the start and end time of the event into ticks, and then converting the ticks to minutes, incrementing the minutes of each event into totalSum
Putting it through a condition where if totalSum is between 300 and 480 minutes and if it's not created by myself then move to If Yes
If Yes the flow then triggers the event to start at the beginning of the workday and end at the end of the workday