{"id":18771,"date":"2019-05-27T13:02:35","date_gmt":"2019-05-27T13:02:35","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=18771"},"modified":"2022-07-19T16:13:12","modified_gmt":"2022-07-19T10:43:12","slug":"update-existing-records-in-dynamics-365-crm-using-microsoft-flow","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2019\/05\/update-existing-records-in-dynamics-365-crm-using-microsoft-flow\/","title":{"rendered":"Update Existing Records in CDS (Common Data Service) Using Microsoft Flow"},"content":{"rendered":"<h1><strong>Introduction:<\/strong><\/h1>\n<p>In one of our previous blog, we have seen <a href=\"https:\/\/www.inogic.com\/blog\/2018\/05\/create-new-records-in-dynamics-crm-using-microsoft-flow\/\" target=\"_blank\" rel=\"noopener noreferrer\">how to create records in Dynamics 365 CRM using Microsoft flow<\/a> mobile app.<\/p>\n<p>In this blog we will see how we can update the existing record in CDS environment using flow mobile app.<br \/>\nFor example, we want to update the particular Account record using this flow. Let\u2019s see how we can create the flow to update the account\u2019s record in CDS.<br \/>\nThe steps need to be followed for the same as below:<br \/>\nGo to the <a href=\"https:\/\/flow.microsoft.com\/en-us\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/flow.microsoft.com\/en-us\/<\/a> and sign in with your credentials.<br \/>\nTo create a flow we will choose the option as Create flow from blank as shown in the screenshot below:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-18773 size-full\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_1-1.png\" alt=\"create from blank option\" width=\"624\" height=\"463\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_1-1.png 624w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_1-1-300x223.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p>On next page again select the same option.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-18774 size-full\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_2.png\" alt=\"select create from blank\" width=\"753\" height=\"490\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_2.png 753w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_2-300x195.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_2-660x429.png 660w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/><\/p>\n<p>As we want to update the record using Flow button from mobile, we will choose \u2018Flow button for mobile\u2019 connector as shown in screenshot below:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-18775 size-full\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_3.png\" alt=\"Flow button for mobile\" width=\"1218\" height=\"606\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_3.png 1218w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_3-300x149.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_3-768x382.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_3-1024x509.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_3-660x328.png 660w\" sizes=\"(max-width: 1218px) 100vw, 1218px\" \/><\/p>\n<p>After that Click on Add an input and create the fields of the required data type which we want to update in CDS for the account entity records. Here, we will take sample fields as shown in screenshot below:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-18776 size-full\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_4.png\" alt=\"add an input\" width=\"622\" height=\"404\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_4.png 622w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_4-300x195.png 300w\" sizes=\"(max-width: 622px) 100vw, 622px\" \/><\/p>\n<p>After that, first we need to retrieve the records to update the same. To get the records we need to select Common Data service connector and select List records as an action as below:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-18777 size-full\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_5.png\" alt=\"list records\" width=\"639\" height=\"589\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_5.png 639w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_5-300x277.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p>Then select the organization name and entity name for which we are retrieving the records to update the same as shown below. To retrieve the records we can also add the filter query to filter the records.<br \/>\nHere we want to update the particular record, so we will retrieve the records based on Account name field. For the same we will add the Filter Query from Advanced options as shown below:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-18778 size-full\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_6.png\" alt=\"account name\" width=\"646\" height=\"399\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_6.png 646w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_6-300x185.png 300w\" sizes=\"(max-width: 646px) 100vw, 646px\" \/><\/p>\n<p>On this steps, it will return the account records on the base of filter query.<br \/>\nNext, select the Common Data service connector again and choose update a record action in that to update the records which we will get in the previous step.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-18779 size-full\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_7.png\" alt=\"update a record\" width=\"614\" height=\"669\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_7.png 614w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_7-275x300.png 275w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/p>\n<p>Once we add the connector as shown above we need to select the organization name and entity for which we want to perform these steps.<\/p>\n<p>Then, set the record identifier of the account to update that particular record in CDS as shown in the screenshot below:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-18780 size-full\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/06\/4Microsoft-Flow.png\" alt=\"record identifier\" width=\"996\" height=\"508\" \/><\/p>\n<p>After the same, this step will be shown as below and we need to map the field which we want to update.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-18781 size-full\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_9.png\" alt=\"advanced options\" width=\"679\" height=\"480\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_9.png 679w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_9-300x212.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_9-660x467.png 660w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_9-200x140.png 200w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/p>\n<p>So, as we are updating the records through the Microsoft flow mobile app, if we want notification once the record get successfully updated in CDS, we will add more step to get the mobile notification.<\/p>\n<p>To get the same add \u201cNotification\u201d as a connector and you can write text to get as a notification on mobile and save the flow as shown below:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-18782 size-full\" style=\"border: 1px solid #0a0a0a; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_10.png\" alt=\"account name updated\" width=\"740\" height=\"691\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_10.png 740w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_10-300x280.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2019\/05\/Update-Existing-Records-in-Dynamics-365-CRM-Using-Microsoft-Flow_10-660x616.png 660w\" sizes=\"(max-width: 740px) 100vw, 740px\" \/><\/p>\n<p>So, now users can easily run the flow from a mobile app by connecting to the CDS and update existing record same as shown in our previous blog while creating new record in D365.<\/p>\n<h1><strong>Conclusion<\/strong><\/h1>\n<p>By using Microsoft flow mobile app it is easy to update record without going into the CDS environment.<\/p>\n<h2 style=\"text-align: left;\"><div class=\"su-heading su-heading-style-default su-heading-align-center\" id=\"\" style=\"font-size:15px;margin-bottom:5px\"><div class=\"su-heading-inner\">70% of global 2000 companies apply gamification to improve productivity and returns!<\/div><\/div><\/h2>\n<p><em><strong><a href=\"https:\/\/bit.ly\/3RD4lYW\" target=\"_blank\" rel=\"noopener noreferrer\">Gamifics365<\/a> <\/strong>\u2013 Spin the magic of games within Microsoft Dynamics 365 CRM to improve user adoption, enhance productivity, and achieve company goals!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: In one of our previous blog, we have seen how to create records in Dynamics 365 CRM using Microsoft flow mobile app. In this blog we will see how we can update the existing record in CDS environment using flow mobile app. For example, we want to update the particular Account record using this\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2019\/05\/update-existing-records-in-dynamics-365-crm-using-microsoft-flow\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":18784,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[9,16,19,36,1985],"tags":[2135,301,545,561,592,1150,2144],"class_list":["post-18771","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-common-data-service","category-dynamics-365","category-dynamics-crm","category-microsoft-flow","category-power-automate","tag-cds-connector","tag-common-data-service","tag-dynamics-365-crm","tag-dynamics-365-microsoft-flow","tag-dynamics-crm","tag-microsoft-flow","tag-update-existing-records"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/18771","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=18771"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/18771\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/18784"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=18771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=18771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=18771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}