{"id":9728,"date":"2023-11-03T09:11:34","date_gmt":"2023-11-03T08:11:34","guid":{"rendered":"https:\/\/via-internet.de\/blog\/?p=9728"},"modified":"2023-11-03T09:14:12","modified_gmt":"2023-11-03T08:14:12","slug":"power-apps-cookbook","status":"publish","type":"post","link":"https:\/\/via-internet.de\/blog\/2023\/11\/03\/power-apps-cookbook\/","title":{"rendered":"Power Apps | CookBook"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Components<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Button<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Enable Button depending on multipe Conditions (e.g. Dropdowns are selected):<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Set OnChange of Coomponents:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Set DisplayMode of Component:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">If(IsBlank(Radio1.Selected.Value), DisplayMode.Disabled, DisplayMode.Edit)<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">DropDown<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Populate Dropdown<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Switch(\n    &lt;Dropdown>.Selected.Value,\n    \"Value A\", \"a\",\n    \"Value B\", \"b\",\n    \"Value C\", \"c\",\n    &lt;Dropdown>.Selected.'name '\n) <\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Populating dropdown which depends on selection of a control<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">OnVisible property of Screen:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ClearCollect(defaultDemands, Defaults(Demands));\nClear(defaultDemands);\nPatch(defaultDemands, Defaults(Demands), {Name:\"Select Product\"})\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Items property of dropdown you can choose between the two collections depending on the state of the radio selection:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">If(\n    IsBlank(&lt;Radio>.Selected.Value),\n    defaultDemands,\n    Filter(ProductDemands, ProductValue = &lt;Radio>.Selected.Value)\n)<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">JSON<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Extract Value from JSON<br><\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">Match(\n    jsonString, \n    \"\"\"elementName\"\": *\"\"(?&lt;value>[^\"\"]+)\"\n).value<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Styling<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Color<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Set Color of Button:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Define a variable with the desired color in App.OnStart<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"864\" height=\"42\" src=\"https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2023\/11\/image-2.png\" alt=\"\" class=\"wp-image-9731\" srcset=\"https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2023\/11\/image-2.png 864w, https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2023\/11\/image-2-300x15.png 300w, https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2023\/11\/image-2-768x37.png 768w\" sizes=\"auto, (max-width: 864px) 100vw, 864px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Set BasePalletColor of Component to this variable:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"694\" height=\"42\" src=\"https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2023\/11\/image-1.png\" alt=\"\" class=\"wp-image-9730\" srcset=\"https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2023\/11\/image-1.png 694w, https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2023\/11\/image-1-300x18.png 300w\" sizes=\"auto, (max-width: 694px) 100vw, 694px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Components Button Enable Button depending on multipe Conditions (e.g. Dropdowns are selected): Set OnChange of Coomponents: Set DisplayMode of Component: DropDown Populate Dropdown Populating dropdown which depends on selection of a control OnVisible property of Screen: Items property of dropdown you can choose between the two collections depending on the state of the radio selection: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[159],"tags":[],"class_list":["post-9728","post","type-post","status-publish","format-standard","hentry","category-power-apps"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/comments?post=9728"}],"version-history":[{"count":2,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9728\/revisions"}],"predecessor-version":[{"id":9734,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9728\/revisions\/9734"}],"wp:attachment":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/media?parent=9728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/categories?post=9728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/tags?post=9728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}