{"id":40091,"date":"2024-12-30T11:56:45","date_gmt":"2024-12-30T06:26:45","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=40091"},"modified":"2025-01-10T15:04:58","modified_gmt":"2025-01-10T09:34:58","slug":"enhancing-power-fx-formulas-with-copilot-in-canvas-apps","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2024\/12\/enhancing-power-fx-formulas-with-copilot-in-canvas-apps\/","title":{"rendered":"Enhancing Power Fx Formulas with Copilot in Canvas Apps"},"content":{"rendered":"<p><img decoding=\"async\" class=\"alignnone size-full wp-image-40099\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/Copilot-in-Canvas-Apps.png\" alt=\"Copilot in Canvas Apps\" width=\"1925\" height=\"1100\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/Copilot-in-Canvas-Apps.png 1925w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/Copilot-in-Canvas-Apps-300x171.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/Copilot-in-Canvas-Apps-1024x585.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/Copilot-in-Canvas-Apps-768x439.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/Copilot-in-Canvas-Apps-1536x878.png 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/Copilot-in-Canvas-Apps-660x377.png 660w\" sizes=\"(max-width: 1925px) 100vw, 1925px\" \/><\/p>\n<p><strong>Copilot<\/strong> is an AI-powered feature in Power Apps Studio that streamlines the process of creating and modifying Power Fx formulas in <a href=\"https:\/\/www.inogic.com\/services\/microsoft-power-platform\/microsoft-power-apps-canvas-app\/?utm_source=inogic-t-blog&amp;utm_medium=canvasapp&amp;utm_campaign=itblog&amp;utm_id=canvasapp\" target=\"_blank\" rel=\"noopener\"><strong>Canvas Apps<\/strong><\/a>. This innovative tool allows you to leverage natural language to interact with the formula bar, making it easier to build and understand formulas.<\/p>\n<p>With Copilot, you can:<\/p>\n<ul>\n<li><strong>Generate Power Fx Formulas<\/strong>: Simply describe what you want in simple layman&#8217;s language, and Copilot will create the corresponding formula for you.<\/li>\n<li><strong>Explain Existing Formulas<\/strong>: If you encounter a complex formula, Copilot can break it down and explain its functionality in natural language.<\/li>\n<\/ul>\n<p>This feature empowers both new and experienced app makers to work more efficiently, reducing the learning curve for Power Fx and accelerating app development.<\/p>\n<p><strong>Prerequisites:<\/strong><\/p>\n<ul>\n<li><strong>Power Apps<\/strong>: Microsoft Dataverse access with app creation privileges.<\/li>\n<li><strong><a href=\"https:\/\/www.inogic.com\/services\/ai-solutions\/microsoft-dynamics365-powerplatform-chatgpt-copilot-consulting-services\/\" target=\"_blank\" rel=\"noopener\">Copilot<\/a>:<\/strong> Copilot must be enabled within your environment and tenant to be accessible.<\/li>\n<\/ul>\n<p>Let\u2019s explore formula Columns in <strong>Canvas<\/strong> apps:<\/p>\n<p><strong>Step 1: Log in to Microsoft Dataverse i.e. <\/strong><a href=\"https:\/\/make.powerapps.com\" target=\"_blank\" rel=\"noopener\"><strong>https:\/\/make.powerapps.com<\/strong><\/a><\/p>\n<ul>\n<li>Create a Canvas app.<\/li>\n<li>Navigate to Settings &gt; Updates &gt; Preview and enable <strong>Copilot for formulas <\/strong>toggle.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-40093\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/1Copilot-in-Canvas-Apps.png\" alt=\"Copilot in Canvas Apps\" width=\"979\" height=\"579\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/1Copilot-in-Canvas-Apps.png 979w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/1Copilot-in-Canvas-Apps-300x177.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/1Copilot-in-Canvas-Apps-768x454.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/1Copilot-in-Canvas-Apps-660x390.png 660w\" sizes=\"(max-width: 979px) 100vw, 979px\" \/><\/p>\n<ul>\n<li>Once enabled, you will see the <strong>Create a formula (preview)<\/strong> option in the formula bar.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-40094\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/2Copilot-in-Canvas-Apps.png\" alt=\"Copilot in Canvas Apps\" width=\"1055\" height=\"199\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/2Copilot-in-Canvas-Apps.png 1055w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/2Copilot-in-Canvas-Apps-300x57.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/2Copilot-in-Canvas-Apps-1024x193.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/2Copilot-in-Canvas-Apps-768x145.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/2Copilot-in-Canvas-Apps-660x124.png 660w\" sizes=\"(max-width: 1055px) 100vw, 1055px\" \/><\/p>\n<p><strong>Step 2: Using Copilot to Create and Modify Formulas<\/strong><\/p>\n<ul>\n<li><strong>Generate a Formula with Natural Language<\/strong><\/li>\n<\/ul>\n<ol>\n<li>In the <strong>Copilot text box<\/strong>, type your request. For example: <em>&#8220;Show today&#8217;s day and date.&#8221;<\/em><\/li>\n<li><strong>Copilot<\/strong> will generate a formula based on your input.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-40096\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/3Copilot-in-Canvas-Apps.png\" alt=\"Copilot in Canvas Apps\" width=\"1096\" height=\"147\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/3Copilot-in-Canvas-Apps.png 1096w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/3Copilot-in-Canvas-Apps-300x40.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/3Copilot-in-Canvas-Apps-1024x137.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/3Copilot-in-Canvas-Apps-768x103.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/3Copilot-in-Canvas-Apps-660x89.png 660w\" sizes=\"(max-width: 1096px) 100vw, 1096px\" \/><\/p>\n<ol start=\"3\">\n<li>You can click <strong>Apply<\/strong> to insert the formula directly into the formula bar at the current position or adjust your request and resubmit it to receive an updated formula.<\/li>\n<\/ol>\n<ul>\n<li><strong>Use Existing Table Data for Formulas<\/strong><\/li>\n<\/ul>\n<p><strong>Copilot<\/strong> can also help you create formulas based on your existing table data. Just explain your requirements, and <strong>Copilot<\/strong> will create the formula for you.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-40097\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/4Copilot-in-Canvas-Apps.png\" alt=\"Copilot in Canvas Apps\" width=\"1001\" height=\"148\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/4Copilot-in-Canvas-Apps.png 1001w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/4Copilot-in-Canvas-Apps-300x44.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/4Copilot-in-Canvas-Apps-768x114.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/4Copilot-in-Canvas-Apps-660x98.png 660w\" sizes=\"(max-width: 1001px) 100vw, 1001px\" \/><\/p>\n<p>Microsoft has also enhanced <strong>Copilot&#8217;s<\/strong> functionality to support <strong>partial formula explanations<\/strong>.<\/p>\n<ul>\n<li>You can select a specific portion of a formula and click the <strong>Copilot icon<\/strong>.<\/li>\n<li>Choose <strong>&#8220;Explain this selection&#8221;<\/strong> to receive an explanation of the selected portion of the formula.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-40098\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/5Copilot-in-Canvas-Apps.png\" alt=\"Copilot in Canvas Apps\" width=\"1087\" height=\"209\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/5Copilot-in-Canvas-Apps.png 1087w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/5Copilot-in-Canvas-Apps-300x58.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/5Copilot-in-Canvas-Apps-1024x197.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/5Copilot-in-Canvas-Apps-768x148.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/12\/5Copilot-in-Canvas-Apps-660x127.png 660w\" sizes=\"(max-width: 1087px) 100vw, 1087px\" \/><\/p>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p><strong>Copilot<\/strong> in <strong>Canvas<\/strong> Apps makes creating and understanding Power Fx formulas easier by using natural language. It helps generate, modify, and explain formulas efficiently, reducing the learning curve for both new and experienced users. By streamlining the process, <strong>Copilot<\/strong> accelerates app development, allowing you to focus on building powerful apps without worrying about complex syntax.<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/services\/ai-solutions\/microsoft-dynamics365-powerplatform-chatgpt-copilot-consulting-services\/\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone wp-image-37491\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/02\/copilot.png\" alt=\"copilot\" width=\"753\" height=\"215\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/02\/copilot.png 700w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/02\/copilot-300x86.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/02\/copilot-660x189.png 660w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Copilot is an AI-powered feature in Power Apps Studio that streamlines the process of creating and modifying Power Fx formulas in Canvas Apps. This innovative tool allows you to leverage natural language to interact with the formula bar, making it easier to build and understand formulas. With Copilot, you can: Generate Power Fx Formulas: Simply\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2024\/12\/enhancing-power-fx-formulas-with-copilot-in-canvas-apps\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1954,2746],"tags":[3091],"class_list":["post-40091","post","type-post","status-publish","format-standard","hentry","category-canvas-apps","category-copilot","tag-copilot-in-canvas-apps"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/40091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=40091"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/40091\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=40091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=40091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=40091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}