According to Wikipedia, a CRM is a Customer Relationship Management approach to managing a company’s interaction(s) with current and potential customers.
Although there are several dominant players in the CRM space today offering full-blown products for managing these interactions, I was recently asked to come up with a CRM Light version using current tools and provisioning capabilities in SharePoint Online and Office 365. After all, why not use the tools already available to you instead of purchasing another? Now that I’ve seen this entire solution built end-to-end, I’m confident it would suffice for many organizations’ CRM needs.
Credit: The approach to this solution was based on a session given by Drew Madelung and Vlad Catrinescu at the Microsoft Ignite 2018 session titled: From start to finish: How to create your modern SharePoint site provisioning solution
This is part 3 of a 3-part blog post series to show the final product.
In part 1, we designed the site and information architecture and determined the overall process for the solution. In part 2, we built the components of the solution. Now, it’s time to see it in action!
- Part 1: CRM Light in Modern SharePoint. The Design.
- Part 2: CRM Light in Modern SharePoint. The Build.
- Part 3: CRM Light in Modern SharePoint. The Execution. (this post)
- Add an item (new Current customer) to the Customer Details list
- Microsoft Flow will automatically run and invoke the Azure Runbook
- Azure Runbook will provision the site (and a few other things)
- Email will be sent to the requester and Customer Account Rep
- Voila! We’ve built a CRM-Light!
To demonstrate this, I’ll add a new Manufacturing Customer called Tailspin Tools in the East Region.
Add a new Customer
Alternatively, a customer lead can also be added with a Potential status (like XYZ Enterprises above). Once the customer has been won, the end-user would update the customer status to Current which would trigger the Flow to provision a Customer site.
Before the site is provisioned, the top navigation in the Customer Hub looks like this under the Manufacturing navigation node:
Microsoft Flow Runs
The Flow will run and invoke the Azure Runbook. It passes several parameters to the Runbook based on what the end-user entered in the list. (Customer Name, Account Rep, Navigation Node – based on the Industry they selected, and a Site URL built from the Customer Name)
Azure Runbook Runs
This is the brains of the solution. Based on the input parameters (image), it provisions a new Modern Team site, applies the Site Design (including adding the Customer Contacts list), adds the Account Rep identified in the Customer Details list item as an Owner, and adds the new site to the Customer Hub’s navigation under the Manufacturing navigation node.
Control returns to Flow
Customer Hub is the “CRM Light”
It has all Customer Sites joined to it which means it is now our new CRM Light. Here are some advantages to the Hub model:
- Search is now scoped to all Customer Sites in the Hub
- Hub navigation will automatically include a link to all Customer Sites organized by industry vertical
- The Customer Details list can be sliced and diced by industry vertical and region (and you could include many more pieces of metadata as required)
- Contacts from across all Customer Sites can be surfaced on the Customer Hub in a Highlighted Content Web Part with a Type of Contacts
- All Customer sites will link back to the Hub with shared navigation
- Using site designs, we can continue to configure a consistent Information Architecture(IA) across all Customer sites joined to the Hub allowing us to customize it to suit the needs of the organization
- We can include master templates on the Customer Hub for all sites to have access to:
My Parting Thoughts
Although this post series was a prescriptive design for a CRM Light, the same technique could be used for many other use-cases. If you have more sophisticated site requirements, you could add a PnP provisioning template into the Azure Runbook as was demonstrated by Drew and Vlad in their Microsoft Ignite 2018 session. You may want to look at that option if you have advanced CRM capabilities requiring a higher level of customization.
The possibilities are endless with this combination of tools and I can’t wait to build more solutions using them!
Thanks for sticking with me. 🙂