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

[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  

[v-yamao-msft]

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

[DeBuigny]

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)

[kkurni · Accepted solution]

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

[kkurni]

This fix has beed deployed.

Would you mind to retry again ?

thanks