Flow to send an e-mail 7 days before Due Date for particular conditions

[Anonymous]

Hello, I created a flow which supposed to send an e-mail to task Owner under conditions:

- Status = Open (this is option form drop down list on the SharePoint)

- Extended Due Date field is empty

Formula in Filter array is addDays(utcNow(),7)

MS Flow haven't found any errors in the flow, but the expression I get is always false, so it is not working correctly.

Could you please advise what am I missing?

Many thanks for your help!

Cheers

Iweta

[Jcook]

Hello @Anonymous 

Instead of using null for extended due date,

try using the expression empty()

the left side of your condition should be,

empty( <dynamic content> )   Is equal to   true

put your SharePoint extended due date dynamic content inside the ( ) in the empty expression

[Anonymous]

Hey @Jcook !

Thanks for your reply, I tried to do it like this at first but the problem is that I am not able to use dynamic content for the first selection box for some reason. Please see below screenshot. When I typed empty () there are only few options in Dynamic content and non of them is Extended due date.

[Jcook]

Hi @Anonymous 

Could you hover over the Extended Due Date dynamic content in the condition. A pop up should come up. Can you tell me that pop up.

(I hope that makes sense)

I will build an expression that can be used. But I want to confirm what the expression looks like.

[Anonymous]

Hello @Jcook !

Please see below screenshot:

Cheers

Iweta

[Anonymous]

@Anonymous I think @Jcook would be building the below expression. 

empty(items('Apply_to_each')?['Extended_x0020_Due_x0020_Date'])

Try the above expression, if you this works for you please mark this as a solution.

[Anonymous]

Hello @Anonymous ,

Yes, I tried it also, but on the screenshot above I am showing that it is not possible to build such expression. I am not able to nest Dynamic contents.

Cheers

Iweta

[Jcook · Accepted solution]

Hello @Anonymous 

Please refer to my screenshot below:

expression:

empty(items('Apply_to_each')?['Extended_x0020_Due_x0020_Date'])

on the right side use the expression:

true

[Anonymous]

Thanks a lot @Jcook  , I assumed that if there is no such Dynamic content available I cannot use it but as I copied it, it worked.

I had to adjust additionally the format of the date also for : equals(formatDateTime(items('Apply_to_each')?['Due_x0020_Date'],'yyyy-MM-dd'), addDays(utcNow(), 7,'yyyy-MM-dd')).

Thanks again & cheers

Iweta