
Project Overview
We supported the Supplier Assurance Manager of a mid-sized technology services business to develop a solution to automate and standardise a process for requesting, processing and providing recommendations relating to supplier audits.
Microsoft 365 Services




Requirement
Optimising supplier audit processes for efficiency and standardisation
Our customer, the Supplier Assurance Manager in the Procurement team of a mid-size technology services business, faced the challenge of standardising and streamlining the process for assessing supplier audit requests.
The goal was to automate a previously manual and time-consuming task, thereby improving the efficiency of Supplier Assurance admins and reducing overhead.
- Standardise the supplier audit request assessment process
- Automate recurring tasks to save time and resources
- Enhance the efficiency of Supplier Assurance admins
Solution
Innovative automation for effective risk management
A custom SharePoint List was created to store supplier requests and assessment results, with an automation workflow designed to process completed Forms and assign risk scores and levels based on a predefined framework. The system was programmed to automatically provide audit recommendations along with score justifications.
- Audit requests captured via custom Microsoft Form
- Implemented a custom SharePoint List for organised data storage
- Developed a sophisticated Power Automate workflow for risk assessment
- Enabled automatic audit recommendations with justifications
Outcome
Transformative results in supplier audit management
The new system now efficiently manages dozens of supplier requests per week, significantly improving throughput. Assessments that once took hours are now auto-completed in minutes, allowing Supplier Assurance admins to review results quickly instead of spending hours on manual evaluations.
- System now handles numerous requests weekly with improved efficiency
- Assessments are completed swiftly, within minutes
- Supplier Assurance admins’ review time reduced from hours to minutes