Create a table in Dynamics 365 CRM from the SharePoint List

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.  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.

Let’s consider a scenario wherein the organization “ElectroTech Solutions” currently uses a SharePoint list named “Product Reviews” 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” to CRM to further perform their future operations through CRM itself. This is where the “Create with SharePoint List” comes into the picture, which not only auto-codes a custom table “Product Reviews” in Dynamics CRM but moves the list items as its records in Dynamics CRM as well.

The below quick illustration will walk you through the respective step-by-step action/process –

Step 1: Sign In to the Power Apps

Once logged in successfully, select an appropriate environment in which you want to be able to create a Product Review Table –

Step 2: Connect with SharePoint Site

Under the navigation pane, go to Tables >> Create with SharePoint list.

Establish the SharePoint connection-

Now we are navigated to the Connection window where we provide the SharePoint page URL and connect with the SharePoint site with the help of the “Connect” option.… Read More »

The post Create a table in Dynamics 365 CRM from the SharePoint List first appeared on Microsoft Dynamics 365 CRM Tips and Tricks.