Check Planner for incomplete tasks, send a single message if true

[vitiableloki]

Hello,

I am trying to write a flow that looks at a Planner for incompete tasks, then sends a single reminder message. I had it working where the flow would check if the complete date was equal to "@null", but because you can't put a terminate condition in an apply to each, it would then send a message for every task.

My next try was to put incomplete tasks into an array, then check if the array was empty. I have found advice for this, but it seems to be an outdated version because I can't create a single line in my condition, it only has the two input sections with a compare drop down in the middle.

In an effort to get around THIS problem, I tried to make an empty array to compare the task array to, but this is now returning an error.

[v-bacao-msft · Accepted solution]

Hi @vitiableloki ,

Could you share a screenshot of the Flow configuration?

If you want to check the incomplete task and send an email notification, please refer to the following method.

• Use HTML table to display unfinished tasks, initialize variables to store table content.
• Iterate through all the tasks and determine if value Completed By is equal to null. If so, append the task information to the array.
• Finally, use length() function to determine if the length of the array is 0. If it is not 0, send an email.

Image reference:

Expression reference:

length(variables('IncompleteTask'))

Hope it helps.

Best Regards,

[vitiableloki]

Thank you, @v-bacao-msft !

I ended up moving away from the array and instead created an integer that then counted the incomplete tasks and would send an email if the number was greater than 0.

But it's good to know that the array could have worked also!