{"id":10840,"date":"2020-07-14T15:11:00","date_gmt":"2020-07-14T22:11:00","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/"},"modified":"2025-06-11T07:58:17","modified_gmt":"2025-06-11T14:58:17","slug":"announcing-column-comparison-through-fetchxml-sdk-and-odata","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/","title":{"rendered":"Announcing Column Comparison through FetchXML, SDK, and OData"},"content":{"rendered":"<p>We are happy to announce the availability of column comparison in CDS-based queries.\u00a0 This has been a common ask and pain point identified by our MVPs and ISVs for a while now and it&#8217;s exciting to provide this functionality.\u00a0 At this time,\u00a0 you will be able to use FetchXML, SDK or OData to perform column comparisons for the Common Data Service.\u00a0 Column comparisons will also work in the Power Apps expression language with CDS version 9.1.0000.19562 or later.<\/p>\n<p>The following links will provide more information of this new feature and how to use it.<\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/developer\/common-data-service\/column-comparison\">Use Column Comparison in Queries<\/a><br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/developer\/common-data-service\/webapi\/query-data-web-api#column-comparison-using-the-web-api\">Column comparison using the Web API<\/a><br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/developer\/common-data-service\/org-service\/use-conditionexpression-class#column-comparison-using-the-sdk-api\">Column comparison using the SDK API<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are happy to announce the availability of column comparisons. This has been a common ask from our MVPs and ISVs for a while now and it&#8217;s exciting to provide this functionality.<\/p>\n","protected":false},"author":189,"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":[3424],"job-role":[],"product":[3473],"property":[],"topic":[3421],"coauthors":[2055],"class_list":["post-10840","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-news","product-power-apps","topic-application-modernization"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Announcing Column Comparison through FetchXML, SDK, and 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\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Announcing Column Comparison through FetchXML, SDK, and OData - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"We are happy to announce the availability of column comparisons. This has been a common ask from our MVPs and ISVs for a while now and it&#039;s exciting to provide this functionality.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-14T22:11:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T14:58:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2023\/12\/Microsoft-logo_rgb_c-gray_950-1.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"950\" \/>\n\t<meta property=\"og:image:height\" content=\"413\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nathan Helgren\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Helgren\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\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\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/nathan-helgren\/\",\"@type\":\"Person\",\"@name\":\"Nathan Helgren\"}],\"headline\":\"Announcing Column Comparison through FetchXML, SDK, and OData\",\"datePublished\":\"2020-07-14T22:11:00+00:00\",\"dateModified\":\"2025-06-11T14:58:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/\"},\"wordCount\":119,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"keywords\":[\"Code first\",\"Dataverse\",\"Formulas\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/\",\"name\":\"Announcing Column Comparison through FetchXML, SDK, and OData - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\"},\"datePublished\":\"2020-07-14T22:11:00+00:00\",\"dateModified\":\"2025-06-11T14:58:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-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\":\"Announcing Column Comparison through FetchXML, SDK, and 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\/fa447f4b6af7600e43b061b4d9414e42\",\"name\":\"Nathan Helgren\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g750ad28c34befc14a76a8514583c06e4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g\",\"caption\":\"Nathan Helgren\"},\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/nhelgren\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Announcing Column Comparison through FetchXML, SDK, and 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\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/","og_locale":"en_US","og_type":"article","og_title":"Announcing Column Comparison through FetchXML, SDK, and OData - Microsoft Power Platform Blog","og_description":"We are happy to announce the availability of column comparisons. This has been a common ask from our MVPs and ISVs for a while now and it's exciting to provide this functionality.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2020-07-14T22:11:00+00:00","article_modified_time":"2025-06-11T14:58:17+00:00","og_image":[{"width":950,"height":413,"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2023\/12\/Microsoft-logo_rgb_c-gray_950-1.webp","type":"image\/png"}],"author":"Nathan Helgren","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Helgren","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/nathan-helgren\/","@type":"Person","@name":"Nathan Helgren"}],"headline":"Announcing Column Comparison through FetchXML, SDK, and OData","datePublished":"2020-07-14T22:11:00+00:00","dateModified":"2025-06-11T14:58:17+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/"},"wordCount":119,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"keywords":["Code first","Dataverse","Formulas"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/","name":"Announcing Column Comparison through FetchXML, SDK, and OData - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website"},"datePublished":"2020-07-14T22:11:00+00:00","dateModified":"2025-06-11T14:58:17+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-odata\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2020\/07\/14\/announcing-column-comparison-through-fetchxml-sdk-and-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":"Announcing Column Comparison through FetchXML, SDK, and 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\/fa447f4b6af7600e43b061b4d9414e42","name":"Nathan Helgren","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g750ad28c34befc14a76a8514583c06e4","url":"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d2f9dfa87b93c15d292251be00ccc5ac57b800311732ec01be7180e3c3e4094b?s=96&d=mm&r=g","caption":"Nathan Helgren"},"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/nhelgren\/"}]}},"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\/10840","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\/189"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=10840"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/10840\/revisions"}],"predecessor-version":[{"id":130575,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/10840\/revisions\/130575"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=10840"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=10840"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=10840"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=10840"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=10840"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=10840"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=10840"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=10840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}