After Hours Auto Reply Based on Calendar - Shared Mail Box

[BPSYD]

Hi,

Wonder if you can help.... 

I'm trying to create a flow that will send out an auto reply based on an OOF set in a calendar. (currently personal as i can't add shared calendar to flow)   

I think i have it all correct expect for the filtering of the get events. Please could I have some help on this.

[BPSYD]

Tried the following filter query with not much luck: 

(start le @{body('Convert_time_zone')} and end ge @{body('Convert_time_zone')} and isAllDay eq true and (showAs eq ‘Oof’ or showAs eq ‘Busy’))

and top count set to one. because i only really need to know the status of the calendar for when the original email has come through.

[rsaikrishna]

@BPSYD 

In the Get Events, you can use following filter to get Out of Office events:

showAs eq 'Oof'

Reference blog:

https://bilot.group/articles/automatic-out-of-office-reply-activation-with-microsoft-flow/

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[BPSYD]

Thanks @rsaikrishna! Does this not show the status on all events? Do I not have to filter it further to get the current "status". In other words to check the calendar if there are any entries in this moment? 

Thanks,

Bryan 

[rsaikrishna]

@BPSYD 

If we have multiple events on the same day and also I am OFF for the day, then we see all of them. But, the Get Events (V4) with Filter Query will only returns items when ShowAs as Oof. 

If you run the flow once, you will see all the properties in the Get Events (V4). 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[BPSYD]

@rsaikrishna  got it. But its still pulling all events I want to know the status of the current event if any. 

That way my auto reply is based on and fired off on calendar entries.

Thanks,

Bryan 

[BPSYD]

No win on this one. 

Flow does not have a way of showing your current status of "showAs" or if you currently have or are in an event to then trigger off the email. 

[rsaikrishna]

@BPSYD 

If you do not find the properties in the out put of Get Events (V4), then there is no option to do it. I am sure there may be a request for this enhancement in the system. I may need to search in the community forum. 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[VictorIvanidze]

Have a look at http://ivasoft.com/scheduledoofflow.shtml