Full Guide to Creating A CRM within SharePoint

Step-by-step Guide: How to Set Up a CRM Using SharePoint

How-To Guides / Internet & Security

Step-by-step Guide: How to Set Up a CRM Using SharePoint

In today’s competitive business scene, good Customer Relationship Management (CRM) is more than simply a tool—it’s the lifeline that nurtures long-term relationships with clients and drives success. As the digital world reshapes the way we do business, integrating CRM with familiar and robust technologies is more than a luxury; it’s a strategic advantage.

Recognising the critical role that a well-integrated CRM can play in a company’s success, we’re exploring how to build up a CRM using SharePoint and Microsoft’s Power Automate..

What To Consider Before Setting Up a CRM

Diving headfirst into setting up a CRM without a plan is akin to sailing without a compass. It’s essential to anchor your strategy by evaluating key elements beforehand:

Define Your Objectives

What do you wish to achieve with your CRM? Whether it’s tracking sales leads, monitoring customer feedback, or managing support interactions, having clear goals will guide your setup process.

Data Assessment

Understand the nature and structure of the data you’ll be handling. This will determine how you design lists, libraries, and metadata in SharePoint, ensuring that the system is intuitive and efficient.

User Experience

Consider who will be using the CRM. An interface tailored to its users, whether they are sales representatives, customer support agents, or managers, can greatly enhance user adoption and effectiveness.

Integration with Existing Systems

Evaluate which of your current tools and systems need to be integrated with the CRM. This ensures data consistency and avoids unnecessary duplications.

Taking the time for these considerations ensures that your SharePoint and Office 365 CRM aren’t just functional but also optimised for your specific business needs.

How to Create a SharePoint Site

Creating a SharePoint site is a fundamental step as it serves as a central space where your CRM data and processes will reside.

Access SharePoint:

Log in to your SharePoint Online environment.

Navigate to Site Creation:
  1. On the SharePoint homepage, click on ‘+ Create site’.
  2. Alternatively, from the SharePoint Admin Centre, go to ‘Sites’ and then ‘Active Sites’. Here you’ll find an option to ‘Create’.
Choose Site Type:
  1. Team Site: Ideal for collaboration. It creates an Office 365 group, enabling shared resources like a mailbox and calendar.
  2. Communication Site: Suited for broadcasting news, reports, and other information within an organisation.
Fill in Site Details:
  1. Site Name: Choose a descriptive name (e.g., “Company CRM”).
  2. Description: Provide a brief description of the site’s purpose (optional but recommended).
  3. Site Address: This will be auto-generated based on the site name, but you can modify it.
  4. Language: Select the default language for your site.
Additional Settings:
  1. Privacy Settings: Decide if the site should be private (accessible only by members) or public (accessible to everyone in the organisation).
  2. Site Template: While SharePoint provides various templates, for CRM purposes, a default team site template would suffice.
  3. Click ‘Finish’: Once all details are in place, click on ‘Finish’ to create your site. It will take a moment to set everything up.

Once you have your SharePoint site set up, there are a few basic necessities you ought to know to get the most out of your CRM.

How to Create Lists in SharePoint

Lists are at the heart of SharePoint. They allow you to organise data in rows and columns, similar to a spreadsheet but with added functionalities.

Steps to create a list:

  1. Go to your SharePoint site.
  2. Click on ‘Site Contents’ from the left navigation.
  3. Click ‘+ New’ and then select ‘List’.
  4. Name your list and add a description if required.
  5. You’ll then be taken to your new list, where you can add columns and customise its structure.
Building a Folder System in Document Libraries

Document Libraries in SharePoint are used to store, organise, sync, and share documents.

Steps to create a folder system:

  1. Go to ‘Site Contents’ and choose your document library or create a new one.
  2. Once inside, click ‘+ New’ and then ‘Folder’.
  3. Name the folder appropriately.
  4. Navigate inside the folder to create sub-folders if needed.
  5. Use the ‘Move or Copy’ option to organise your documents within folders.
Understanding Views in SharePoint

Views allow you to create customised presentations of lists or library items, making it easier to see specific items in a meaningful way.

To create a view:

  1. Navigate to your list or library.
  2. Click on the ellipsis (…) or ‘All Items’ in the current view.
  3. Click on ‘Create a new view’ and define its parameters.
  4. Now, with these basics in place, let’s delve into setting up a CRM system in SharePoint.

What To Include in Within Your Sharepoint Site

1. Lists and Libraries

a) Contacts List:

  1. Go to Site Contents > New > List.
  2. Name it “Contacts”.
  3. Add custom columns like “Contact Type” (Client, Lead, Vendor).

b) Deals/Opportunities List:

  1. Create a new list and name it “Deals”.
  2. Columns: Deal Name, Deal Amount, Expected Close Date, Contact (lookup from Contacts List).

c) Tasks and Activities:

  1. Use the built-in “Tasks” list or customise a new one.
  2. Columns: Task Name, Due Date, Assigned To, Related Contact/Deal (lookup)

2. HR Section

a) Employee Directory:

  1. Create a list named “Employees”.
  2. Columns: First Name, Last Name, Role, Email, Phone.

b) Onboarding Materials Library:

  1. Create a document library for training materials.
  2. Organise with folders or metadata.

c) Employee Feedback and Survey:

  1. Use Microsoft Forms integrated with SharePoint for feedback collection.
  2. Store results in a dedicated list.

3. News and Updates

a) Announcements List:

  1. Use the built-in “Announcements” list.
  2. Share updates on company news, CRM changes, and sales achievements.

b) Calendar:

  1. Use the built-in SharePoint calendar.
  2. Mark important dates like product launches, team meetings, or client visits.

c) Discussion Board:

  1. Foster team communication with the built-in “Discussion Board” list.


a) SharePoint Views:

Create custom views in lists to show relevant data (e.g., “Open Deals”).

b) Use SharePoint Web Parts:

Showcase the CRM data visually using charts, graphs, and summary links.

c) Integrate Power BI:

For advanced analytics, integrate Power BI dashboards directly into SharePoint.

Additionally, as Power Automate allows the automation of routine tasks across SharePoint, other Microsoft 365 services, and third-party services, we recommend integrating it with your SharePoint CRM system.

Set up Microsoft Power Automate Tool

 Power Automate
  • Sign in to Power Automate (previously known as Microsoft Flow) using your Office 365 account.
  • Create workflows:
    • Define triggers: Specify events that start the workflow.
    • Add actions: Set up what should happen when the trigger occurs.
    • Configure conditions: Implement logic to make the workflow conditional.
  • Test and deploy your workflows.
  • Automate tasks like email notifications, document approvals, and data synchronisation.

Manage Permissions: SharePoint permissions for the linked document library or list will be inherited by the Teams channel. You can manage permissions in SharePoint, and they will apply to Teams as well.

Our guide covers the basics of CRM setup using SharePoint. You can integrate your CRM with Sharepoint using our step-by-step instructions. Furthermore, you may combine Microsoft technologies like Power Automate, Teams, and Outlook to improve company productivity. Businesses can go deeper into customisation, third-party integrations, and advanced automations based on their needs.

Or, if you need additional help with it, we are here to support you. Contact Us Now!