Internal Controls Risk Register - Power Apps

The client wanted an application to manage risks within their business by ensuring they had relevant controls in place.

Power Apps

Written by

Agusthi Bakhshi

Published on

August 22, 2023

Customer

UK Asset Management Company

Services

Power Apps

Organisation Size

30

The Challenge

The application aimed to streamline the assignment of risks to owners within the organisation, enabling the addition of multiple controls to manage these risks effectively. It also needed to provide users with a high-level overview of risks, categorised and visualised through pie charts and other graphical elements to highlight areas requiring attention. Additionally, an approval workflow was essential to ensure that the appropriate stakeholders were notified when new risks were logged. To enhance efficiency, the controls could be assigned to multiple risks, minimising redundancy. 

Microsoft Power Apps Logo

Our Approach & Solution

We began by developing a foundational data model, defining the necessary tables and relationships within the application. Collaborating with a UX designer, we carefully planned the layout and user flow, ensuring optimal screen navigation and object placement. Once the design was approved by the client, we built the application using Microsoft Power Apps. 

To streamline the approval process, we integrated Power Automate, which enabled automatic notifications via Outlook and Teams when risks were added or updated. For data visualisation, we explored two approaches: embedding Power BI dashboards or generating visuals directly within the application. After careful consideration, we recommended the most suitable option based on the client’s specific needs. 

The Outcome

Our structured approach resulted in a user-friendly application that efficiently manages risk allocation and control assignment. The integration of an automated approval flow ensures that key stakeholders remain informed, while the visual insights, tailored to the client’s needs, offer clear, actionable data for better risk management. 

Related Case Studies

Take a look at similar case studies stories from our other clients

Personnel Directory - Power Apps

UK Asset Management Company

The client wanted a directory within their SharePoint site to display all their staff members, and provided key contact details such as their phone number and email address.

View Case Study

Material Management Application with Business Central Automation - Power Apps with Power Automate

Renewable Fuel Suppliers

A renewable fuel supplier approached us needing a system to automate their processes for managing the transfer of different materials held in piles between their internal and external sites.

View Case Study

Travel Expense Approval Application - Power Apps

UK Asset Management Company

The client wanted an application embedded within their SharePoint site allowing users to raise and manage their travel expenses.

View Case Study
Automatic expense request and appoval workflow
View All Case Studies