Using OData to filter date in Microsoft Power Automate

In this video we see how to use OData to filter a SharePoint list on a date field inside Power Automate.
OData cheat sheet:

JSON beautifier:

This video contains:
- 0:00 Introduction
- 0:57 Setup and planning
- 2:20 Building the Flow
- 3:25 Understanding date format in Power Automate
- 5:34 Writing the OData filter statement and testing it
- 6:45 examining the JSON output in
- 8:04 Using "Select" action to trim the output and show only necessary fields
- 11:40 conclusion

To enroll in my Udemy courses see below link for discount vouchers

Contact me

[AlirezaAliabadi]

Please reply to this comment and let me know what you want to see for the future videos. The idea that wins the next week video, gets a free Udemy course voucher for the course that you pick.

[julien]

Thanks for sharing. For future videos, we would like to see how to filter a list of items based on the current quarter we're on and the current year.

[sashawarchoon]

What I really need right now is a video with comparison of Nintex Workflow Cloud and Power Automate

[ranimaharaj-sharma]

Well explained.. Easy to follow..Thanks..

[sindhukk]

Hi can you post video on how to compare two excel from SharePoint and get the difference and update the difference in new sheet using power automate

[mikeymouse]

Please do a video on a list that has a "start date" and "end date", and I want to filter any item where todays date falls in between those ranges.

[stevenvits]

Thanks Alireza, Cristal Clear As usual. What if the SP column is date and time? how must we manage that?

[aaaaa]

🙋‍♂️ thks, i want use filter to get Only folder, it s possible?

[danielwang]

Hi Ali, I want to make a flow, use get files(properties only), to get files created by myself or a specific person, and i tried Author eq "someone", but it doesnt work. How could i use filter query to do that?

[charlesdawnbeltran]

Great Video!
How to type the Filter Query if my column name has space or special character?

[yojie]

Thanks for your helpful video. I am trying to build a monthly report from a list that contains only the list items that were created from the previous month (e.g. August). What if my date column only contains yyyy-MM... How can I effectively filter the data? Thanks in advance for your answer :)

[arunthej]

Hi, your videos are very useful, could you please do integrations with teams channels

[ponoryponorak]

Something I struggle with is to filter data filed where data is blank/null. Any solution to that, please.

[sundrapillay]

Hi Alireza can you please do a Power app with dataverse