Unanswered

When An Event is Modified (V3) - Workflow Help

(0) Share

Report

Posted on by 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

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

Event Cancelled

Recurrence: Interval (2), Frequency (Minute)
Get Events
Apply to Each: Output (Get Events)
Condition: Subject (Apply to Each) contains Canceled:
Yes: Delete Event (Apply to Each)
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.

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (0)

JefferNi66 19 on at

Like (0)

Report
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

Was this reply helpful? Yes No
ssuttonhsc 18 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
ssuttonhsc 18 on at

Like (0)

Report

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'])

Was this reply helpful? Yes No
JefferNi66 19 on at

Like (0)

Report
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

Was this reply helpful? Yes No
ssuttonhsc 18 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ssuttonhsc 18 on at

Like (0)

Report

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')}')

Was this reply helpful? Yes No
ssuttonhsc 18 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ssuttonhsc 18 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
CU01071826-0 2 on at

Like (0)

Report

In case anyone is still looking for this. I've dug into this and I can't find an easy way to do this in Power Automate at this time.

The email that lands in a users inbox doesn't contain the proposed times and the event being modified v3 doesn't expose this either.

according to this post: outlook - How to get proposed time using Microsoft Graph API? - Stack Overflow

it looks like this is stored in Exchange in the Extended properties. So it's out there if someone wants to code a connection there but I can't find an easy option in Power Automate to get this info.

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Hi CU01071826-0,

and what's your question - how to retrieve an extended property?

Was this reply helpful? Yes No