Showing results for 
Search instead for 
Did you mean: 
New Member

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

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


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


  • Code
  • 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?




Accepted Solutions

This is known bug similar to this issue as well.


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



View solution in original post

Community Support
Community Support

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.

smile icon flow.PNG


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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)

This is known bug similar to this issue as well.


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



View solution in original post

This fix has beed deployed.


Would you mind to retry again ?



Helpful resources

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (46,098)