Answered

Unable to send Flow Email out if SharePoint task Due Date is in the past and not completed

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am working with SharePoint task list and trying to build flow for the same. Basically if a task Due Date is less than or equal to today and if its not marked as completed then send an email out to the user to whom the task is assigned. Below is the task list screenshot.

So to overcome that I am using below condition formula: in flow.

@AND(lessOrEquals(formatDateTime(item()?['DueDate'], 'MM/dd/yyyy'),
formatDateTime(addDays(utcNow(), 0), 'MM/dd/yyyy')),equals(items('Apply_to_each')?['Checkmark'], 0))

Below is the flow screenshot as well:

The Flow runs successfully but the condition evaluates to false. As per the Task list screenshot, I have two overdue tasks, out of which Finance Report task is completed but Accounting report is not. So based on the condition and flow formula, it should have notified me for "Accounting report" task since its due date is in past and completed (checkmark) is also 0. Can someone help me correct this, might be making a minor mistake here.

Thanks in advance.

Categories:

Building flows

All responses (2)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Try to debug your condition to see which one fails.
Create 3 variables where you will store your result of each on of your AND statement, then you will see which one fails or contains the value.
Then you have your variables and the condition can then be changed to use the variables, this will also make your flow more readable
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

After spedning some time and doing some reaserch, I finally figured out.
I had to basically use the Task Status Value label to check its not completed.
First condition used is as follows: @not(equals(items('Apply_to_each')?['Status']?['Value'], 'Completed'))

Second Condition I added was: @lessOrEquals(formatDateTime(item()?['DueDate'], 'MM/dd/yyyy'),
formatDateTime(addDays(utcNow(), 0), 'MM/dd/yyyy'))

Flow screenshots below, hopefully it will help someone.