Risk Management with SharePoint Lists
Organisations typically manage their risks assessments in large excel files. These files translate easily into SharePoint Lists, that then lend themselves to providing more functionality.
This is critical to the Planning Clause of ISO 9001 which covers the need to manage risks and opportunities.
A SharePoint List can reflect the same approach to managing risk, with the use of columns to define data that users can selected and calculations relating to these columns.
As an example, a list can contain the ability for users to select Likelihood and Severity scores and then calculate a risk score – this could be done pre and post risk mitigations, with this data also visualised to showcase the thought and actions that have been put into place.
Much like the control of documents, these lists can have their version history enabled, to easily showcase how risks have been adjusted over time – with the aim to bring their risk score down through continual improvement.
Furthermore, risk records can be allocated to business areas or individuals with key dates for renewals or actions.
All data that is recorded can then be used with Power Automate to trigger notifications and escalations, meaning that there will be no risk that is forgotten about. This will evidence the importance of risk management to your auditors and align with ISO 9001 requirements.
Keeping this data within SharePoint will also enable it to be linked with other areas. Therefore, risks can be supplemented with links to Knowledge Articles or Controlled Documents.
Hopefully you can begin to see how each of these elements are beneficial to the organisation, but also, they work well together to build a feature risk and complete Quality Management System.
The use of Power Bi is also beneficial in this area, as reporting on the current risks and opportunities within the organisation, as well as how they are changing can be critical to business KPIs.