When An Event is Modified (V3) - Workflow Help

[ssuttonhsc]

Hello all. I have created workflows for when an event is created and cancelled on an outlook calendar. Here are outlines of each workflow:

Event Created

1. When a new event is created (Trigger)
2. Get event: Item ID (When a new event is created)
3. Get calendar view of events: Start time (Get event), End time (Get event)
4. Filter Array: From (get calendar view of events), ID (When a new event is created) is not equal to ID (get event)
5. Condition: length(body('Filter_array')) is less than or equal to 0
6. Yes: respond to an event invite, ID (Get Event), Accept
7. No: respond to an event invite, ID (Get Event), Decline

Event Cancelled

1. Recurrence: Interval (2), Frequency (Minute)
2. Get Events
3. Apply to Each: Output (Get Events)
4. Condition: Subject (Apply to Each) contains Canceled:
5. Yes: Delete Event (Apply to Each)
6. No: Do Nothing

I am running into a wall when trying to create a workflow to respond to events, using the trigger "when an event is modified (v3)". General idea is to have it accept the modified event if there are no scheduling conflicts, and decline if a conflict exists. Any suggestions on how to structure this workflow? Thank you in advance for the help.

[JefferNi66]

Hi @ssuttonhsc ,

Would you like to make the flow to auto-accept modified events? I've made a flow for your reference:

Expression in Filter query:

(Start/DateTime ge '@{formatdateTime(triggerOutputs()?['body/start'], 'yyyy-MM-ddT00:00:00.0000000')}' AND Start/DateTime le '@{formatdateTime(triggerOutputs()?['body/start'], 'yyyy-MM-ddT23:59:00.0000000')}') OR (End/DateTime ge '@{formatdateTime(triggerOutputs()?['body/end'], 'yyyy-MM-ddT00:00:00.0000000')}' AND End/DateTime le '@{formatdateTime(triggerOutputs()?['body/end'], 'yyyy-MM-ddT23:59:00.0000000')}')

The logic is for events within the calculation duration that contain the start or end time of the current event. If the result is 0, this event does not conflict with any other event.

BR,

Jeffer

[ssuttonhsc]

Good Morning @JefferNi66. Thank you so much for the help! Yes, I am looking for the flow to auto-accept or decline modified events depending on if there is a conflict (i.e. accept if there is no conflict, and decline if there is one). I have time scheduled later this week to run additional tests, so I will get the workflow updated and report back from there. Hope you have a good day and stay safe!

[ssuttonhsc]

Hi @JefferNi66. I had some time today to conduct a few tests. I think the expression for length() in the condition I'm using is incorrect (listed below), as the result for the condition comes back as false. Could you please confirm how to structure the length() expression correctly? Thank you again for all of your help, please let me know if you have any questions.

Expression: 

length(outputs('Get_events_(V4)')?['body/value'])

[JefferNi66]

Hi @ssuttonhsc ,

I found the expression of filter query is not correct after a double check. I have modified to:

(Start/DateTime ge 'formatdateTime(triggerOutputs()?['body/start'], 'yyyy-MM-ddThh:mm:ss.0000000')' AND Start/DateTime lt 'formatdateTime(triggerOutputs()?['body/end'], 'yyyy-MM-ddThh:mm:ss.0000000')') OR (End/DateTime gt 'formatdateTime(triggerOutputs()?['body/start'], 'yyyy-MM-ddThh:mm:ss.0000000')' AND End/DateTime le 'formatdateTime(triggerOutputs()?['body/end'], 'yyyy-MM-ddThh:mm:ss.0000000')')

BR,

Jeff

[ssuttonhsc]

Good Morning @JefferNi66. Thank you, I appreciate your help! I will test the update expression on the filter query and post the results here.

[ssuttonhsc]

Good Afternoon @JefferNi66! I tested the expression with the updated filter query, and it still came up false. Could you please confirm if I am using the correct expression on the condition?

Current expression in condition: 

length(outputs('Get_events_(V4)')?['body/value'])

Current filter query:

(Start/DateTime ge '@{formatdateTime(triggerOutputs()?['body/start'], 'yyyy-MM-ddT00:00:00.0000000')}' AND Start/DateTime le '@{formatdateTime(triggerOutputs()?['body/start'], 'yyyy-MM-ddT23:59:00.0000000')}') OR (End/DateTime ge '@{formatdateTime(triggerOutputs()?['body/end'], 'yyyy-MM-ddT00:00:00.0000000')}' AND End/DateTime le '@{formatdateTime(triggerOutputs()?['body/end'], 'yyyy-MM-ddT23:59:00.0000000')}')

[ssuttonhsc]

Good Morning @JefferNi66. I wanted to follow up to confirm if the expression above was correct for the condition in the workflow. Please let me know if you have any questions. Hope you have a good day and stay safe.

[ssuttonhsc]

Hello all. Wanted to follow up, see if @JefferNi66 or anyone else can offer assistance on the most recent inquiry. Hope you have a good day and stay safe.