12-22-2020 06:55 AM - last edited 01-30-2023 09:34 AM
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 query filters to SharePoint 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 query SharePoint list with 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
#PowerAutomate #MultipleFilters #ODataQuery #GetItemsFilterQuery
watch?v=yeAnuTB85eg
Are you using the Manually Trigger a Flow button action before the get items action? If so, that is what I am running into as well. It won't pull anything from the manually trigger action (button).
So what I did was add a compose and use the sort function. It works but only for ONE column instead of multiple columns, unfortunately.
this literally does not work for me - I get ZERO, and I mean ZERO columns from my get items option!!!!
I'm using Get Files, not Get Items. When I turn on experimental features, there is nothing in the Filter Query Select an Item drop-down. None of my Library columns show, even though I selected the correct Site Address and Library Name. Any idea why this would be? I don't have any folders in my Document Library so I did not select a folder. Thanks.