Feature: MDDUS Workflow Automation

Learn how MDDUS, a leading professional defence organisation, modernised their workflow solution with a combination of Azure Logic Apps and a bespoke Web API, MARS, to address their unique requirements.

About MDDUS

The Medical and Dental Defence Union of Scotland (MDDUS) is a UK-based mutual defence organisation providing professional indemnity, expert advice, and support to doctors, dentists, and other healthcare professionals. With over 100 years of experience, MDDUS plays a critical role in protecting healthcare professionals' professional and financial interests.

The Challenge

  • Legacy Limitations: Nintex workflows were outdated and did not align with MDDUS's future technology strategy.
  • Scalability: Managing workflows across multiple departments and systems required a more robust solution.
  • Cloud Integration: A modern system was needed to bridge on-premises SharePoint 2019 with cloud platforms like Microsoft Azure.
  • Security and Compliance: As a highly regulated organisation, MDDUS required a secure and compliant solution for handling sensitive data.

Workflow Automation Diagram

MDDUS Workflow Diagram

This diagram illustrates the interaction between users, SharePoint 2019, Azure Logic Apps, and the MARS Web API.

Azure Logic Apps

Azure Logic Apps were leveraged as the core workflow engine, providing:

  • Cloud-hosted automation with secure integration to on-premises systems via Microsoft Gateway.
  • Triggers based on metadata changes or file additions in SharePoint 2019 libraries.
  • Customisable polling intervals for efficient workflow triggering.
  • Centralised management through the Azure portal.
Learn More

MARS Web API

A custom-built Web API named MARS was developed to address Logic Apps' limitations with on-premises SharePoint 2019:

  • Developed in C# and hosted securely as a Web API using OWIN.
  • Provided advanced file management operations: copy, move, delete, and folder creation.
  • Facilitated secure interaction with the proprietary DECISIONS API through internal HTTP requests.
  • Integrated with SharePoint CSOM for comprehensive file and folder management.
  • Implemented secure credentials management using Windows Credential Manager and robust logging for troubleshooting.

The Result

The hybrid solution combining Azure Logic Apps and the MARS Web API enabled MDDUS to:

  • Replace legacy Nintex workflows with a modern, scalable, and future-proof solution.
  • Streamline workflows and enhance automation across departments.
  • Maintain secure and compliant handling of sensitive healthcare data.
  • Position their systems for future growth and technological advancements.

This project highlights how a tailored approach leveraging Microsoft technologies can transform organisational operations while maintaining strict compliance and security standards.