Answered

Outlook Time Received

(0) Share

Report

Posted on by NoahB

How does one use the outlook received tiem condition. I want to make a flow that sends a text when I get an email during work hours but I can't quite figure out how to get the timing right. I've tried to have it go when time received contains monday,tuesday,wednesday,.... and I've tried time is greater that 8 and less than 5, but none of this seems to work. Any help on the formatting of this would be very much appreciated.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (1)

Report
Copy link

Link copied!
Hi @NoahB ,

Please refer to the following method to configure Flow.

Use dayOfWeek() function to determine which day of the week. 0 stands for Sunday and 6 stands for Saturday.

dayOfWeek(triggerBody()?['DateTimeReceived'])

Use expression below to get the HH of the Received Time.

int(formatDateTime(triggerBody()?['DateTimeReceived'],'HH'))

Use Condition to determine if the values obtained above are all in line with expectations, if so, send the message.

Image reference:

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
NoahB 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for your help however, after implementing this I keep getting flow failures:

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2589': 'The template language function 'contains' expects its first argument 'collection' to be a dictionary (object), an array or a string. The provided value is of type 'Integer'.'.

After doing some googling around I found that I needed to set the "Include Attatchments" tab to yes. I did that but I am still getting the failures, as well as the texts coming through outside of the designated times. Any insight would be very much appreciated.

Was this reply helpful? Yes No