But this Power Fx formula and syntaxes are a little complex to remember at all times. So, Microsoft has made things easier for developers where we can write the formulae with simple natural language which will transform them into Power Fx formulae. For the above example, we can also write the syntax in natural language as:<\/p>\n
- \n
- top 10 accounts<\/strong><\/li>\n<\/ul>\n
To use this natural language feature, we need to enable the Power Apps ideas.<\/strong><\/p>\n
Let\u2019s check out the steps.<\/strong><\/p>\n
First, open the Canvas App -> <\/strong>Click on Settings -> Upcoming features -><\/strong> Turn on Enable Ideas panel <\/strong>as shown below:<\/p>\n
![\"Canvas](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/1Canvas-App-Designer.jpeg\")
<\/p>\nOnce enabled, we will be able to see the Ideas<\/strong> tab on the Control\/Component as you can see on the Gallery Control.<\/p>\n
![\"Canvas](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/2Canvas-App-Designer.jpeg\")
<\/p>\nWe can use the following Power Apps Ideas for the below control\/components:<\/p>\n
- \n
- Gallery<\/li>\n
- Data table<\/li>\n
- Text box<\/li>\n
- Dropdown<\/li>\n
- Combo box<\/li>\n
- Text label<\/li>\n<\/ul>\n
You can get more information on the same at this link<\/a>.<\/p>\n
Let\u2019s take some examples where we can write formulae in natural language:<\/strong><\/p>\n
Example 1:<\/strong><\/p>\n
Let\u2019s see how to apply a filter on the search box using Power Apps Ideas.<\/strong><\/p>\n
Once we have added the list screen, the user may find that the search box is a sample text box without any functionality added to it as seen below<\/p>\n
![\"Canvas](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/3Canvas-App-Designer.jpeg\")
<\/p>\nSelect the Gallery and in the idea tab, we will be able to find the text box where the user has to provide the Ideas.<\/p>\n
1. In the text box add the statement as you usually type in normal text language. i.e. \u201csearch ‘Accounts’ where either ‘Address 1: ZIP\/Postal Code’ or ‘Account Name’ contains TextSearchBox1<\/strong>\u201d as shown below. Above, we are telling that the Account is the table and we need to find the resulting form ‘Address 1: ZIP\/Postal Code’ <\/strong>and ‘Account Name <\/strong>once the user has provided the input in the search box.<\/p>\n
![\"Canvas](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/4Canvas-App-Designer.jpeg\")
<\/p>\n2. Once we click on Get ideas<\/strong>, it will provide the appropriate result that the user is looking for as displayed below<\/p>\n
![\"Canvas](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/5Canvas-App-Designer.jpeg\")
<\/p>\n3. Click on apply and the Power FX formula will be applied to gallery control automatically as follows<\/p>\n
![\"Canvas](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/6Canvas-App-Designer.jpeg\")
<\/p>\n4. Run the app and search for the account name or postal code that you want to display in the list<\/p>\n
![\"Canvas](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/7Canvas-App-Designer.jpeg\")
<\/p>\n![\"Canvas](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/8Canvas-App-Designer.jpeg\")
<\/p>\nExample 2:<\/strong><\/p>\n
1. Let\u2019s say we want to change the format of the \u2018CreatedOn<\/strong>\u2019 field (Date and time) from \u201cm\/d\/yyyy <\/strong>\u201cto \u201cmmmm\/d\/yyyy<\/strong>\u201d. For that right click on the CreatedOn<\/strong> label -> Show ideas<\/strong> -> Text formatting<\/strong>.<\/p>\n
![\"Canvas](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/9Canvas-App-Designer.jpeg\")
<\/p>\n2. Now we can see that the Ideas panel is showing the current format of the created <\/strong>date field. To change the format, enter the example April 14, 2022, <\/strong>in the Desired format <\/strong>field and click on the This will automatically generate the formula that we are looking for as visible in the below screenshot.<\/p>\n
![\"Canvas](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/10Canvas-App-Designer.jpeg\")
<\/p>\n3. Click on Apply and this expression will be applied to the whole gallery as shown below<\/p>\n
![\"\"](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/11-canvas-app.jpeg\")
<\/p>\nConclusion <\/strong><\/h2>\n
In this way, we can write many such formulae in the natural language that will be transformed into Power Apps Fx in the Canvas App application designer using Power Apps Ideas<\/p>\n
![\"Canvas](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/Microsoft-Power-Platform-3.png\")
<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"It is common knowledge that while developing any canvas app we need to use many functions like sorting, filtering, etc. Here, we need to know the Power Fx formulae to apply any sorting or filtering on the controls. For example, there is a Gallery control, if we want to filter the records in the gallery\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"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],"tags":[2666],"class_list":["post-33865","post","type-post","status-publish","format-standard","hentry","category-canvas-apps","tag-canvas-app-designer"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33865","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\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=33865"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33865\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=33865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=33865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=33865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}