Skip to main content
Power Automate
    • Connectors
    • Templates
    • 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
    • Share, Chat, Discuss
    • Community Chat & Announcements
    • Off Topic Discussion
    • 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
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Ideas
    • Power Automate Ideas
    • Report Issues
    • I Found A Bug
    • Community Engagement
    • Community AMA
    • Community Blog
    • Power Automate Community Blog
    • Community Blog Topic Suggestions
    • 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
    Helper III
    12717 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    RezaDorrani
    Dual Super User II RezaDorrani
    Dual Super User II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • 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:
    • Featured
    • Guided Learning
    • MBAS
    • On-Demand Webinars
    • Overview
    • Promotional
    • Tutorials
    Message 2 of 2
    13,846 Views
    3 Kudos
    Reply
    • All posts
    • Previous Topic
    • Next Topic
    AntoinetteB
    AntoinetteB Helper III
    Helper III
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • 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 1 of 2
    12,717 Views
    2 Kudos
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • 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

    • © 2022 Microsoft
    • Contact us
    • Trademarks
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Terms & conditions