Power Automate Get Items OData Filter Query – Choice Column in SharePoint
Learn how to filter Choice type columns in SharePoint using OData Filter Query inside the Get Items action in Power Automate.
In this tutorial, I cover everything you need to know about working with Choice columns, including correct syntax, common mistakes, and real-world scenarios.
🔹 What you’ll learn in this video:
1. How SharePoint Choice columns store values internally
2. Filtering Choice columns using eq (equals) and ne (not equals)
3. Using multiple conditions with and / or operators
4. When startswith() and substringof() work (and when they don’t)
5. Common OData filter query errors and how to fix them
6. Best practices for writing clean and reliable filter queries
This video is especially helpful if you’ve faced issues where your flow runs successfully but returns empty results due to incorrect OData syntax.
Whether you’re a Power Automate beginner or intermediate user, this tutorial will help you confidently filter SharePoint list data using Choice columns.
#PowerAutomate
#SharePoint
#ODataFilterQuery
#ChoiceColumn
#GetItems
#MicrosoftFlow
#PowerPlatform
#Automation