{"id":38282,"date":"2024-05-29T16:12:02","date_gmt":"2024-05-29T10:42:02","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=38282"},"modified":"2024-05-29T16:12:02","modified_gmt":"2024-05-29T10:42:02","slug":"create-a-table-in-dynamics-365-crm-from-the-sharepoint-list","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2024\/05\/create-a-table-in-dynamics-365-crm-from-the-sharepoint-list\/","title":{"rendered":"Create a table in Dynamics 365 CRM from the SharePoint List"},"content":{"rendered":"

\"Create<\/p>\n

In today’s digital era, organizations often rely on Microsoft SharePoint as a central hub for collaboration, document management, and data storage. Just SharePoint lists, while powerful for storing and managing data, may not provide the most conducive format especially when presenting information in reports, or dashboards.\u00a0 This is where table creation from the SharePoint list comes into the picture to fill the gap. By transforming SharePoint list data into a structured table format, organizations can enhance data visualization, simplify reporting processes, and integrate SharePoint data seamlessly into various applications and documents.<\/p>\n

Let’s consider a scenario wherein the organization \u201cElectroTech Solutions<\/strong>\u201d currently uses a SharePoint list named “Product Reviews<\/strong>” to manage the reviews submitted by customers. However, they find it challenging to efficiently manage and analyze reviews within SharePoint alone. Further, as the company is growing it feels the need for advanced CRM capabilities present in Dynamics CRM to streamline their daily business needs and manage their customers more efficiently. So ElectroTech Solutions subscribes to Dynamics 365 CRM and would want a way to migrate their SharePoint list named “Product Reviews<\/strong>” to CRM to further perform their future operations through CRM itself. This is where the \u201cCreate with SharePoint List<\/strong>\u201d comes into the picture, which not only auto-codes a custom table “Product Reviews<\/strong>” in Dynamics CRM but moves the list items as its records in Dynamics CRM as well.<\/p>\n

The below quick illustration will walk you through the respective step-by-step action\/process \u2013<\/p>\n

Step 1: Sign In to the <\/strong>Power Apps<\/strong><\/a><\/p>\n

Once logged in successfully, select an appropriate environment in which you want to be able to create a Product Review Table –<\/p>\n

\"Create<\/p>\n

Step 2: Connect with SharePoint Site<\/strong><\/p>\n

Under the navigation pane, go to Tables<\/strong> >> Create with SharePoint list<\/strong>.<\/p>\n

\"Create<\/p>\n

 <\/p>\n

\"CreateEstablish the SharePoint connection-<\/strong><\/p>\n

Now we are navigated to the Connection window where we provide the SharePoint<\/strong> page URL and connect with the SharePoint site with the help of the \u201cConnect<\/strong>\u201d option.<\/p>\n

\"Create<\/p>\n

Step 3: Select SharePoint Site from the available ones.<\/strong><\/p>\n

Upon successful connection with SharePoint, we select the site from which we want to create a table as shown below:<\/p>\n

\"Create<\/p>\n

Step 4: Select SharePoint list to Create a Table<\/strong><\/p>\n

We choose an appropriate SharePoint list to further create a table for the same.<\/p>\n

\"Create<\/p>\n

Proceed with \u201cNext\u201d<\/strong><\/p>\n

Step 5: Create a Table from the SharePoint list<\/strong><\/p>\n

Now we are shown a preview of how all the Data of the \u201cProductReviews\u201d<\/strong> SharePoint list shall be seen in power apps.<\/p>\n

\"Create<\/p>\n

In this preview, we have an option to edit the table properties like Display Name, Description, etc.<\/p>\n

\"Create<\/p>\n

We can also update the column properties as shown below.<\/p>\n

\"Create<\/p>\n

Further, we also have the flexibility to change the Ownership Type of the table if it is \u201cUser or Team\u201d<\/strong> or \u201cOrganization\u201d<\/strong>.<\/p>\n

\"Create<\/p>\n

Once everything seems in place, click \u201cCreate<\/strong>\u201d.<\/p>\n

This will then generate a table in CRM showing all the corresponding information from the SharePoint list \u2013<\/p>\n

\"Create<\/p>\n

Below, we can see a table in our application with data populated from the SharePoint list \u201cProduct Reviews\u201d<\/strong>.<\/p>\n

\"Create<\/p>\n

 <\/p>\n

 <\/p>\n

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

Thus, we saw how we can migrate SharePoint list data into a CRM table by using this newly introduced \u201cCreate with SharePoint list\u201d<\/strong> functionality.<\/p>\n

\"SharePoint<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In today’s digital era, organizations often rely on Microsoft SharePoint as a central hub for collaboration, document management, and data storage. Just SharePoint lists, while powerful for storing and managing data, may not provide the most conducive format especially when presenting information in reports, or dashboards.\u00a0 This is where table creation from the SharePoint list\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":11,"featured_media":0,"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,38,53],"tags":[2886],"class_list":["post-38282","post","type-post","status-publish","format-standard","hentry","category-dynamics-365","category-microsoft-powerapps","category-sharepoint","tag-sharepoint-list"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/38282","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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=38282"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/38282\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=38282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=38282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=38282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}