{"id":12385,"date":"2018-07-17T17:20:39","date_gmt":"2018-07-17T11:50:39","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=12385"},"modified":"2022-07-01T14:48:01","modified_gmt":"2022-07-01T09:18:01","slug":"create-dynamics-365-records-from-an-excel-using-microsoft-flow","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2018\/07\/create-dynamics-365-records-from-an-excel-using-microsoft-flow\/","title":{"rendered":"Create Dynamics 365 Records from an Excel using Microsoft Flow"},"content":{"rendered":"

\"Create<\/h2>\n

Introduction:<\/strong><\/h2>\n

Dynamics 365 Records can be created from Excel using Microsoft flow \u201cCreate Dynamics 365 Leads from an Excel table\u201d.\u00a0 <\/strong>This is useful if user wants to create Records for each row from the Excel that is uploaded on any cloud storage space like google drive, OneDrive, DropBox, FTP, etc.<\/p>\n

In this blog, we will go through the steps to create Create Dynamics 365 records from Excel that is uploaded on google drive.<\/p>\n

Below are the steps for creating Dynamics 365 Records from Excel using Microsoft flow:<\/p>\n

1<\/strong>. Navigate to \u201cApps\u201d section of Dynamics CRM, and click on \u201cFlow\u201d.<\/p>\n

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

 <\/p>\n

2<\/strong>. Click on \u201cCreate Dynamics 365 Leads from an Excel table\u201d as shown in the below screenshot.<\/p>\n

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

 <\/p>\n

3<\/strong>. While creating flow \u201cCreate Dynamics 365 Leads from an Excel table\u201d, we need to choose the media where our excel will be uploaded. As shown in the below screenshot.<\/p>\n

It provides below options:<\/p>\n

    \n
  1. OneDrive for Business<\/li>\n
  2. OneDrive<\/li>\n
  3. DropBox<\/li>\n
  4. Active File Storage<\/li>\n
  5. FTP<\/li>\n
  6. Google Drive<\/li>\n
  7. SFTP<\/li>\n
  8. File System<\/li>\n<\/ol>\n

    4<\/strong>. Here we will select Google Drive, after selecting it, users need to sign in to Google Drive. Refer below screenshot for the same.\"flow\"<\/p>\n

    5<\/strong>. Click on \u201cSign-in\u201d to connect with Google drive.<\/p>\n

    \"flow1\"<\/p>\n

    6<\/strong>. After successful connection with Google Drive, the user can continue with creating the flow \u201cCreate Dynamics 365 Leads from an Excel table\u201d.<\/p>\n

    \"flow3\"<\/p>\n

    Microsoft flow \u201cCreate Dynamics 365 Leads from an Excel table\u201d includes recurrence for creating Record in Dynamics 365. Recurrence setting in this flow determines after how many intervals the records will be created in CRM from Excel.\u00a0\u00a0Next Step is to specify the file name and table name of the excel file uploaded on google drive from which records will be retrieved in order to create in CRM.<\/p>\n

    \"flow4\"<\/p>\n

    7<\/strong>. After creating a record in CRM, flow allows us to delete that row from Excel. For this, we need to specify excel file name and table name in \u201cDelete rowScope\u201d Section of the flow.<\/p>\n

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

     <\/p>\n

     <\/p>\n

    8<\/b>. In \u201cCreate a new recordScope\u201d section in flow, we need to specify \u201cOrganization Name\u201d in which we need to create the Dynamics 365 Records.<\/p>\n

    9<\/b>. Select \u201cEntity Name\u201d and map other fields of record with the columns mentioned in the excel sheet.<\/p>\n

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

     <\/p>\n

    10<\/b>. Click on Save. We can also test the flow by clicking on the \u201cTest\u201d button.<\/p>\n

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

     <\/p>\n

    Conclusion:<\/strong><\/h2>\n

    Using \u201cCreate Dynamics 365 Leads from an Excel table\u201d<\/strong> in Microsoft Flow user can create records in Dynamics CRM from an Excel uploaded on google drive.<\/p>\n

    Cut short 90% of your manual work and repetitive data entry!<\/div><\/div><\/h2>\n

    Get 1 Click apps and say goodbye to all repetitive data entry in CRM –<\/em>
    \n    Click2Clone<\/a> <\/strong>\u2013 Clone\/Copy Dynamics 365 CRM records in 1 Click<\/em>
    \n    Click2Export<\/a><\/strong> \u2013 Export Dynamics 365 CRM Report\/CRM Views\/Word\/Excel template in 1 Click<\/em>
    \n    Click2Undo<\/a><\/strong> \u2013 Undo & Restore Dynamics 365 CRM data in 1 Click<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

    Introduction: Dynamics 365 Records can be created from Excel using Microsoft flow \u201cCreate Dynamics 365 Leads from an Excel table\u201d.\u00a0 This is useful if user wants to create Records for each row from the Excel that is uploaded on any cloud storage space like google drive, OneDrive, DropBox, FTP, etc. In this blog, we will\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":12393,"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":[16,18,19,36,1985],"tags":[561,1150],"class_list":["post-12385","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-dynamics-crm","category-microsoft-flow","category-power-automate","tag-dynamics-365-microsoft-flow","tag-microsoft-flow"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/12385","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=12385"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/12385\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/12393"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=12385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=12385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=12385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}