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.
Case Study100%
reduction in manual effort, enabling instant report generation and seamless sharing
50%
faster report generation, optimising SQL views and automating Power BI processes
95%
improvement in data accuracy, ensuring reliable and consistent revenue reporting
70%
increase in user engagement, driving better adoption and interaction with reports
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.
Our 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 Result
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.
Other Case Studies
At Synapx, we’re proud to show how our solutions have transformed the way our clients work and operate. Below you can see our latest client project.
Centralised Subscriber Data Integration with Power Automate
The client approached Synapx for support with the Power Platform through a time-and-materials engagement. The project focused on centralising subscriber data management and streamlining processes. This involved integrating three distinct mailing list forms into a unified database to enable efficient...
Migrating Power BI to Fabric Lakehouse with Medallion Architecture
Mount Anvil approached us with a clear need to automate their processes for managing the transfer of various materials stored in piles between internal and external sites. Their existing approach was heavily manual, involving spreadsheets and phone calls to coordinate...
Power BI Reporting & Power Apps AVC Calculator
The client approached Synapx to provide Power Platform support under a time-and-materials engagement. The project aimed to enhance data analytics and streamline business processes through Power BI implementation and creation of an AV Calculator from Excel to Power Apps,...
Power Platform Center of Excellence Implementation - Power BI
The client approached us in order to implement a reporting system to provide oversight on the implementation of power-platform within their organisation.
Material Management Application with Business Central Automation - Power Apps with Power Automate
The client 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.
Policies and Procedures - Power Apps with SharePoint Documents Library
The client wanted an application to effectively manage their companies policies and procedures from within a SharePoint documents library.
Personnel Directory - Power Apps
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.
Leave Calendar - Power Automate and Power Apps
The client wanted information from their third-party leave calendar tool (Timetastic) embedded within their SharePoint site.
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.
Book A Free Discovery Session
Schedule a FREE call with our power platform specialists.
Book a Discovery Session