{"id":27795,"date":"2024-04-10T01:00:20","date_gmt":"2024-04-10T09:00:20","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/"},"modified":"2024-04-10T01:00:20","modified_gmt":"2024-04-10T09:00:20","slug":"power-fx-no-more-columns-names-in-text-strings","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/","title":{"rendered":"Power Fx: Column names escape double quotes"},"content":{"rendered":"<p>With Studio version 3.24042, rolling out to Preview this week, we are making a small syntax change to how column names are specified in some function arguments.\u00a0 Today they need to be wrapped in double quotes as a text string, but tomorrow they will not.\u00a0 The functionality of these functions is not changing in any way.\u00a0 We will automatically update the syntax in existing apps to reflect the new syntax &#8211; all existing apps will continue to operate as they do today.\u00a0 The change makes these functions consistent with other uses of column names, easier to use by no longer requiring logical names, and consistent with other Power Fx 1.0 hosts such as Copilot Studio, Power Automate Desktop, and Cards that have been using this new syntax for the last year.<\/p>\n<p>The impacted functions are:<\/p>\n<ul>\n<li><a href=\"https:\/\/learn.microsoft.com\/power-platform\/power-fx\/reference\/function-table-shaping\"><strong>AddColumns<\/strong>, <strong>DropColumns<\/strong>, <strong>RenameColumns<\/strong>, or <strong>ShowColumns<\/strong><\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/power-platform\/power-fx\/reference\/function-filter-lookup\"><strong>Search<\/strong><\/a><\/li>\n<li><strong><a href=\"https:\/\/learn.microsoft.com\/power-platform\/power-fx\/reference\/function-groupby\">GroupBy <\/a><\/strong><a href=\"https:\/\/learn.microsoft.com\/power-platform\/power-fx\/reference\/function-groupby\">or<\/a><strong><a href=\"https:\/\/learn.microsoft.com\/power-platform\/power-fx\/reference\/function-groupby\"> Ungroup<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/learn.microsoft.com\/power-platform\/power-fx\/reference\/function-datasourceinfo\">DataSourceInfo<\/a><\/strong><\/li>\n<\/ul>\n<p>For example, today, this formula adds a <strong>Miles<\/strong> column to a table, calculated from the <strong>Kilometers<\/strong> column:<\/p>\n<pre>AddColumns( Distances, \"Miles\", Kilometers * 0.6214 )<\/pre>\n<p>Tomorrow, write the formula with the new column name just as you would an existing column of the table, without double quotes:<\/p>\n<pre>AddColumns( Distances, Miles, Kilometers * 0.6214 )<\/pre>\n<p>It&#8217;s a subtle, but important difference.\u00a0 The use of a text string gave the impression that this name could be dynamic when it could not which led to maker confusion.\u00a0 It was inconsistent with other places where columns are used and defined, such as in the calculation at the end of the formula above and in a record definition.<\/p>\n<p>This change also enables you to use display names.\u00a0 If the <strong>Contacts<\/strong>\u00a0table is in Dataverse, you would have previously needed to use logical names to reference the columns:<\/p>\n<pre>Search( Contacts, TextInput1.Text, \"cr43e_firstname\", \"cr43e_lastname\" )<\/pre>\n<p>No longer, this can now be written much more elegantly as:<\/p>\n<pre>Search( Contacts, TextInput1.Text, 'First Name', 'Last Name' )<\/pre>\n<p>As shown here, use single quotes to insert a space or other special character in the name, as you would with variable names.<\/p>\n<p>But wait&#8230; Aren&#8217;t we going to break all the existing apps in the world?\u00a0 Power Apps has a mechanism to update app formulas automatically.\u00a0 This change is only a syntax change, the behavior of these functions does not change, making it perfect to use this mechanism.\u00a0 Your apps will be automatically updated to the new syntax when they are loaded into Studio at or after version 3.24042. In general, you don&#8217;t need to do anything except to start using the new syntax for new formulas.<\/p>\n<p>This is a part of <a href=\"https:\/\/powerapps.microsoft.com\/blog\/leverage-power-fx-1-0\/\">Power Apps moving to Power Fx 1.0<\/a> that we could do without needing a feature switch. There are two more functions, <strong><a href=\"https:\/\/learn.microsoft.com\/power-platform\/power-fx\/reference\/function-sort\">SortByColumns<\/a><\/strong> and <strong><a href=\"https:\/\/learn.microsoft.com\/power-platform\/power-fx\/reference\/function-validate\">Validate<\/a><\/strong> that will be getting similar treatment, but since those could introduce a breaking change we decided to do that under the upcoming Power Fx 1.0 compatibility switch.<\/p>\n<p>More examples:<\/p>\n<pre>DropColumns( Distances, \"Kilometers\" )\u00a0 \u00a0                       \/\/ before\nDropColumns( Distances, Kilometers )\u00a0 \u00a0                         \/\/ after<\/pre>\n<pre>RenameColumns( Distances, \"Kilometers\", \"Km\" )\u00a0 \u00a0               \/\/ before\nRenameColumns( Distances, Kilometers, Km )\u00a0\u00a0                    \/\/ after<\/pre>\n<pre>ShowColumns( Distances, \"Kilometers\" )\u00a0         \u00a0               \/\/ before\nShowColumns( Distances, Kilometers)\u00a0   \u00a0                        \/\/ after<\/pre>\n<pre>GroupBy( Sales, \"State\", \"Remainder\" )                          \/\/ before\nGroupBy( Sales, State, Remainder )                              \/\/ after<\/pre>\n<pre>Ungroup( GroupedSales, \"Remainder\" )                            \/\/ before\nUngroup( GroupedSales, Remainder )                              \/\/ after<\/pre>\n<pre>DataSourceInfo( IceCream, DataSourceInfo.Required, \"Flavor\" )   \/\/ before\nDataSourceInfo( IceCream, DataSourceInfo.Required, Flavor )     \/\/ after<\/pre>\n<p>If you have any concerns or questions, please leave them in the comments for this blog post.\u00a0 Thanks!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are making a small syntax change to how column names are specified in AddColumns, DropColumns, ShowColumns, RenameColumns, Search, GroupBy, Ungroup, and DataSourceInfo functions.\u00a0 Today they need to be wrapped in double quotes as a text string, but tomorrow they will not.\u00a0 We will automatically update the syntax in existing apps to reflect the new syntax.\u00a0 The change makes these functions consistent with other uses of column names, easier to use by no longer requiring logical names, and consistent with other Power Fx 1.0 hosts such as Copilot Studio, Power Automate Desktop, and Cards that have been using this new syntax for the last year.<\/p>\n","protected":false},"author":86,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-apps-category":[1617,1664,1671],"power-apps-tag":[1618,1672],"coauthors":[2104],"class_list":["post-27795","power-apps","type-power-apps","status-publish","hentry","power-apps-category-formulas","power-apps-category-uncategorized","power-apps-category-power-fx","power-apps-tag-formulas","power-apps-tag-power-fx"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power Fx: Column names escape double quotes - 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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Fx: Column names escape double quotes - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"We are making a small syntax change to how column names are specified in AddColumns, DropColumns, ShowColumns, RenameColumns, Search, GroupBy, Ungroup, and DataSourceInfo functions.\u00a0 Today they need to be wrapped in double quotes as a text string, but tomorrow they will not.\u00a0 We will automatically update the syntax in existing apps to reflect the new syntax.\u00a0 The change makes these functions consistent with other uses of column names, easier to use by no longer requiring logical names, and consistent with other Power Fx 1.0 hosts such as Copilot Studio, Power Automate Desktop, and Cards that have been using this new syntax for the last year.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/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=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Greg Lindhorst\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/\",\"name\":\"Power Fx: Column names escape double quotes - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"datePublished\":\"2024-04-10T09:00:20+00:00\",\"dateModified\":\"2024-04-10T09:00:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Apps\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Power Fx: Column names escape double quotes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power Fx: Column names escape double quotes - 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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/","og_locale":"en_US","og_type":"article","og_title":"Power Fx: Column names escape double quotes - Microsoft Power Platform Blog","og_description":"We are making a small syntax change to how column names are specified in AddColumns, DropColumns, ShowColumns, RenameColumns, Search, GroupBy, Ungroup, and DataSourceInfo functions.\u00a0 Today they need to be wrapped in double quotes as a text string, but tomorrow they will not.\u00a0 We will automatically update the syntax in existing apps to reflect the new syntax.\u00a0 The change makes these functions consistent with other uses of column names, easier to use by no longer requiring logical names, and consistent with other Power Fx 1.0 hosts such as Copilot Studio, Power Automate Desktop, and Cards that have been using this new syntax for the last year.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"width":950,"height":413,"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2023\/12\/Microsoft-logo_rgb_c-gray_950-1.webp","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Greg Lindhorst"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/","name":"Power Fx: Column names escape double quotes - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"datePublished":"2024-04-10T09:00:20+00:00","dateModified":"2024-04-10T09:00:20+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-fx-no-more-columns-names-in-text-strings\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Apps","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/"},{"@type":"ListItem","position":3,"name":"Power Fx: Column names escape double quotes"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/27795"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-apps"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/86"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=27795"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/27795\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=27795"}],"wp:term":[{"taxonomy":"power-apps-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-category?post=27795"},{"taxonomy":"power-apps-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-tag?post=27795"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=27795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}