{"id":27465,"date":"2020-12-19T11:55:56","date_gmt":"2020-12-19T11:55:56","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=27465"},"modified":"2020-12-19T11:55:57","modified_gmt":"2020-12-19T11:55:57","slug":"power-apps-use-cases-for-formulas","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/","title":{"rendered":"Power Apps Use cases for formulas"},"content":{"rendered":"\n<p>We can configure our canvas app with formulas that help to calculate values and perform tasks as well as respond to other user input. In Power Apps, we can build formulas like excel by configuring controls instead of cells. Additionally, we can build formulas that apply specifically to apps instead of spreadsheets.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Prerequisites<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Sign up for Power Apps, and then sign in by providing the same credentials that you used to sign up.<\/li><li>Learn how to configure a control in Power Apps.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Steps to Show a Simple Value<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, select New on the File menu (near the left edge of the screen).<\/li><li>In the Second step, under Create an app, select Phone layout on the Blank app tile.<\/li><li>Thirdly, add a Label control to the screen.<\/li><li>Next, set the value of the Text property to &#8220;Hello World&#8221; by typing that string, surrounded by double quotes, into the formula bar<\/li><li>Lastly, in the Text property of the label, replace &#8220;Hello World&#8221; with Sum(1,2,3).<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Change a value based on input<\/strong><\/h4>\n\n\n\n<p>In Power Apps, you can achieve a similar result by adding controls to a screen and setting their properties. For example, irrespective of what numbers you type in the text-input controls, the label always shows the sum of those numbers because its\u00a0<strong>Text<\/strong>\u00a0property is set to this formula:<\/p>\n\n\n\n<p><code>TextInput1 + TextInput2<\/code><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Change a color based on user input<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, remove the controls from the previous procedures, or create a blank app as you did previously, and add three slider controls to it.<\/li><li>Secondly, arrange the sliders so they don&#8217;t overlap, add three labels, and configure them to show\u00a0<strong>Red<\/strong>,\u00a0<strong>Green<\/strong>, and\u00a0<strong>Blue<\/strong>.<\/li><li>Then, set the\u00a0<strong>Max<\/strong>\u00a0property of each slider to 255, which is the maximum value of a color component for the\u00a0<strong>RGBA<\/strong>\u00a0function<\/li><li>In the fourth step, Select the screen by clicking away from any control, and then set the screen&#8217;s\u00a0<strong>Fill<\/strong>\u00a0property to this formula: <strong>RGBA( Slider1.Value, Slider2.Value, Slider3.Value, 1 )<\/strong><\/li><li>Lastly, Adjust the sliders, and see how your changes affect the background color.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.testpreptraining.ai\/microsoft-power-platform-fundamentals-pl-900-free-practice-test\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.png\" alt=\"Microsoft Exam PL-900 Free Test\"\/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>We can configure our canvas app with formulas that help to calculate values and perform tasks as well as respond to other user input. In Power Apps, we can build formulas like excel by configuring controls instead of cells. Additionally, we can build formulas that apply specifically to apps instead of spreadsheets. Prerequisites Sign up&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-27465","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power Apps Use cases for formulas - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Learn more to configure Power apps with formulas with latest and updated tutorial and practice test. Prepare for Microsoft PL-900 Exam Now!\" \/>\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.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Apps Use cases for formulas - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Learn more to configure Power apps with formulas with latest and updated tutorial and practice test. Prepare for Microsoft PL-900 Exam Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-19T11:55:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.png\" \/>\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 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/\",\"name\":\"Power Apps Use cases for formulas - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-12-19T11:55:56+00:00\",\"dateModified\":\"2020-12-19T11:55:57+00:00\",\"description\":\"Learn more to configure Power apps with formulas with latest and updated tutorial and practice test. Prepare for Microsoft PL-900 Exam Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Apps Use cases for formulas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power Apps Use cases for formulas - Testprep Training Tutorials","description":"Learn more to configure Power apps with formulas with latest and updated tutorial and practice test. Prepare for Microsoft PL-900 Exam Now!","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.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/","og_locale":"en_US","og_type":"article","og_title":"Power Apps Use cases for formulas - Testprep Training Tutorials","og_description":"Learn more to configure Power apps with formulas with latest and updated tutorial and practice test. Prepare for Microsoft PL-900 Exam Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-12-19T11:55:57+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/","name":"Power Apps Use cases for formulas - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-12-19T11:55:56+00:00","dateModified":"2020-12-19T11:55:57+00:00","description":"Learn more to configure Power apps with formulas with latest and updated tutorial and practice test. Prepare for Microsoft PL-900 Exam Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/power-apps-use-cases-for-formulas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Power Apps Use cases for formulas"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/27465","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=27465"}],"version-history":[{"count":2,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/27465\/revisions"}],"predecessor-version":[{"id":27481,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/27465\/revisions\/27481"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=27465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=27465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=27465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}