Power Automate OData Filter Query flow for SharePoint list

In this video on Power Automate OData Filter Query flow for SharePoint list, we will go through a step-by-step tutorial of how to apply OData Filter Query to SharePoint list Get Items action in flow. We will apply multiple filters of various column types Boolean, date, lookup, managed metadata, multi-choice columns etc.
We will also apply multiple filters using AND & OR operators and explore the new OData Query expression editor experience.
Important to use OData Filter Query in Power Automate flows to only work with the data required. This also helps in saving API calls.

Video covers the following:
✅ New Filter Query Editor
✅ Apply multiple filters
✅ Complex column types
✅ Contains query

Links:

Table of Contents:
00:00 - Intro
00:42- SharePoint list walkthrough
01:26 - Filter Query/OData Query & flow setup
02:15 - Flow Get Items only returns 100 records? How to increase the limit?
05:00 - Importance of performing OData Query to filter data in flow
05:40 - New Filter Query experience in Power Automate
06:20 - Filter Query on SharePoint text column - equals, beginswith and contains with multiple filters
13:34 - Filter Query on SharePoint date column - equals today and date range filters
17:21 - Filter Query on SharePoint Boolean column (yes/No)
18:26 - Filter Query on SharePoint Person column - equals & is empty
20:44 - Filter Query on SharePoint Number column - not empty
21:45 - Filter Query on SharePoint Choice column - equals and multiple filters
22:20 - Filter Query on SharePoint Lookup column - Value and Id - equals and multiple filters
23:57 - Filter Query on SharePoint Multi Choice column - equals and multiple filter conditions
25:52 - Filter Query on SharePoint Multi Select Lookup column - equals and multiple filter conditions
26:30- Filter Query on SharePoint Managed Metadata column - equals

#PowerAutomate #MultipleFilters #ODataQuery #GetItemsFilterQuery

[petrinnn]

This video is a Public Utility. Thanks a lot Reza

[thrilledbits]

Reza, not only do I enjoy your vids, I learn so much from them.... Much appreciated.

[sadabshaikh]

I don’t think anyone is covering this many scenarios in single video. Subscribed instantly. Great work. To the point and crisp. Very knowledgeable. I am new to power automate and just by following ur video I have developed few very interesting flows that helps my team. Cheers !!

[rajaamohammed]

Thanks for covering Power automate with SharePoint online. looking forward and excited to see more videos on SharePoint online capabilities with Power Platform.

[jasmingutierrez]

Im very impressed with your videos most especially this. This is really comprehensive. A lot of viewers will learn so much from you. Thank you for sharing your knowledge.

[ashleyprobert]

As always, thank you Reza. I was battling for hours looking for a solution on the Power Platform community. It took two minutes to solve my issue watching your video.

[abdulpasha]

Really surprised why this video does not easily show up is queries. This is just awesome. You have touched upon the topics that really needs to be explained. The nuances of OData Filter Query has been explained very well by you. Your tone an pace is exactly what is needed to explain something that is complex. God bless you Reza. Keep doing the great work.

[pierrickdefossez]

I was struggling for hours with a combination of OR and AND in my query and once again only you could bring me the right answer and even more answers that I needed.
You are so generous and such a pro!
Thank you Reza, keep going like this, you are the best ever!!!

[robofski]

The new interface for building ODATA queries will make life much easier :-) Great video as always.

[jasonthedogcatcher]

So very helpful as always, Reza. The way you present your content is clear, very thorough and easy to understand.

[Zim]

You truely are a master of Power Automate and of teaching it... ☝️

Thank you for the great video 👍

[billyprater]

This experimental feature just saved me a huge headache, and solved my problem in a couple minutes. Thank you!

[jamesclark]

I had no idea it was possible to do odata filter queries on Boolean columns. That piece of information alone made this tutorial really useful for me. Great video. Thank you 🙏

[liverlarson]

wish I'd found this video earlier this week. Suffered through finding a lot of information that was in this video through blog comments, trial and error, and also misdirection. Subscribed just because of the quality of this video.

[sahilthakur]

Simply awesome Reza. This is so cool.. there is always something new to learn in your videos like the lookup and manage metadata filters.

[Imwolfies]

Very helpful video and explanation for those of us whom are new to "Flows" and find it overwhelming.

[manikyakotni]

Thanks a lot Reza for the valuable content in your videos. Very nicely explained with every single detail. Appreciate your knowledge sharing. Great Work!!!

[antonioalmeida]

Thanks a lot. I was having trouble with boolean fields and now I'ld can go ahead. Excellent video.

[simonking]

Experimental Filter Queries!!! This just got a lot easier. thanks for the info!! I cannot believe I am finding this out almost 2 years late

[victorb]

Ви дууууже допомогли! Щиро вдячний! Лайк і підписка однозначно!