{"id":4016,"date":"2020-10-19T08:52:58","date_gmt":"2020-10-19T08:52:58","guid":{"rendered":"https:\/\/himbap.com\/blog\/?p=4016"},"modified":"2020-10-20T14:01:55","modified_gmt":"2020-10-20T14:01:55","slug":"update-entity-from-canvas-app-with-power-automate","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=4016","title":{"rendered":"Update entity from Canvas App with Power Automate"},"content":{"rendered":"<p><strong>Introduction<\/strong><br \/>\nThis is third article about using Bing maps in Canvas app. In earlier articles we discussed about how we can show event organizer data in the gallery control and render them in the Bing maps. Today we are going to discuss how to update entity data from canvas app.<\/p>\n<p><a href=\"https:\/\/himbap.com\/blog\/?p=3967\">Canvas app with Bing Maps in Dynamics 365 CE &#8211; 1<\/a><br \/>\n<a href=\"https:\/\/himbap.com\/blog\/?p=3990\">Canvas app with Bing Maps in Dynamics 365 CE &#8211; 2<\/a><\/p>\n<p><strong>Details<\/strong><br \/>\nWe are going to discuss about how to trigger Power Automate from Canvas app to update entity record. Let&#8217;s see how we can do that<\/p>\n<p>Open Canvas app that we created in earlier article, if not created yet, please follow earlier articles first. We need to edit our gallery, click on the pencil icon<br \/>\n<a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_1.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-4019 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_1-234x300.png\" alt=\"part3_1\" width=\"234\" height=\"300\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_1-234x300.png 234w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_1.png 293w\" sizes=\"(max-width: 234px) 100vw, 234px\" \/><\/a><br \/>\nThis will allow us to edit gallery template, now we need to select &gt; control in the first row and need to add express in the OnSelect event. Delete existing express from OnSelect.<br \/>\n<a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_2.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-4020 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_2-300x167.png\" alt=\"part3_2\" width=\"300\" height=\"167\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_2-300x167.png 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_2-624x347.png 624w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_2.png 722w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>After that we need to select Power Automate option from Action menu. Click on Create new Flow option<\/p>\n<p><a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_3.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-4021 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_3-300x215.png\" alt=\"part3_3\" width=\"300\" height=\"215\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_3-300x215.png 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_3.png 437w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>It will take us to the Power Automate. Let&#8217;s first provide name of our flow as &#8220;UpdateEventOrgnizerValue&#8221; and then select Power Apps option like below<br \/>\n<a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_4.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-4022 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_4-290x300.png\" alt=\"part3_4\" width=\"290\" height=\"300\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_4-290x300.png 290w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_4.png 389w\" sizes=\"(max-width: 290px) 100vw, 290px\" \/><\/a><\/p>\n<p>After that click on PowerApps trigger<br \/>\n<a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_5.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-4023 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_5-300x145.png\" alt=\"part3_5\" width=\"300\" height=\"145\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_5-300x145.png 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_5.png 456w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Next we need to select our action, as we want to update event entity record so we will be using Update action from Common Data Service (Current environment) Connector.<br \/>\n<!--more--><\/p>\n<p><a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_6.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-4024 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_6-300x265.png\" alt=\"part3_6\" width=\"300\" height=\"265\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_6-300x265.png 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_6-624x552.png 624w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_6.png 632w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Next select event entity and under the Item Id, click on insert parameter<br \/>\n<a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_7.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-4025 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_7-300x133.png\" alt=\"part3_7\" width=\"300\" height=\"133\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_7-300x133.png 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_7-624x277.png 624w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_7.png 637w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Next navigate to Event organizer field and again set parameter. But keep in mind as this is a lookup field we need to first add <strong>\/account()<\/strong> and then under the () we need to put our parameter like below<br \/>\n<a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_9.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4027 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_9.png\" alt=\"part3_9\" width=\"276\" height=\"167\" \/><\/a><\/p>\n<p>We will be passing both of these parameters from our Canvas app. We are done with Power Automate now, save and close it, now navigate back to our Power Apps studio and select our Flow that we just created.<\/p>\n<p>Now we need to set following express to call our Flow.<br \/>\n<a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_10.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-4028 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_10-300x84.png\" alt=\"part3_10\" width=\"300\" height=\"84\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_10-300x84.png 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_10-624x175.png 624w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_10.png 798w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Here we are getting our fist parameter using ModelDrivenFormIntegration control and passing our current event record id which we want to update. Second parameter we are getting from the gallery control, which is selected account record. Now save and publish canvas app and navigate to Dynamics 365 CE and open event entity record. When we will click on the &gt; icon it will trigger our flow and it will set the lookup, but as flow takes some time, you may need to refresh your screen to see the changes.<br \/>\n<a href=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_121.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-4030 aligncenter\" src=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_121-300x194.png\" alt=\"part3_12\" width=\"300\" height=\"194\" srcset=\"https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_121-300x194.png 300w, https:\/\/himbap.com\/blog\/wp-content\/uploads\/2020\/10\/part3_121.png 451w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><strong>Summary<\/strong><br \/>\nThis is how we can use Power Automate to update entity information from Canvas app. Using Power Automate will take little bit time as it takes time to execute, so we may need to refresh form to see this results in next post we will see alternate way of updating entity form fields.<\/p>\n<p>Hope it will help someone!<br \/>\n<strong>Keep learning, Keep sharing !!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction This is third article about using Bing maps in Canvas app. In earlier articles we discussed about how we can show event organizer data in the gallery control and render them in the Bing maps. Today we are going to discuss how to update entity data from canvas app. Canvas app with Bing Maps in Dynamics 365 CE &#8211;&#8230; <a href=\"https:\/\/himbap.com\/blog\/?p=4016\">Read more &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":4020,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[402,593],"tags":[834,731,839,835,838,837,836],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4016"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4016"}],"version-history":[{"count":10,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4016\/revisions"}],"predecessor-version":[{"id":4040,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4016\/revisions\/4040"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/4020"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}