Filter Query for SharePoint Get Items action in Power Automate MADE EASY!

In this Power Automate video, we will look at how to simplify writing ODATA filter queries (SharePoint REST requests) for SharePoint Get Items or Get Files action in flows. We will cover various odata query examples with different column types - Text, Choice, Dates, Person, Lookup & various comparison types equals, null, less than, greater than, etc.

Power Automate odata filter query SharePoint list video includes:
✅ Power Automate filter query syntax made easy with New Filter Query Expression Editor (GUI)
✅ Filter query on starts with, equals, search (contains) etc.
✅ Power Automate odata filter query examples
✅ Power Automate filter query multiple conditions
✅ Flow filter query on SharePoint Text, Choice, Lookup, Date columns, Person columns
✅ Sort and filter SharePoint data in Power Automate
✅ Contains, Not Equal, Not Null, Null (empty) check, Choice fields, Lookup Fields, Person columns, etc.
✅ Flow SharePoint filter query date current month query & dynamic odata queries
✅ Flow SharePoint filter query dynamic - get items for manager or direct reports in Active Directory
✅ Power Automate filter query contains
✅ Numeric comparisons, String comparisons & Date and time functions / Date ranges

Helpful Links 🔗:

Another video covering Filter Query in SharePoint Get Items in Power Automate flows with different scenarios:

Use OData query operations in SharePoint REST requests

#SharePoint #PowerAutomate #PowerPlatform #flow

Table of Contents:
00:00 - Introduction to Filter Query ODATA for SharePoint in Power Automate
00:35 - Flow filter query scenario
01:14 - Flow filter query ODATA challenges
01:49 - Flow filter query simplified with new modern editor feature for writing ODATA filters
02:23 - Flow Equals filter query for SharePoint List Text Column
03:15 - Flow StartsWith filter query for SharePoint List
03:40 - Flow Search (substringof) filter query for SharePoint List
04:25 - Get SharePoint column internal name for filter queries
05:04 - Supported ODATA filter queries in Power Automate (SharePoint REST requests)
05:40 - Flow filter query on SharePoint Choice Column
06:25 - Flow filter query on SharePoint Lookup Column
07:17 - Flow filter query multiple conditions
08:00 - Flow filter query on Person type column
09:08 - Flow filter query check empty or null column values
09:51 - Sorting and filtering SharePoint list rows in power automate
10:19 - Dynamic filter query in flow - Get user manager data
11:05 - Flow dynamic filter query - Get direct reports data from SharePoint for user
14:21 - Flow filter query on SharePoint Date column (get items overdue - due date is less than today)
14:56 - Flow filter query on given date range (check for current month and start of next month data)
16:46 - Flow filter query on calculated columns (not supported)
16:50 - Subscribe to Reza Dorrani channel

🤝 Let’s connect on social:

[rhonyroyce]

Your videos are detailed yet succinct with lucid flow. The examples chosen for the concepts are great applicable solutions. Your channel is an absolute go-to whenever I’m looking for ways to implement an idea/functionality in PowerApps. Thank you!

[benjaminjones]

Another superb video Reza, so thank you.
I was just think about globally how many businesses you are indirectly helping, by helping there employees build solutions to everyday business process issues.

[hermitthelog]

You are a life saver my friend. I've been wrestling with syntax errors for an hour now with no luck. Thank you!

[melodyydunn]

Reza, You are Brilliant! Thank you! I always look for your training first. You explain things so clearly and concisely that it makes it easier to understand. Thank you for your time and effort in helping us "Citizen Developers" understand these new technologies!

[IvyElm-ot]

WOW!! I've been trying to get a flow to work all day and couldn't find an answer. 5 seconds into your video, I was able to make it work. Thank you!! I've subscribed!!

[MohammadAli-tsev]

Great great...many of the times I got stuck with multi filters...now things are clear. .thank you Reza bhai...

[TheFunkBros]

Been looking for hours how to do the lookup columns, 5 minutes here and its working... earned you a subscribe dude. Good stuff. Thanks.

[drben]

This is a very detailed video that has assisted me with my task! Thank you. Well done!

[stlaurent]

Fantastic video, clear and easy to follow, covering many business cases

[keithwhittaker]

Thank you Reza. Once again you answered my question. I really do appreciate your videos, they make me look like I know what I'm talking about.

[Wcbssg]

Good Tutorial Video. I want to ask if that filter query can be done if that is connect to Excel for Business

[felxelgato]

Thank you Reza for all you do. You've made my learning of SharePoint enjoyable.

[pepito]

Great video!
You really helped me.
I couldn't create the OData filter query, due to my column name, wich had spaces in the name, like "Fecha de consulta".
I was like one hour trying and looking for how to solve my problem, but I decided to watch a video, and fortunately I got the solution in here.
Many thanks!!!

[AnandhAdhithan]

Excellent tips on SP oData filters query. Really helpful in development scenarios!

[oluwatobipaul]

Thank you Reza. I learnt some new and shorter tricks like viewing the field name for each field, also working with the choice column in the experimental view

[stephanielachman]

Thanks for your tips about how to turn on the advanced window for the filter query.

[philipcoltharp]

Your aesthetics on your presentation are so smooth;best I've seen. Others should mimic you. Ditto to the other's compliments of your video's content.

[tmcpang]

Reza, I love the way to explain stuff. It's short and clear. Thank you so much for creating video like this for us.
I have a question related to querying a SharePoint list from Power Automates; how do I query against a multi-value choice field?

Kudos ❤ for the hint with joining with ' or ' the Selected mail Array of report to users and generating an ODATA query as an output. Thanks Reza!

[DavidSmithBali]

You've just fixed a problem I've been stuck on for 3 days. I messed up 100 live entries of my sharepoint list