{"id":18347,"date":"2022-01-11T09:43:17","date_gmt":"2022-01-11T17:43:17","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/"},"modified":"2022-01-11T09:43:17","modified_gmt":"2022-01-11T17:43:17","slug":"power-apps-ideas-new-enhancements-and-increased-capabilities","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/","title":{"rendered":"Power Apps Ideas: New enhancements and increased capabilities"},"content":{"rendered":"

After we announced public preview of Power Apps Ideas, including writing Power Fx formulas with natural language<\/a> and generating formulas from examples<\/a>, we continued tuning the design and improving our AI model to make Ideas work better for you. Today, we\u2019re happy to share some of the latest updates on Ideas with you.<\/p>\n

Transforming natural language to formulas<\/h2>\n
    \n
  1. Expanded support for more data sources<\/strong> \u2013 Data source connections are no longer limited to Dataverse; you can now use Power Apps Ideas with galleries and data tables connected to other data sources, such as SharePoint <\/strong>and Excel<\/strong>.<\/li>\n
  2. Supporting more ways to filter a data table\u00a0<\/strong>– More data querying scenarios are supported including filter by Choice columns, Yes\/No columns. Now you can try active ‘Contacts’ <\/em>in Ideas to filter by Contact status.<\/li>\n
  3. Improved understanding of natural language<\/strong> \u2013 In our efforts to provide an experience with language that really is \u201cnatural\u201d, we made significant improvements to our AI model to make it smarter and understand more natural input. For example, instead of typing \u2018Contacts\u2019 whose \u2018Full Name\u2019 starts with \u201cYvonne\u201d<\/em>, you can simply type Full Name starts with Yvonne<\/em> to get the same formula.<\/li>\n
  4. Enhanced UI for formula suggestions<\/strong> \u2013 The formula suggestions are now displayed in cards, and there is a greater focus on the natural language description of what the formula is doing, so it will be easier for makers to review and understand the results.<\/span><\/li>\n<\/ol>\n

    \"\"<\/p>\n

    Programming by example<\/h2>\n
      \n
    1. Increased region and language availability<\/strong> \u2013 Programming by example has rolled out to all the Power Apps regions and languages so more makers can benefit from it.<\/li>\n
    2. Improved formula results<\/strong> \u2013 We made significant improvements in our AI model to make the resulting formula suggestions less complex while still providing the same functionality. Simplifying complicated formulas not only makes it easier to understand and maintain the formula, but also significantly enhances performance.<\/li>\n<\/ol>\n

      \"\"<\/p>\n

      What\u2019s next for Ideas<\/h2>\n

      Transforming natural language to formulas:<\/strong><\/p>\n

        \n
      • Continue to add support of more scenarios including generating formulas to manipulate content of a label, changing color and visibility based on conditions, support filter by lookup columns.<\/li>\n
      • Continue to enhance the model so it can better understand natural language queries and provide more accurate suggestions.<\/li>\n
      • Improve the usability and discoverability of Ideas so it will become more handy and easier to find.<\/li>\n<\/ul>\n

        Programming by example:<\/strong><\/p>\n

          \n
        • Improve the model quality so it can generate accurate yet simple formulas.<\/li>\n
        • Improve the usability of Train with examples<\/strong>, so when the suggested formula doesn\u2019t meet your needs, you can easily tune the results by providing additional examples.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

          After we announced public preview of Power Apps Ideas, including writing Power Fx formulas with natural language and generating formulas from examples, we continued tuning the design and improving our AI model to make Ideas work better for you. Today, we\u2019re happy to share some of the latest updates on Ideas with you.<\/p>\n","protected":false},"author":205,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-apps-category":[1617,1664,1671],"power-apps-tag":[],"coauthors":[2183],"class_list":["post-18347","power-apps","type-power-apps","status-publish","hentry","power-apps-category-formulas","power-apps-category-uncategorized","power-apps-category-power-fx"],"yoast_head":"\nPower Apps Ideas: New enhancements and increased capabilities - 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-apps-ideas-new-enhancements-and-increased-capabilities\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Apps Ideas: New enhancements and increased capabilities - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"After we announced public preview of Power Apps Ideas, including writing Power Fx formulas with natural language and generating formulas from examples, we continued tuning the design and improving our AI model to make Ideas work better for you. Today, we\u2019re happy to share some of the latest updates on Ideas with you.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/\" \/>\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\/2022\/01\/NL2FX-C7-blog_updated.gif\" \/>\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=\"Norah Liu\" \/>\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-apps-ideas-new-enhancements-and-increased-capabilities\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/\",\"name\":\"Power Apps Ideas: New enhancements and increased capabilities - 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\/power-apps-ideas-new-enhancements-and-increased-capabilities\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/01\/NL2FX-C7-blog_updated.gif\",\"datePublished\":\"2022-01-11T17:43:17+00:00\",\"dateModified\":\"2022-01-11T17:43:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/01\/NL2FX-C7-blog_updated-scaled.gif\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/01\/NL2FX-C7-blog_updated-scaled.gif\",\"width\":2560,\"height\":1368,\"caption\":\"graphical user interface, application, Word\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/#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 Apps Ideas: New enhancements and increased capabilities\"}]},{\"@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 Apps Ideas: New enhancements and increased capabilities - 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-apps-ideas-new-enhancements-and-increased-capabilities\/","og_locale":"en_US","og_type":"article","og_title":"Power Apps Ideas: New enhancements and increased capabilities - Microsoft Power Platform Blog","og_description":"After we announced public preview of Power Apps Ideas, including writing Power Fx formulas with natural language and generating formulas from examples, we continued tuning the design and improving our AI model to make Ideas work better for you. Today, we\u2019re happy to share some of the latest updates on Ideas with you.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/01\/NL2FX-C7-blog_updated.gif","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Norah Liu"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/","name":"Power Apps Ideas: New enhancements and increased capabilities - 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\/power-apps-ideas-new-enhancements-and-increased-capabilities\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/01\/NL2FX-C7-blog_updated.gif","datePublished":"2022-01-11T17:43:17+00:00","dateModified":"2022-01-11T17:43:17+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/01\/NL2FX-C7-blog_updated-scaled.gif","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2022\/01\/NL2FX-C7-blog_updated-scaled.gif","width":2560,"height":1368,"caption":"graphical user interface, application, Word"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/power-apps-ideas-new-enhancements-and-increased-capabilities\/#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 Apps Ideas: New enhancements and increased capabilities"}]},{"@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\/18347"}],"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\/205"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=18347"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/18347\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=18347"}],"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=18347"},{"taxonomy":"power-apps-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-tag?post=18347"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=18347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}