{"id":3268,"date":"2018-09-04T07:42:05","date_gmt":"2018-09-04T07:42:05","guid":{"rendered":"http:\/\/himbap.com\/blog\/?p=3268"},"modified":"2018-09-04T07:42:05","modified_gmt":"2018-09-04T07:42:05","slug":"update-dynamics-365-data-using-flow","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=3268","title":{"rendered":"Update Dynamics 365 Data using Flow"},"content":{"rendered":"

Introduction<\/strong>
\nIn our earlier article<\/a> we discussed how we can create data in Dynamics 365 CE using Microsoft Flow from excel file. Now in this article we are going to discuss how we can update existing data using flow.<\/p>\n

Requirement:<\/strong> In our earlier example we used following excel table to upload data to contact entity,<\/p>\n

\"upload1\"<\/a><\/p>\n

Now let’s say we have updated some data and added some new records, now we want to update existing data based on the email id of contact and if it’s not available we want to create it (like upsert operation)<\/p>\n

\u00a0\"uploadupdate3\"<\/a><\/p>\n

Solution: <\/strong>
\nFollow our earlier article <\/a>and implement step 1-4 to achieve following:
\n\"uploadupdate4\"<\/a>
\nNow lets add a List Records action from Dynamics 365 and configure it like following, here we are going to query Dynamics 365 contacts based on the\u00a0email id from excel file.
\n\"uploadupdate5\"<\/a>
\nNow lets add a condition to check if list of records not empty, first add condition and set value like following
\n\"uploadupdate7\"<\/a>
\nAfter that click on Edit in advance mode and change it like below, here we are checking if the above list record action returned\u00a0null value.
\n\"uploadupdate6\"<\/a>
\nNow after check above condition we need to add Create step under Yes section and Update section under No section like following
\n\"uploadupdate9\"<\/a>and need to configure update like following<\/p>\n

\"uploadupdate8\"<\/a><\/p>\n

We can set other fields using expression items(‘Apply_to_each’)[‘ColumnNameFromExcelFile’] <\/strong><\/em>. Finally add delete step to delete the excel file from one drive.<\/p>\n

\"upload7\"<\/a><\/p>\n

Now save your changes and upload file to one drive after couple of mints we will be able to see contact data like following
\n\"uploadupdate10\"<\/a>
\nIf contact exists with email id it will update contact otherwise it will create new contact record.<\/p>\n

Stay tuned for more Dynamics 365 Contents !!<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction In our earlier article we discussed how we can create data in Dynamics 365 CE using Microsoft Flow from excel file. Now in this article we are going to discuss how we can update existing data using flow. Requirement: In our earlier example we used following excel table to upload data to contact entity, Now let’s say we have… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":3231,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[21,402,593],"tags":[617,404,614,615,607,600,616],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3268"}],"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=3268"}],"version-history":[{"count":8,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3268\/revisions"}],"predecessor-version":[{"id":3287,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3268\/revisions\/3287"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/3231"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}