{"id":126125,"date":"2024-11-12T13:55:55","date_gmt":"2024-11-12T21:55:55","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?post_type=power-apps&p=126125"},"modified":"2024-11-12T13:55:56","modified_gmt":"2024-11-12T21:55:56","slug":"creating-and-explaining-formulas-with-copilot-now-even-easier","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/","title":{"rendered":"Creating and explaining formulas with Copilot now even easier"},"content":{"rendered":"\n

We are excited to announce the launch of the new\u00a0“Create a formula”<\/strong>\u00a0preview feature in Power Apps, designed to make building and editing Power Fx formulas easier and more intuitive than ever before.<\/p>\n\n\n\n

Copilot can now also explain partial formulas, which is especially useful for longer formulas where you need an explanation on a specific part of the code.<\/p>\n\n\n\n

And to top it off, Copilot in the formula bar will now support more languages, enabling most of our worldwide makers to take advantage of these powerful features.<\/p>\n\n\n\n

Create a formula with ease<\/h3>\n\n\n\n

With the new “Create a Formula” feature, you can now generate Power Fx formulas directly from natural language. Simply select the Copilot button, ask it to create a formula, type your desired action in plain language, and the AI will suggest the appropriate formula and append it wherever the cursor was located when the request was made after you click apply. <\/p>\n\n\n\n

This functionality is perfect for both seasoned developers and those new to Power Apps, providing a seamless experience for all users. Remember, formulas are specific to the control and property that is selected, and some actions require working across controls and properties.<\/p>\n\n\n\n

\"Animated<\/figure>\n\n\n\n

Additionally, the maker can use the thumb up\/down icons to provide feedback that will help to make the product and AI interactions better over time. By sharing the prompt and response along with your feedback, it helps us understand what we can do to improve.<\/p>\n\n\n

\"\"<\/figure>\n\n\n\n

To enable the Create a Formula Capability, turn on the “Copilot for formulas” flag in Canvas App Settings > Updates > Preview.<\/p>\n\n\n

\"\"<\/figure>\n\n\n\n

Explain a partial formula<\/h3>\n\n\n\n

In addition to creating formulas, we’ve expanded our formula explanation capability to include the ability to explain a partial formula. <\/p>\n\n\n\n

By selecting a formula before clicking the Copilot icon, instead of the “Explain this formula” option, you have the option to “Explain this selection” and get a plain language explanation of what the selected portion of the formula does. <\/p>\n\n\n\n

The selection does not have to be precise either, as the Copilot knows when to include context surrounding the selection in order to provide an explanation. This is particularly useful for understanding long or complex formulas that benefit from a more granular explanation.<\/p>\n\n\n\n

\"Animated<\/figure>\n\n\n\n

Worldwide expansion<\/h3>\n\n\n\n

Copilot support in the formula bar now supports 18 languages. To find out if your language is supported, or to learn more, take a look at the product documentation<\/a>.<\/p>\n\n\n\n

Let us know<\/h3>\n\n\n\n

We hope you find these new features as exciting and useful as we do. We look forward to hearing your feedback and seeing the innovative ways you use them in your apps. Stay tuned for more updates and enhancements in Power Apps!<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Power Apps introduces the new ‘Create a Formula’ feature, making it easier than ever to build and edit Power Fx formulas. Plus, now you can explain partial formulas too!<\/p>\n","protected":false},"author":313,"featured_media":126175,"comment_status":"open","ping_status":"closed","template":"","power-apps-category":[1549,1575,1671],"power-apps-tag":[1550,1574,1672],"coauthors":[2262],"class_list":["post-126125","power-apps","type-power-apps","status-publish","has-post-thumbnail","hentry","power-apps-category-building-power-apps","power-apps-category-copilot","power-apps-category-power-fx","power-apps-tag-building-power-apps","power-apps-tag-copilot","power-apps-tag-power-fx"],"yoast_head":"\nCreating and explaining formulas with Copilot now even easier - 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\/creating-and-explaining-formulas-with-copilot-now-even-easier\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating and explaining formulas with Copilot now even easier - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Power Apps introduces the new 'Create a Formula' feature, making it easier than ever to build and edit Power Fx formulas. Plus, now you can explain partial formulas too!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-12T21:55:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/11\/createaformulablog.png\" \/>\n\t<meta property=\"og:image:width\" content=\"605\" \/>\n\t<meta property=\"og:image:height\" content=\"321\" \/>\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=\"Warren Bryant\" \/>\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\/creating-and-explaining-formulas-with-copilot-now-even-easier\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/\",\"name\":\"Creating and explaining formulas with Copilot now even easier - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/11\/createaformulablog.webp\",\"datePublished\":\"2024-11-12T21:55:55+00:00\",\"dateModified\":\"2024-11-12T21:55:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/11\/createaformulablog.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/11\/createaformulablog.webp\",\"width\":605,\"height\":321,\"caption\":\"Create a Formula Dialog\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/#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\":\"Creating and explaining formulas with Copilot now even easier\"}]},{\"@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":"Creating and explaining formulas with Copilot now even easier - 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\/creating-and-explaining-formulas-with-copilot-now-even-easier\/","og_locale":"en_US","og_type":"article","og_title":"Creating and explaining formulas with Copilot now even easier - Microsoft Power Platform Blog","og_description":"Power Apps introduces the new 'Create a Formula' feature, making it easier than ever to build and edit Power Fx formulas. Plus, now you can explain partial formulas too!","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/","og_site_name":"Microsoft Power Platform Blog","article_modified_time":"2024-11-12T21:55:56+00:00","og_image":[{"width":605,"height":321,"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/11\/createaformulablog.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Warren Bryant"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/","name":"Creating and explaining formulas with Copilot now even easier - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/11\/createaformulablog.webp","datePublished":"2024-11-12T21:55:55+00:00","dateModified":"2024-11-12T21:55:56+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/11\/createaformulablog.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/11\/createaformulablog.webp","width":605,"height":321,"caption":"Create a Formula Dialog"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/creating-and-explaining-formulas-with-copilot-now-even-easier\/#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":"Creating and explaining formulas with Copilot now even easier"}]},{"@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\/126125"}],"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\/313"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=126125"}],"version-history":[{"count":3,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/126125\/revisions"}],"predecessor-version":[{"id":126173,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/126125\/revisions\/126173"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media\/126175"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=126125"}],"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=126125"},{"taxonomy":"power-apps-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-tag?post=126125"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=126125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}