Flow designer - calendar integration

Jai2021
Tera Contributor

Hi all,
Greetings!
I have  a requirement ,that when a incident is on hold state and there is no response from him for some duration , I need to monitor the attendance of caller . whether he is on leave or not. For this I need to integrate user's calendar info. Could you please let me know

Thanks,
Abi

1 REPLY 1

MattiasJonsson
ServiceNow Employee
ServiceNow Employee

I would suggest looking in to the "Microsoft Exchange Online Spoke".

There's an action called "Look Up Out Of Office Settings".

It'll give you the OOO Message and Start/End date for a user.

 

So, in Flow Designer, create a new Flow.

Trigger on a Schedule, say every hour, 30 minutes, morning or whatever makes sense for your use case.

* Look Up Records (INCIDENT) where STATE=OnHold, UPDATED 72 hours ago (or what makes sense).

In this case, we'll find all incidents that hasn't been updated for 3 days, that are OnHold.

For Each INCIDENT

Use the "Look Up Out Of Office Setting" Action to get the OOO settings for the CALLER user.

If the "End Date" is to far ahead, do what you need - I choose to re-assign the ticket to no one.

 

find_real_file.png

 

The Action will give you these Data Pills to work with.

find_real_file.png

 

In my IF statement above, I used the "Scheduled End" - "Date/Time" pill.

I that and compared it to  the flows "Run Start Date/Time" datapill and added a transform to it, adding 1 day/24 hours. Meaning, if the person isn't back in office 24 Hours from Now, I will reassign the Ticket.

find_real_file.png

 

You would probably want to add some error checking and logics to this, but in general I believe it would work.

If helpful or correct, please indicate so!