Using ticks and shifts connector

[craigmk1987]

Hello, I've been trying to build a holiday counter using shifts. I've been searching and struggling to use "ticks" to create a datediff style calculation in my holiday output notification. It seems that when I try to access ticks, I get a "null" error. Seemingly what I think I'm trying to do seems simple, but I'm not getting anywhere. I can't seem to access the ['shared shift']?['startDateTime'] element to create the ticks count. 

My flow is:

Here is where I'd like to put the count in, so that the table output in the email will display the number of days of holiday:

[v-bacao-msft · Accepted solution]

Hi @craigmk1987 ,

You could use expression directly to get the start time and end time.

item()?['sharedTimeOff/startDateTime']

item()?['sharedTimeOff/endDateTime']

Best Regards,