Answered

Advanced Condition - testing for time greater than a certain time of the day

(0) Share

Report

Posted on by DeBuigny

So, I have been hammering away at a seemingly simple flow. The idea is, if i get an email after a certain time of the day, send an auto-response stating that all agents are off work, and for emergency support, follow a process..

So, I create the condition, testing the DateTimeReceived field like this:

@greater(substring(triggerBody()?['DateTimeReceived'],11,8), '17:00:00')

This is based on the following value in the incoming email object...

Received Time

2016-09-12T20:05:44+00:00

Yet, when an email pushes through the flow, I get the following message...

Reason

Code
ActionDependencyFailed
Message
The execution of template action 'Send_an_email' is skipped: dependant action 'Condition' completed with status 'Failed' and code 'ExpressionEvaluationFailed'.

I have looked around a bit, but was unable to find anything that helps me understand if this can work or not. I did find this, which suggests I am in the right neighborhood, but have been unable to get an email through the condition check.

Any ideas on what I am doing wrong? Any ideas on an alternative solution?

Thanks

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-yamao-msft on at

Like (0)

Report
Copy link

Link copied!

Hi DeBuigny,

I created a similar simple flow with you, when an email is arrived, if the condition is yes, reply to email. And I configured the condition in normal mode to “Date Time Received is greater than 12:00:00”. When I got an email, a response email would be sent. Then I try to configure the condition in Advanced mode, the flow failed and error message “Action Dependency Failed” occurred. It seems that when we configure condition in advanced mode, the flow would be failed.

For this issue, I would suggest you send a feedback by using the smile icon in flow.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
DeBuigny 5 on at

Like (0)

Report
Copy link

Link copied!

Is that how you officially report a bug? I tried that last week, but still haven't heard anything back.

This seems pretty simple. One thing that would be an excellent idea would be better feedback, like perhaps being able to hover over an expression and see the values behind them (particularly in an advanced condition)

Was this reply helpful? Yes No
Verified answer

kkurni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

This is known bug similar to this issue as well.
https://powerusers.microsoft.com/t5/Flow-Forum/How-do-you-use-AND/m-p/6929

We also tracked this incident #23150632 and will update you once it fixed (hopefully this week).

Thanks

Was this reply helpful? Yes No
kkurni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This fix has beed deployed.

Would you mind to retry again ?

thanks

Was this reply helpful? Yes No