Power Automate

Unanswered

After Hours Auto Reply Based on Calendar - Shared Mail Box

(0) Share

Report

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

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

BPSYD 18 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

rsaikrishna

3,703 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No

BPSYD 18 on at

Like (0)

Report

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

Was this reply helpful? Yes No

rsaikrishna

3,703 on at

Like (0)

Report

@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

Was this reply helpful? Yes No

BPSYD 18 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
BPSYD 18 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

rsaikrishna

3,703 on at

Like (0)

Report

@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