{"id":110733,"date":"2016-08-08T05:15:06","date_gmt":"2016-08-08T12:15:06","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/"},"modified":"2016-08-08T05:15:06","modified_gmt":"2016-08-08T12:15:06","slug":"crm-records-from-sp-server","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/","title":{"rendered":"Flow of the Week: Create records in Dynamics CRM from SharePoint Server 2016 list"},"content":{"rendered":"<p>This week <a href=\"https:\/\/flow.microsoft.com\/en-us\/blog\/sharepoint-on-premises-and-info-bubbles-2\/\">we released SharePoint on-premises support,<\/a> so you can easily connect to any SharePoint 2016 Server install. This week we would like to highlight Dynamics CRM Online integration. <a href=\"http:\/\/dynamicscrmcoe.com\/dynamics-crm-online-and-sharepoint-online-codeless-integration\/\">Mark Smith recently covered this for SharePoint Online on his blog, check it out.\u00a0<\/a><\/p>\n<p>To get started use <a href=\"https:\/\/flow.microsoft.com\/en-us\/galleries\/public\/templates\/0f87f67484394db183f208d1a04d1ff1\/create-a-new-record-in-dynamics-crm-when-a-new-list-item-is-added\/\">this template here<\/a>. When you create the connection be sure to check the <strong>Connect via on-premises gateway<\/strong> checkbox:<\/p>\n<p><img decoding=\"async\" alt=\"Connect via gateway\" src=\"https:\/\/flowandspo.blob.core.windows.net\/flowandspoimages\/SPOnPremBlogPost\/SP_Image4.png\" style=\"width: 475px; height: 529px;\"\/><\/p>\n<p>If this is the first time you are connecting on-premises you&#8217;ll need to install a gateway:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/BlogPost_0-1.png\"\/><\/p>\n<p>Be sure to install it on a machine that is always on and connected to both the network and the Internet or else the flow will not work. <a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkID=820582&amp;clcid=0x409\">Go here to read more about installing the gateway.<\/a><\/p>\n<p>After you have connected to SharePoint and your Dynamics CRM you will need to configure the flow. Choose the SharePoint site, the SharePoint list, the Dynamics CRM organization, and the entity type that you want to create. Finally, pass data into the fields for the entities by using the tokens underneath the text boxes. In just a few minutes you&#8217;ve been able to integrate your on-premises SharePoint system with your Dynamics CRM. If you use another system, like Salesforce, this same process will work for that too.<\/p>\n<p>We would be happy to feature any scenario that you find interesting,<a href=\"https:\/\/twitter.com\/MicrosoftFlow\"> just reach out to us on twitter<\/a> or on the forums (thanks to Mark for featuring this scenario!).\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use this flow to get data from your on-premises SharePoint Server 2016 lists into your Dynamics CRM online. <\/p>\n","protected":false},"author":347,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2590],"power-automate-tag":[],"coauthors":[2913],"class_list":["post-110733","power-automate","type-power-automate","status-publish","hentry","power-automate-category-flow-of-the-week"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Flow of the Week: Create records in Dynamics CRM from SharePoint Server 2016 list - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Flow of the Week: Create records in Dynamics CRM from SharePoint Server 2016 list - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Use this flow to get data from your on-premises SharePoint Server 2016 lists into your Dynamics CRM online.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/flowandspo.blob.core.windows.net\/flowandspoimages\/SPOnPremBlogPost\/SP_Image4.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Stephen Siciliano\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/\",\"name\":\"Flow of the Week: Create records in Dynamics CRM from SharePoint Server 2016 list - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/flowandspo.blob.core.windows.net\/flowandspoimages\/SPOnPremBlogPost\/SP_Image4.png\",\"datePublished\":\"2016-08-08T12:15:06+00:00\",\"dateModified\":\"2016-08-08T12:15:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/#primaryimage\",\"url\":\"https:\/\/flowandspo.blob.core.windows.net\/flowandspoimages\/SPOnPremBlogPost\/SP_Image4.png\",\"contentUrl\":\"https:\/\/flowandspo.blob.core.windows.net\/flowandspoimages\/SPOnPremBlogPost\/SP_Image4.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Automate\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Flow of the Week: Create records in Dynamics CRM from SharePoint Server 2016 list\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Flow of the Week: Create records in Dynamics CRM from SharePoint Server 2016 list - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/","og_locale":"en_US","og_type":"article","og_title":"Flow of the Week: Create records in Dynamics CRM from SharePoint Server 2016 list - Microsoft Power Platform Blog","og_description":"Use this flow to get data from your on-premises SharePoint Server 2016 lists into your Dynamics CRM online.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/flowandspo.blob.core.windows.net\/flowandspoimages\/SPOnPremBlogPost\/SP_Image4.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 min read","Written by":"Stephen Siciliano"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/","name":"Flow of the Week: Create records in Dynamics CRM from SharePoint Server 2016 list - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/#primaryimage"},"thumbnailUrl":"https:\/\/flowandspo.blob.core.windows.net\/flowandspoimages\/SPOnPremBlogPost\/SP_Image4.png","datePublished":"2016-08-08T12:15:06+00:00","dateModified":"2016-08-08T12:15:06+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/#primaryimage","url":"https:\/\/flowandspo.blob.core.windows.net\/flowandspoimages\/SPOnPremBlogPost\/SP_Image4.png","contentUrl":"https:\/\/flowandspo.blob.core.windows.net\/flowandspoimages\/SPOnPremBlogPost\/SP_Image4.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/crm-records-from-sp-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Automate","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/"},{"@type":"ListItem","position":3,"name":"Flow of the Week: Create records in Dynamics CRM from SharePoint Server 2016 list"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110733"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-automate"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/347"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110733"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110733\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110733"}],"wp:term":[{"taxonomy":"power-automate-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-category?post=110733"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110733"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}