cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WebPortal
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
krootz
Solution Supplier
Solution Supplier

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

View solution in original post

fchopo
Super User
Super User

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
krootz
Solution Supplier
Solution Supplier

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

fchopo
Super User
Super User

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!

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!

Top Solution Authors
Top Kudoed Authors
Users online (4,751)