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:
Flow limits and configuration – https://docs.microsoft.com/en-us/power-automate/limits-and-config
Power Platform API call limits – https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations
Expression Series – https://aka.ms/learnexpressions
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
Comments are closed.