Automating case and data management.

Akita has used SharePoint to create an automated case management system for a company that assists organisations with personnel requirements.

The company was using an existing case management system that combined SQL and Azure technologies. Customer case folders were created manually by users on mapped drives within Azure cloud storage.  Files relating to cases stored were then stored within them.

While Azure offered a secure storage solution, there was no automation in place relating to the creation and deletion of case files once cases were complete. This meant users would need to schedule to delete customer cases manually after a set time had passed.

This process was inefficient from a time perspective and occasionally resulted in data being held longer than was necessary. The system, therefore, needed improvement.

By linking SharePoint to the existing case management system as a replacement storage solution, Akita was able to implement more automation into the process. Now, as a new customer request comes in and is logged in the case management system, a folder is automatically created within SharePoint. All relevant documentation for that case is then subsequently stored within that folder.  SharePoint is an excellent document management system, meaning files can be stored, categorised and searched for with ease.

sharepoint case management

When a case is complete, a couple of automation options have been implemented within the SharePoint management system.

For customers with a short contract, once a case is closed the files are automatically deleted from SharePoint after a set time frame. This ensures that data is not held for any longer than required.

For customers with longer or ongoing contracts, it is occasionally required to look back at previously closed cases. For these customers, completed cases are configured to be automatically archived after a set period of time. This removes all files related to those cases from the customer’s active folder in SharePoint and moves them to an archive area. This prevents the chance of any accidentally use, modification or sharing as part of ongoing cases.

Should previous case documents be required, they can be accessed from the archive area of SharePoint. There is also the option for adding manager permissions to access files held in this area.

The automation of storing and deleting cases within the SharePoint case management system has provided the company with a more efficient and secure way of working, removing any risk associated from retaining documents longer than is necessary.

To discuss a Microsoft SharePoint Case Management solution for your organisation please get in touch:

Contact Us

Other case studies
Case study
SharePoint Hub Site And File Management For International Manufacturer

Group-wide communication and file management using Microsoft SharePoint Online

Case study
Valuation Power App For Automotive Dealership

Assisting an automotive dealership to deliver consistent pricing across their operations.

Case study
SharePoint Communication Site For Golf Charity

Group-wide communication and file management using Microsoft SharePoint Online

Case study
Microsoft Dynamics Support For UK University

Responsive Dynamics support and banked development time for major UK university.

Case study
Incident Management Power App Solution

A Power App solution to replace and improve on ageing incident management software.

Case study
Staff Rostering System In Dynamics 365 and Power Apps Portals

A custom Microsoft 365 staff rostering system for large charity.

Case study
Microsoft Dynamics 365 Implementation And Ongoing Support

Delivering a simplified Microsoft Dynamics 365 offering for a security advisory company.

Case study
Dynamics CRM Migration From On-premise To Dynamics 365

CRM migration strategy, deployment and ongoing support for a London-based booking software company

Case study
Dynamics CRM Projects And Consultancy For Leading UK Retailer

CRM services and support provided for one of the UK’s biggest companies

Case study
Business Expenses Power App For Mobile Workforce

Using Power Apps to simplify administrative tasks can increase working efficiency.

Case study
Central SharePoint Online Calendar For Manufacturer

Simplifying communication and resource planning.

Case study
Microsoft SharePoint Document Management System Refresh

A SharePoint document management system refresh has helped create new working efficiencies for a leading foster agency

Case study
Microsoft SharePoint Online Intranet For Training Company 

Our SharePoint Online Intranet solution has simplified the work processes of a financial services skills company

Case study
Microsoft Power Apps Order Automation Solution

Akita has worked with a Surrey-based catering company on a Power Apps solution to streamline their ordering process.

Case study
Fleet Management Solution In Microsoft Power Apps

Our Microsoft PowerApps solution has helped simplify the management of a vehicle fleet for a busy company, reducing vehicle downtime, improving safety and saving both time and money.

Case study
Dynamics 365 sales solution for manufacturing company

Akita created a custom Dynamics 365 sales solution designed to increase the efficiency of a sales team and simplify the company's ordering and invoicing process.

Case study
CSL Global – ERP solution that streamlines workflows

CSL Global is a leading international provider of marine surveying, consultancy and risk management services.

Case study
Dynamics 365 CRM Sales & Procurement Solution

Surrey-based IPA Purchasing provides purchasing and procurement services for a range of multi-site organisations across the UK.

Preparing for Dynamics 365
Try Dynamics 365 for free

Take a free trial of Microsoft Dynamics 365 and see how it can benefit your organisation.

Starting your free trial is quick and easy, simply click on the link and you will be guided through the process.

Contact Us