{"id":2991,"date":"2018-08-27T08:00:57","date_gmt":"2018-08-27T08:00:57","guid":{"rendered":"http:\/\/himbap.com\/blog\/?p=2991"},"modified":"2018-09-03T09:21:01","modified_gmt":"2018-09-03T09:21:01","slug":"uploading-data-to-dynamics-365-using-microsoft-flow","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=2991","title":{"rendered":"Uploading data to Dynamics 365 using Microsoft Flow"},"content":{"rendered":"

Introduction<\/strong>
\nIn this article we will discuss how we can create data in Dynamics 365 CE using Microsoft Flow using excel file.<\/p>\n

Requirement<\/strong>: Let\u2019s say we have requirement to read excel file from one drive for business and create Dynamics 365 CE contacts. We have contact.xlsx file in one drive for business having following fields
\n\"upload1\"<\/a><\/p>\n

Solution<\/strong>: We can easily implement this using Microsoft Flow using following quick steps. let’s follow below steps to use Flow to read file and create contact records.
\n1. Navigate to Flow from Dynamics 365 CE and select Create from blank option.
\n2. First we will be adding a one drive for business trigger to check if file is created to specific one drive for business folder, we will be using root folder of one drive for business, so let’s select below trigger
\n\"upload2\"<\/a>
\n3. Once we have trigger defined, we need to add action to get rows from the excel file and need to select file and write our table name from excel
\n\"upload3\"<\/a>\"upload11\"<\/a>
\n4. Now we need to add Apply to each steps to process rows, so add Apply to each from\u00a0more actions
\n\"upload4\"<\/a>
\n5. After process rows, we need to get values and need to create contact record
\n\"upload5\"<\/a>
\nAfter selecting our Dynamics 365 organization and Contacts, we need to set field using expression like below based on the column name in excel file
\n\"upload6\"<\/a>
\n6. Finally, delete file once record is processed
\n\"upload7\"<\/a><\/p>\n

After configuring all the steps it should like following
\n\"upload8\"<\/a><\/p>\n

Currently in Dynamics 365, We don’t have any records under My Active Contacts
\n\"upload9\"<\/a>
\nOnce we will upload file to one drive for business, we can see records after few mints
\n\"upload10\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction In this article we will discuss how we can create data in Dynamics 365 CE using Microsoft Flow using excel file. Requirement: Let\u2019s say we have requirement to read excel file from one drive for business and create Dynamics 365 CE contacts. We have contact.xlsx file in one drive for business having following fields Solution: We can easily implement… 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,522,593],"tags":[605,602,607,600,603,606,604],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2991"}],"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=2991"}],"version-history":[{"count":8,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2991\/revisions"}],"predecessor-version":[{"id":3263,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2991\/revisions\/3263"}],"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=2991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}