Today, I was asked how to get overdue tasks in a SharePoint task list. In SharePoint tasks are nicely marked red when they are due, but to query the tasks by due date in Flow is slightly harder, or maybe it is not that difficult after all.
Overdue tasks in SharePoint
In this post I describe the 2 steps. I could have done this in 1 step, but it is easier to explain things when I use 2.
Overdue tasks in Flow
In Flow I can use the following 2 steps
For the basics about OData Queries, please see my post about OData Queries in the Get Items action
The Today variable is initialized with the following expression. For more help on the FormatDateTime function please read formatDateTime in Power Automate in 2024 or The FormatDateTime function page on Microsoft Learn.
formatDateTime(utcNow(), 'yyyy-MM-dd')
and this variable is then used in the filter query of the get items action:
DueDate lt '@{variables('Today')}'
Discover more from SharePains
Subscribe to get the latest posts sent to your email.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@sharepains.com