{"id":1797,"date":"2017-10-17T11:28:02","date_gmt":"2017-10-17T00:28:02","guid":{"rendered":"https:\/\/itgroove.net\/mmman\/?p=1790"},"modified":"2023-02-24T21:39:31","modified_gmt":"2023-02-24T21:39:31","slug":"how-to-pass-parameters-into-a-powerapp-2","status":"publish","type":"post","link":"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/","title":{"rendered":"How to Pass Parameters into a PowerApp"},"content":{"rendered":"<p>I was recently trying to replicate some functionality I&#8217;m used to with InfoPath, but this time using a PowerApp. I was looking for a way to get parameters from outside into a PowerApp, and surprisingly this is really not well documented, but actually really quite easy to do. I&#8217;ll walk you through the process below.<\/p>\n<p>Note, this isn&#8217;t about passing parameters between screens in a PowerApp, that&#8217;s well covered in several blog posts, and forums.<\/p>\n<p>First off, start by creating an app. Below I&#8217;ve created my &#8220;ColinTestApp&#8221; App. Next, go into the &#8220;Information&#8221; pane on the far right (highlighted by the arrow).<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa1.png\" alt=\"\" \/><\/p>\n<p>In there you&#8217;ll find the &#8220;Web link&#8221;. This is what you&#8217;ll use to pass variables into your app via a web URL. Note the App GUID is in in the URL \u2013 this is the unique identifier for your app.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa2.png\" alt=\"\" \/><\/p>\n<p>Your Web link will look like something like this below (where the GUID of your APP replaces APP GUID).<\/p>\n<p>https:\/\/web.powerapps.com\/apps\/[APP GUID]<\/p>\n<p>To pass parameters to the App, you simply add URL parameters like this below.<\/p>\n<p>https:\/\/web.powerapps.com\/apps\/[APP GUID]<strong>?ID=123&amp;Ball=round&amp;River=water<\/strong><\/p>\n<p>In this case, we&#8217;re passing 3 named parameters, &#8220;ID&#8221;, &#8220;Ball&#8221;, and &#8220;River&#8221; (remember, when passing URL&#8217;s over HTTP, you need to start with a question mark (?), followed by ampersands (&amp;) for all additional parameters in a &#8220;name=value&#8221; pairing).<\/p>\n<p>To use these in your PowerApp, you simply refer to them by their parameter name using the &#8220;Param&#8221; method, like below.<\/p>\n<p>Param(&#8220;[PARAM NAME]&#8221;)<\/p>\n<p>For example, in my case, I used it as a start variable on my initial screen. This allowed me to feed to the PowerApp a dynamic value (the ID) of the item I wanted to load at start up. In this scenario, the data was being fed from a SharePoint list, and at load time I was able to load the specific SharePoint list item I wanted into my start screen.<\/p>\n<p>First(Filter(MySharePointListDataSource,ID=Param(&#8220;ID&#8221;)))<\/p>\n<p>The above formula basically filters the ID parameter to the &#8220;ID&#8221; of the data source (a SharePoint list), and then from that set, I select the &#8220;first&#8221;, just for good measure (even though there should never be more than one matching ID for any given SharePoint list item).<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa3.png\" alt=\"\" \/><\/p>\n<p>In the above screen, just make sure you have the &#8220;DetailForm1&#8221; selected (which will allow you to set the DATA pane, and set your datasource for the form), and then be sure that 1 &amp; 2 are the same value (i.e. if your data source (SharePoint list) is &#8220;Products&#8221;, be sure that Products is in both #1 and #2 above.<\/p>\n<p>Note, I&#8217;d previously setup a DataSource that draws from my SharePoint List<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa4.png\" alt=\"\" \/><\/p>\n<p>So in my scenario &#8220;TestList&#8221; would be in both #1 and #2 above.<\/p>\n<p>Hopefully this helps some of you out in PowerApp land!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was recently trying to replicate some functionality I&#8217;m used to with InfoPath, but this time using a PowerApp. I was looking for a way to get parameters from outside into a PowerApp, and surprisingly this is really not well documented, but actually really quite easy to do. I&#8217;ll walk you through the process below. &hellip; <a href=\"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/\"><\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[29],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Pass Parameters into a PowerApp - Archive<\/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:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Pass Parameters into a PowerApp - Archive\" \/>\n<meta property=\"og:description\" content=\"I was recently trying to replicate some functionality I&#8217;m used to with InfoPath, but this time using a PowerApp. I was looking for a way to get parameters from outside into a PowerApp, and surprisingly this is really not well documented, but actually really quite easy to do. I&#8217;ll walk you through the process below. &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Archive\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-17T00:28:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-24T21:39:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa1.png\" \/>\n<meta name=\"author\" content=\"Colin Phillips (Alumni)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Colin Phillips (Alumni)\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/\",\"url\":\"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/\",\"name\":\"How to Pass Parameters into a PowerApp - Archive\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa1.png\",\"datePublished\":\"2017-10-17T00:28:02+00:00\",\"dateModified\":\"2023-02-24T21:39:31+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/#primaryimage\",\"url\":\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa1.png\",\"contentUrl\":\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa1.png\",\"width\":874,\"height\":359},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog Archive\",\"item\":\"https:\/\/regroove.ca\/archive\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Pass Parameters into a PowerApp\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/archive\/#website\",\"url\":\"https:\/\/regroove.ca\/archive\/\",\"name\":\"Archive\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/archive\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\",\"name\":\"Colin Phillips (Alumni)\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"caption\":\"Colin Phillips (Alumni)\"},\"url\":\"https:\/\/regroove.ca\/archive\/author\/cphillips\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Pass Parameters into a PowerApp - Archive","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:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/","og_locale":"en_US","og_type":"article","og_title":"How to Pass Parameters into a PowerApp - Archive","og_description":"I was recently trying to replicate some functionality I&#8217;m used to with InfoPath, but this time using a PowerApp. I was looking for a way to get parameters from outside into a PowerApp, and surprisingly this is really not well documented, but actually really quite easy to do. I&#8217;ll walk you through the process below. &hellip;","og_url":"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/","og_site_name":"Archive","article_published_time":"2017-10-17T00:28:02+00:00","article_modified_time":"2023-02-24T21:39:31+00:00","og_image":[{"url":"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa1.png"}],"author":"Colin Phillips (Alumni)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Colin Phillips (Alumni)","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/","url":"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/","name":"How to Pass Parameters into a PowerApp - Archive","isPartOf":{"@id":"https:\/\/regroove.ca\/archive\/#website"},"primaryImageOfPage":{"@id":"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/#primaryimage"},"image":{"@id":"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/#primaryimage"},"thumbnailUrl":"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa1.png","datePublished":"2017-10-17T00:28:02+00:00","dateModified":"2023-02-24T21:39:31+00:00","author":{"@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/#primaryimage","url":"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa1.png","contentUrl":"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2017\/10\/101717_0023_HowtoPassPa1.png","width":874,"height":359},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/archive\/2017\/10\/17\/how-to-pass-parameters-into-a-powerapp-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Archive","item":"https:\/\/regroove.ca\/archive\/"},{"@type":"ListItem","position":2,"name":"How to Pass Parameters into a PowerApp"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/archive\/#website","url":"https:\/\/regroove.ca\/archive\/","name":"Archive","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/archive\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b","name":"Colin Phillips (Alumni)","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","caption":"Colin Phillips (Alumni)"},"url":"https:\/\/regroove.ca\/archive\/author\/cphillips\/"}]}},"_links":{"self":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/1797"}],"collection":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/comments?post=1797"}],"version-history":[{"count":1,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/1797\/revisions"}],"predecessor-version":[{"id":1798,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/1797\/revisions\/1798"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/media?parent=1797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/categories?post=1797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/tags?post=1797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}