Power Automate Get Items Filter Query Date for SharePoint List | ODATA Filter Query by Todays Date

when the user has a bulk SharePoint list with many items, then it will be hectic to filter the data. In this kind of scenario, the Power Automate Get items filter query will be useful to filter out the data.

In this Power Automate video tutorial, we'll explore advanced techniques for filtering items based on date fields using the "Get Items" action. Mastering date queries can significantly enhance your workflow automation. Here's what I will cover:
1. Today's Date:
Learn how to filter items where the date field matches today's date. Ensure your flows stay relevant and responsive.
2. Less Than Today's Date:
Understand how to retrieve items with a date field less than the current date. Useful for finding upcoming or overdue tasks.
3. Greater Than Today's Date:
Explore filtering items with a date field greater than today's date. Perfect for identifying future events or tasks.
4. Created Date:
Dive into filtering items based on their creation date. Ideal for scenarios where tracking the origin of items is crucial.
5. Filter Query on Last 7 Days:
Implement a dynamic filter to fetch items created or modified in the last 7 days. Keep your workflow focused on recent changes.
==========================================
Visit a complete tutorial on:
==========================================
Related Video Tutorials:
==========================================
Subscribe to Our YouTube Channel for more video tutorials
==========================================
Playlists for You:
==========================================
Do Visit Our Website
#microsoftpowerplatform #powerautomate #microsoftflow #sharepoint #datetime #function #date #today

[arthurdias]

Hello, what if I want to filter only records modifed 30 days ago?
I was using this formula but it is retrieving me error:
formatDateTime(addDays(utcNow(), -30), 'yyyy-MM-dd')

[chenchen-ys]

thanks your video, i came into one issue, one column name is lookup type, the internal name Field=Lab_x0020_Name_x003a_Country, i try the eq 'xx', bad request: Column does not exist. how can i fix this ?

[piyushborkar]

Hi what about past month data what would be the expression

[grantwylie]

Thank you. We have an annual leave summary requirement which runs from Aug-Aug. With a column of start date and column finish date -For a dynamic recurring year date period, each year, eg Aug to Aug - what could you use for the filter query? ie what were the annual leave request list items within the past year but from August (I need it be recurring for each year ) thank you!