Flow to filter mail by the time received

[Godfather007]

Can someone help me write expression to filter emails which received in specific time range? example: new mail received from 5pm-8am forward to another mailbox,

[Jondoesflow]

Sure thing, stick this in the trigger condition

@And(less(formatDateTime(triggerOutputs()?['body/receivedDateTime'], 'hh:mm'), '08:00'),greater(formatDateTime(triggerOutputs()?['body/receivedDateTime'], 'hh:mm'), '17:00'))

Please thumbs up this reply and mark it as a solution if it has helped you.

Thanks !

[v-liwei-msft]

Hi @Godfather007  ,

1.You can use the trigger when a new email arrives (V3). 

2.Use condition to judge whether the reception time is greater than 18:00 or less than 8:00.

3.If the condition is true, proceed to the next step, if not, terminate the flow.

Best Regards,

Levi

[Godfather007]

Thanks for both answers! First one really looks good and working.

I am really new to this stuff, how to add check in this place if trigger condition FALSE when terminate flow?

 

[Monkeyman]

Hey. Trigger contains are cool

[Jondoesflow]

Hey @Godfather007 

Thanks for the reply. 

if the condition is FALSE the flow will not trigger at all. A trigger condition only triggers the initial step if the condition inside the trigger condition is true. 

if you can thumbs up my comment above and mark it as a solution. 

thanks

[Godfather007]

But strange thing if I try to test flow and get result TRUE - all good, but if I imitate FALSE result test dont giving Succeeded status and window stay "spin" 

 

[Godfather007]

With this trigger

@And(greater(formatDateTime(triggerOutputs()?['body/receivedDateTime'], 'hh:mm'), '05:00'),less(formatDateTime(triggerOutputs()?['body/receivedDateTime'], 'hh:mm'), '23:00')) 

How to add condition"if result false" when terminate flow?