Skip to main content
Power Automate
    • Connectors
    • Templates
    • Take a guided tour
    • Digital process automation
    • Robotic process automation
    • Business process automation
    • Process advisor
    • AI Builder
  • Pricing
  • Partners
    • Blog
    • Documentation
    • Roadmap
    • Self-paced learning
    • Webinar
    • Business process and workflow automation topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power Automate Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Automate
    • General Power Automate Discussion
    • Using Connectors
    • Building Flows
    • Using Flows
    • Power Automate Desktop
    • Process Advisor
    • AI Builder
    • Power Automate Mobile App
    • Translation Quality Feedback
    • Connector Development
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Galleries
    • Community Connections & How-To Videos
    • Webinars and Video Gallery
    • Power Automate Cookbook
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Community Engagement
    • Community AMA
    • Community Blog
    • Power Automate Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power Automate Community
    • Galleries
    • Webinars and Video Gallery
    • Re: Get items OData Filter Query Simplified

    Re: Get items OData Filter Query Simplified

    05-19-2021 12:16 PM

    AntoinetteB
    Advocate II
    17511 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    RezaDorrani
    RezaDorrani Community Champion
    Community Champion
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Get items OData Filter Query Simplified

    ‎12-22-2020 06:55 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

    Preview file
    416 KB
    Labels:
    • Labels:
    • Guided Learning
    • MBAS
    • On-Demand Webinars
    • Overview
    • Promotional
    • Tutorials
    Message 3 of 3
    18,640 Views
    3 Kudos
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    hyperbob0811
    hyperbob0811 Helper II
    Helper II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-30-2022 06:37 AM

    this literally does not work for me - I get ZERO, and I mean ZERO columns from my get items option!!!!

    Message 1 of 3
    1,755 Views
    0 Kudos
    Reply
    AntoinetteB
    AntoinetteB Advocate II
    Advocate II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-19-2021 12:16 PM

    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.

    Message 2 of 3
    17,511 Views
    2 Kudos
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign up free
    • Sign in

    Browse

    • Templates
    • Connectors
    • Partners

    Downloads

    • Mobile
    • Gateway

    Learn

    • Documentation
    • Learn
    • Support
    • Community
    • Give feedback
    • Blog
    • Pricing

    • © 2023 Microsoft
    • Contact us
    • Trademarks
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Terms & conditions
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices