![\"Power](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/11\/Power-Fx-Formulas.png\")
<\/p>\n<\/p>\n
The Comment-Generated Formulas feature in Power Apps lets you create Power Fx formulas directly from code comments. By typing `\/\/` or \u2018\/*\u2019 followed by a natural language instruction, Copilot can generate a relevant Power Fx formula tailored to your app\u2019s context. You can choose to accept Copilot\u2019s suggestion or edit the formula, using comments as convenient documentation for each formula.<\/p>\n
This tool is now available and supports multiple languages beyond English, making it accessible for users worldwide. Languages like French, Spanish, and German are now supported, allowing you to direct Copilot in your preferred language. To see the list of supported languages, refer to the official documentation on Supported Languages<\/a>.<\/p>\n Prerequisites<\/strong><\/p>\n Copilot must be enabled in your environment. For additional guidance, refer to the documentation on how to enable or disable Copilot in Power Apps<\/a>.<\/p>\n The new formula bar is enabled by default. If the Copilot menu isn\u2019t visible, review your app settings in Power Apps<\/a> Studio<\/a>:<\/p>\n With these settings, you\u2019ll be ready to take full advantage of Copilot’s AI-powered formula generation in Power Apps, simplifying formula creation with natural language.<\/p>\n In Power Apps, Copilot allows you to generate Power Fx formulas directly from comments entered in the formula bar. Simply type a comment using `\/\/` or `\/*`,<\/strong> and Copilot will suggest a formula based on your comment.<\/p>\n Example: \/\/ Calculate total expenses<\/em><\/strong><\/p>\n In the example below, I’ve created an expense calculator app in Power Apps and used a code comment to generate a formula to calculate pending expenses.<\/p>\n Example Code Comment:<\/strong><\/p>\n \/\/ Concatenates a dollar sign with the formatted sum of costs from the LineItems2 table where the ReportID is found in the PendingReports table, but only if that sum is greater than zero; otherwise, it shows zero.<\/p>\n AI-Generated Formula:<\/strong><\/p>\n If(Sum(Filter(LineItems2, ReportID in ShowColumns(PendingReports, ID)), Cost) > 0, “$” & Text(Sum(Filter(LineItems2, ReportID in ShowColumns(PendingReports, ID)), Cost), “$#,##0.00”, “en-US”), “$0”)<\/p>\n To use the suggested formula, press \u2018Tab\u2019<\/strong> to accept it. You can continue typing to adjust the formula as needed.<\/p>\n If Copilot doesn\u2019t offer a suggestion, it means it couldn\u2019t generate a formula based on your comment. Try rephrasing the comment to improve results. It\u2019s recommended to enclose elements you want to include in your formula in quotes, such as “PendingReports.ID” and \u201cLineItems2\u201d.<\/p>\n The Generating Power Fx formula using Copilot now supports multiple languages! To see the list of supported languages, refer to the official documentation on Supported Languages<\/a>.<\/p>\n Let\u2019s try the example in Spanish:<\/p>\n Example Code Comment:<\/strong><\/p>\n \/\/ Concatena un signo de d\u00f3lar con la suma formateada de costos de la tabla LineItems2 donde el ReportID se encuentra en la tabla PendingReports, pero solo si esa suma es mayor que cero; de lo contrario, muestra cero.<\/p>\n By using this comment in Spanish, Copilot generated the same formula as in the original example.<\/p>\n Copilot in Power Apps makes creating Power Fx formulas easier than ever by generating them directly from comments. With multi-language support, users can now work in their preferred language, improving accessibility. This feature simplifies formula creation, enhances documentation, and speeds up app development. Enable Copilot in your environment and let it streamline your Power Apps experience.<\/p>\n The Comment-Generated Formulas feature in Power Apps lets you create Power Fx formulas directly from code comments. By typing `\/\/` or \u2018\/*\u2019 followed by a natural language instruction, Copilot can generate a relevant Power Fx formula tailored to your app\u2019s context. You can choose to accept Copilot\u2019s suggestion or edit the formula, using comments as\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":11,"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":[2746,44],"tags":[2705,1337,2672],"class_list":["post-39672","post","type-post","status-publish","format-standard","hentry","category-copilot","category-power-apps","tag-copilot","tag-power-apps","tag-power-fx"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/39672","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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=39672"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/39672\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=39672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=39672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=39672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
![\"Generating](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/11\/1Generating-Power-Fx-Formulas.jpg\")
<\/p>\n\n
![\"Generating](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/11\/2Generating-Power-Fx-Formulas-1.png\")
<\/p>\nCreate Power Fx Formulas Instantly from Comments <\/strong><\/h2>\n
\n
\n
![\"Generating](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/11\/3Generating-Power-Fx-Formulas.jpg\")
<\/p>\n![\"Generating](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/11\/4Generating-Power-Fx-Formulas.jpg\")
<\/p>\nNow Available with Multi-Language Support<\/strong><\/h2>\n
![\"Generating](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/11\/5Generating-Power-Fx-Formulas.jpg\")
<\/p>\nSome limitations when generating formulas from code comments:<\/strong><\/h2>\n
\n
Conclusion<\/strong><\/h2>\n
![\"Microsoft](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/12\/Microsoft-Power-Platform.gif\")
<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"