cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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)

Iweta_0-1596456516172.png

 

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

1 ACCEPTED SOLUTION

Accepted Solutions

Hello @Anonymous 

 

Please refer to my screenshot below:

Jcook_0-1596570511959.png

expression:

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

 

on the right side use the expression:

true

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

8 REPLIES 8
Jcook
MVP

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


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Anonymous
Not applicable

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.

Iweta_0-1596518492503.png

 

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.


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Anonymous
Not applicable

Hello @Jcook !

Please see below screenshot:

Iweta_0-1596531192551.png

Cheers

Iweta

Anonymous
Not applicable

@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
Not applicable

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

Hello @Anonymous 

 

Please refer to my screenshot below:

Jcook_0-1596570511959.png

expression:

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

 

on the right side use the expression:

true

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Anonymous
Not applicable

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,978)