cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

Filter tasks from planner

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).

WebPortal_1-1605899404906.png

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

 

So, how to express the condition above?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Solution Supplier
Solution Supplier

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

View solution in original post

Super User II
Super User II

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')

 

formatdatetime.png

Hope it helps!

Ferran 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

View solution in original post

2 REPLIES 2
Solution Supplier
Solution Supplier

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

View solution in original post

Super User II
Super User II

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')

 

formatdatetime.png

Hope it helps!

Ferran 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (7,996)