Filter tasks from planner

[WebPortal]

My flow is connected to Planner and I want a filter to get only the tasks whose due date is today (the day the flow runs).

This is great, but the DueDate is returned as date/time and I just need the Date!

So, how to express the condition above?

[krootz · Accepted solution]

@WebPortal use this on your filter array startofDay(yourvalueduedate) is equal to  startofDay(utcNow())

[fchopo · Accepted solution]

Hello @WebPortal 

You should use the following expression to get the DueDate without the time:

formatDateTime(item()?['DueDateTime'],'yyyy-MM-dd')

On the left hand side of the comparison, you could get the current date without the time using the following expression:

formatDateTime(utcNow(),'yyyy-MM-dd')

Hope it helps!

Ferran