{"id":699,"date":"2022-03-03T21:57:07","date_gmt":"2022-03-04T03:57:07","guid":{"rendered":"http:\/\/ninmonkeys.com\/blog\/?p=699"},"modified":"2022-03-03T22:10:44","modified_gmt":"2022-03-04T04:10:44","slug":"how-do-i-get-started-in-power-apps-with-cheat-sheets","status":"publish","type":"post","link":"https:\/\/ninmonkeys.com\/blog\/2022\/03\/03\/how-do-i-get-started-in-power-apps-with-cheat-sheets\/","title":{"rendered":"How Do I Get Started with Power Apps? With Cheat Sheets"},"content":{"rendered":"\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"695\" height=\"585\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2022\/03\/PowerApps-\u2510-Query-Previews-Inside-Formulas-2022-02-10-1.gif\" alt=\"\" class=\"wp-image-2121\"\/><figcaption>&#8211; Moving your cursor around will change the tooltips<br>&#8211; It shows the data type, and the function<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>The Documentation Is Great<\/p>\n\n\n\n<ul><li>Check out the <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-filter-lookup#examples\">examples for <code class=\"\" data-line=\"\">Filter<\/code> <\/a>, you can experiment without configuring a data source<\/li><\/ul>\n\n\n\n<ul><li>Top Level, New To Apps entry point: <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/\">https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/<\/a> <\/li><\/ul>\n\n\n\n<h2>Sample Data Without a Data Source &#8211; Declaring Inline Tables<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"807\" height=\"413\" src=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2022\/03\/image-5.png\" alt=\"\" class=\"wp-image-2129\" srcset=\"https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2022\/03\/image-5.png 807w, https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2022\/03\/image-5-300x154.png 300w, https:\/\/ninmonkeys.com\/blog\/wp-content\/uploads\/2022\/03\/image-5-768x393.png 768w\" sizes=\"(max-width: 807px) 100vw, 807px\" \/><\/figure>\n\n\n\n<p>Step1: Choose Insert -&gt; Button.<\/p>\n\n\n\n<p>Step2: Set the button&#8217;s <code class=\"\" data-line=\"\">OnSelect<\/code> property to this.<\/p>\n\n\n\n<p>Step3: Alt left click the button, and it&#8217;ll create the table. You&#8217;re still in edit mode.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\" data-line=\"\">ClearCollect(\n    Customers,\n    Table(\n        { Name: &quot;Fred Garcia&quot;, Company: &quot;Northwind Traders&quot; },\n        { Name: &quot;Cole Miller&quot;, Company: &quot;Contoso&quot; },\n        { Name: &quot;Glenda Johnson&quot;, Company: &quot;Contoso&quot; },\n        { Name: &quot;Mike Collins&quot;, Company: &quot;Adventure Works&quot;},\n        { Name: &quot;Colleen Jones&quot;, Company: &quot;Adventure Works&quot;} \n    )\n)<\/code><\/pre>\n\n\n\n<h2>The &#8220;I know how to program, Give me the good stuff!&#8221; Section<\/h2>\n\n\n\n<p>Here&#8217;s the main links I recommend<\/p>\n\n\n\n<ul><li>These are the top level references, with tons of sub-links <ul><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/formula-reference\">Formulas:<\/a> main functions<\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/reference-properties\">Controls and Properties<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/controls\/properties-color-border\">Color and Borders<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/controls\/properties-core\">Core<\/a>: visibility and interactions<\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/working-with-variables#types-of-variables\">Variables<\/a> : local and global scopes<\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/working-with-variables#use-a-collection\">Collections<\/a> <\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/working-with-data-sources#working-with-tables\">Using  Tables<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/operators\">Operators<\/a><\/li><\/ul><\/li><li>Frequently Used<ul><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/keyboard-shortcuts\">Keyboard Shortcuts<\/a><\/li><\/ul><ul><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-filter-lookup#examples\">Filter<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-clear-collect-clearcollect\">Collect, Clear, ClearCollect<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-set#examples\">Set<\/a> (global) and <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-updatecontext\">UpdateContext<\/a> (local) variables<\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-ismatch#regular-expressions\">Regular Expressions<\/a> support named capture groups<\/li><\/ul><\/li><li>Testing:<ul><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/monitor-overview\">Monitor Debugger<\/a> and <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/test-studio\">Test Studio<\/a><\/li><\/ul><ul><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/accessibility-checker\">Accessibility Checker<\/a><\/li><\/ul><\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Documentation Is Great Check out the examples for Filter , you can experiment without configuring a data source Top Level, New To Apps entry point: https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/ Sample Data Without a Data Source &#8211; Declaring Inline Tables Step1: Choose Insert -&gt; Button. Step2: Set the button&#8217;s OnSelect property to this. Step3: Alt left click the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[70,65,109,106,13,14],"tags":[10,110,44,107,15],"_links":{"self":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/699"}],"collection":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/comments?post=699"}],"version-history":[{"count":16,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/699\/revisions"}],"predecessor-version":[{"id":2138,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/posts\/699\/revisions\/2138"}],"wp:attachment":[{"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/media?parent=699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/categories?post=699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ninmonkeys.com\/blog\/wp-json\/wp\/v2\/tags?post=699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}