{"id":110932,"date":"2018-02-28T09:38:08","date_gmt":"2018-02-28T17:38:08","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/advanced-flow-of-the-week-filtering-with-odata\/"},"modified":"2025-06-11T08:09:40","modified_gmt":"2025-06-11T15:09:40","slug":"advanced-flow-of-the-week-filtering-with-odata","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/advanced-flow-of-the-week-filtering-with-odata\/","title":{"rendered":"Advanced | Flow of the Week: Filtering Data with OData"},"content":{"rendered":"<p>OData (Open Data Protocol) is an OASIS standard that establishes best practices for designing RESTful APIs. One of the capabilities of OData is providing the ability to filter data using a standardized method across RESTful APIs, regardless if they are vendor provided or custom developed. Since Microsoft Flow&#8217;s connectors are built-upon RESTful APIs, many of our connectors support the ability to filter datasets server-side using OData. Some of the benefits of using OData include reducing the amount of data you are bringing into your flow, thus reducing the need to loop through a record set to find values of interest.<\/p>\n<p>In this blog post we are going to explore some popular OData filter expressions that you can use with some of our most popular connectors including SQL Server, Dynamics 365 and SharePoint Online.<\/p>\n<p><strong>Scenario #1: Get Rows from SQL Server and filter on Customer Name<\/strong><\/p>\n<p>We have the following Azure SQL database with a table that contains many work orders. From Microsoft Flow, we want to return only rows where the Customer Name is equal to &#8216;Contoso&#8217;<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/BaseQuery.png\" style=\"width: 700px; height: 408px;\"\/><\/p>\n<p>Inside of Microsoft Flow, we can add a <strong>SQL Server &#8211; Get Rows<\/strong> action. After providing a\u00a0<strong>\u200bTable name<\/strong>\u00a0we also have the ability to provide a\u00a0<strong>\u200bFilter Query<\/strong>\u200b.\u00a0 Inside this textbox we will provide a statement of <strong>CustomerName eq &#8216;Contoso&#8217;<\/strong>. The breakdown of this syntax is we need to provide the name of the field in the source system (i.e. SQL Server), followed by an operator. In this case we want to use <strong>= <\/strong>which is represented as <strong>eq <\/strong>in OData. Don&#8217;t use the = symbol otherwise you will get a runtime error. Lastly, we need to provide a value that we want to filter on. In this case we want to filter on\u00a0<strong>Contoso.<\/strong>\u200b Since it is a string, we need to wrap it in single quotes &#8216; &#8216;.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/SQLActionByCustomerName.png\" style=\"width: 600px; height: 331px;\"\/><\/p>\n<p>For the purposes of this blog post, we will wrap the results in HTML and send them via Office 365 Outlook connector so we can verify our results.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/CreateHTMLTableContoso.png\" style=\"width: 600px; height: 502px;\"\/><\/p>\n<p>After the flow executes, our we will see our results rendered successfully and only records with a <strong>Customer Name<\/strong> of <strong>Contoso <\/strong>are displayed.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/EmailResultsContoso.png\" style=\"width: 600px; height: 330px;\"\/><\/p>\n<p><strong>Scenario #2: Get Rows from SQL Server and filter on date<\/strong><\/p>\n<p>In this scenario we want to filter out older records and only retrieve records that have a Work Order Create Date that is less than 30 days old. To accomplish this we will also use a flow expression that will calculate the date, 30 days ago. We will then look for any records that have a Work Order Create Date that is greater than this date. The complete expression is: <strong>WorkOrderCreatedTime gt\u00a0addDays(utcnow(&#8216;yyyy-MM-ddTHH:mm:ssZ&#8217;),-30)<\/strong>. In this scenario, <strong>WorkOrderCreatedTime <\/strong>is our source field, <strong>gt\u00a0<\/strong>\u200brepresents our &#8216;greater than&#8217; operator and <strong>addDays(utcnow(&#8216;yyyy-MM-ddTHH:mm:ssZ&#8217;),-30)<\/strong> will calculate a date of 30 days prior.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/SQLWorkOrderFilter.png\" style=\"width: 700px; height: 236px;\"\/><\/p>\n<p>The results only include records that are less than 30 days old.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/EmailResultWorkOrderdate.png\" style=\"width: 600px; height: 507px;\"\/><\/p>\n<p><strong>Scenario #3: List Records from Dynamics 365 using an AND clause<\/strong><\/p>\n<p>\u00a0We will now move onto the Dynamics 365 connector where we can also use OData to filter out records. In this case we want to want to retrieve only records where the <strong>Account Name<\/strong> is <strong>Contoso Hospital AND <\/strong>the\u00a0<strong>City<\/strong>\u00a0is\u00a0<strong>Phoenix<\/strong>\u200b.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/DynamicsCRMAnd.png\" style=\"width: 800px; height: 276px;\"\/><\/p>\n<p>\u200bTo accomplish this we will use an\u00a0<strong>AND<\/strong>\u200b clause that will let us join two statements. The first being our (Account) <strong>name <\/strong>being equal to &#8216;<strong>Contoso Hospital<\/strong>&#8216; and secondly, our <strong>address1_city<\/strong> being equal to <strong>&#8216;Phoenix&#8217;<\/strong>. Our complete statement is <strong>name eq &#8216;Contoso Hospital&#8217; and address1_city eq &#8216;Phoenix&#8217;.<\/strong><\/p>\n<p style=\"text-align: center;\"><strong><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/DynamicsListAnd.png\" style=\"width: 600px; height: 295px;\"\/><\/strong><\/p>\n<p>When we execute our flow, we will see results only related to the Contoso Hospital in Phoenix.<\/p>\n<p style=\"text-align: center;\">\u00a0<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/EmailResultsContosoHospital.png\" style=\"width: 600px; height: 290px;\"\/><\/p>\n<p><strong>Scenario #4: List Records from SharePoint Online that Starts With<\/strong><\/p>\n<p><strong>\u200b<\/strong>In our final scenario, we are going to filter records from a custom SharePoint list. In this particular example, we have 4 records within a SharePoint List and we want to filter on all sites that start with the word &#8216;Contoso&#8217;<strong>\u200b<\/strong>\u200b.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/SharePointListInspections.png\" style=\"width: 600px; height: 300px;\"\/><\/p>\n<p>From a flow perspective, we will include the following OData query within our SharePoint action: <strong>startswith(Title,&#8217;Contoso&#8217;) <\/strong>where\u00a0<strong>Title\u00a0<\/strong>\u200bis the name of the column that we want to filter on and\u00a0<strong>\u200bContoso<\/strong>\u200b is the value we want to the column to start with.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/SharePointStartsWith.png\" style=\"width: 600px; height: 284px;\"\/><\/p>\n<p>\u200bWhen our flow runs, we will discover that only the <strong>Site Names<\/strong> that begin<strong>\u200b\u00a0<\/strong>the word\u00a0<strong>Contoso<\/strong>\u00a0are included in our results.<\/p>\n<p style=\"text-align: center;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/EmailResultsStartsWith.png\" style=\"width: 600px; height: 363px;\"\/><\/p>\n<p><strong>Conclusion<\/strong><\/p>\n<p>\u200bIn this blog post we covered 4 different OData queries across 3 different connectors including SQL Server, Dynamics 365 and SharePoint Online. While the syntax is a little different than what you are used to when using T-SQL, the power available to you unlocks new ways to filter your data in Microsoft Flow. Using OData to filter at the data source will reduce execution times as it reduces the need to loop through data sets in order to find specific records. So not only is this more efficient by sending smaller messages around, but it will also allow your flows to run faster.<\/p>\n<p>For more examples of OData filter expressions, please check out the following Microsoft <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/hh169248(v=nav.90).aspx\" target=\"_blank\" rel=\"noopener\">page<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A question that we frequently receive is how can I filter out data before it gets to Microsoft Flow?  The answer to this question is: OData filter queries.  In this blog post we are going to cover some of the most popular OData filter queries using some of our most popular connectors including SQL Server, Dynamics 365 and SharePoint Online.<\/p>\n","protected":false},"author":349,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[],"job-role":[],"product":[3474],"property":[],"topic":[3421],"coauthors":[2910],"class_list":["post-110932","post","type-post","status-publish","format-standard","hentry","audience-it-professional","product-power-automate","topic-application-modernization"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Advanced | Flow of the Week: Filtering Data with OData - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced | Flow of the Week: Filtering Data with OData - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"A question that we frequently receive is how can I filter out data before it gets to Microsoft Flow? The answer to this question is: OData filter queries. In this blog post we are going to cover some of the most popular OData filter queries using some of our most popular connectors including SQL Server, Dynamics 365 and SharePoint Online.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/advanced-flow-of-the-week-filtering-with-odata\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-28T17:38:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:09:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/BaseQuery.png\" \/>\n<meta name=\"author\" content=\"Kent Weare\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kent Weare\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/\"},\"author\":[{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/author\\\/keweare\\\/\",\"@type\":\"Person\",\"@name\":\"Kent Weare\"}],\"headline\":\"Advanced | Flow of the Week: Filtering Data with OData\",\"datePublished\":\"2018-02-28T17:38:08+00:00\",\"dateModified\":\"2025-06-11T15:09:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/\"},\"wordCount\":836,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/BaseQuery.png\",\"keywords\":[\"Connectors\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/\",\"url\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/\",\"name\":\"Advanced | Flow of the Week: Filtering Data with OData - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/BaseQuery.png\",\"datePublished\":\"2018-02-28T17:38:08+00:00\",\"dateModified\":\"2025-06-11T15:09:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/BaseQuery.webp\",\"contentUrl\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/BaseQuery.webp\",\"width\":997,\"height\":581,\"caption\":\"table\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/2018\\\/02\\\/28\\\/advanced-flow-of-the-week-filtering-with-odata\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advanced | Flow of the Week: Filtering Data with OData\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/#\\\/schema\\\/person\\\/a66d308251aebf9036a1e62c6bc2cd20\",\"name\":\"Kent Weare\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab342d9ec448e41bae6e48f7e21daf0dfc60f0df7c612a20e8dc99e0a468cfb9?s=96&d=mm&r=gcd0a495c06c9934b159bd99f16922ecd\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab342d9ec448e41bae6e48f7e21daf0dfc60f0df7c612a20e8dc99e0a468cfb9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab342d9ec448e41bae6e48f7e21daf0dfc60f0df7c612a20e8dc99e0a468cfb9?s=96&d=mm&r=g\",\"caption\":\"Kent Weare\"},\"url\":\"https:\\\/\\\/cm-edgetun.pages.dev\\\/en-us\\\/power-platform\\\/blog\\\/author\\\/keweare\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced | Flow of the Week: Filtering Data with OData - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/","og_locale":"en_US","og_type":"article","og_title":"Advanced | Flow of the Week: Filtering Data with OData - Microsoft Power Platform Blog","og_description":"A question that we frequently receive is how can I filter out data before it gets to Microsoft Flow? The answer to this question is: OData filter queries. In this blog post we are going to cover some of the most popular OData filter queries using some of our most popular connectors including SQL Server, Dynamics 365 and SharePoint Online.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/advanced-flow-of-the-week-filtering-with-odata\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2018-02-28T17:38:08+00:00","article_modified_time":"2025-06-11T15:09:40+00:00","og_image":[{"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/BaseQuery.png","type":"","width":"","height":""}],"author":"Kent Weare","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kent Weare","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/keweare\/","@type":"Person","@name":"Kent Weare"}],"headline":"Advanced | Flow of the Week: Filtering Data with OData","datePublished":"2018-02-28T17:38:08+00:00","dateModified":"2025-06-11T15:09:40+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/"},"wordCount":836,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/BaseQuery.png","keywords":["Connectors"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/","name":"Advanced | Flow of the Week: Filtering Data with OData - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/BaseQuery.png","datePublished":"2018-02-28T17:38:08+00:00","dateModified":"2025-06-11T15:09:40+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/#primaryimage","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/BaseQuery.webp","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/BaseQuery.webp","width":997,"height":581,"caption":"table"},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/02\/28\/advanced-flow-of-the-week-filtering-with-odata\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Advanced | Flow of the Week: Filtering Data with OData"}]},{"@type":"WebSite","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/a66d308251aebf9036a1e62c6bc2cd20","name":"Kent Weare","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab342d9ec448e41bae6e48f7e21daf0dfc60f0df7c612a20e8dc99e0a468cfb9?s=96&d=mm&r=gcd0a495c06c9934b159bd99f16922ecd","url":"https:\/\/secure.gravatar.com\/avatar\/ab342d9ec448e41bae6e48f7e21daf0dfc60f0df7c612a20e8dc99e0a468cfb9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab342d9ec448e41bae6e48f7e21daf0dfc60f0df7c612a20e8dc99e0a468cfb9?s=96&d=mm&r=g","caption":"Kent Weare"},"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/keweare\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/349"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110932"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110932\/revisions"}],"predecessor-version":[{"id":131107,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110932\/revisions\/131107"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110932"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=110932"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=110932"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=110932"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=110932"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=110932"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=110932"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}