Power Apps - Contract Management System

This company approached us after becoming frustrated with their data quality. They were spending large amounts of time sifting through unorganised, messy data.

We worked closely with their Ops director and Database Administrators to provide a service which met the needs of users across the business to ensure ease of access and usability within the new system provided by Synapx.

Power Apps

Written by

Agusthi Bakhshi

Published on

February 22, 2023

Customer

Financial Services client

Services

Power Apps

Organisation Size

400

The Challenge

The Financial Services client used a local Microsoft Access database to store all of their client and supplier contracts. Only their legal team had access, with data only added after a contract has been signed. Data quality was extremely poor with limited access to the rest of the business, therefore there were difficulties maintaining the system when data attributes changed.

All data was held within 1 giant table, rather than being split (normalised) and held in multiple tables causing issues with speed and quality of data when attempting to query. There was also a lack of end-to-end processes within the business, resulting in delivery status issues and duplicated/wasted effort. A local file server was used to store contract documents, however, there was no relationship between the contract files and database records resulting in a mismatch of records and difficulty querying.

Our Approach & Solution

Synapx created an application using Power Apps and integrated the company’s SharePoint document library using Power Automate. Our approach was to first normalise the structure of the existing Microsoft Access database into multiple tables presented in an ER diagram which we then built in Microsoft Dataverse. We then implemented a multi-level permission model for their data to ensure relevant access to files and data for the various departments that existed within the business.

We set up a Microsoft SharePoint library and used Power Automate to create/update folders within the SharePoint library as/when contracts were added or updated within the Power Apps application, along with applying the same multi-level permission model to the relevant folders. We facilitated a link between the folders and records by providing a URL for each contract held within the relevant SharePoint documents library folder against the relevant record within the Power Apps application helping users find relevant documents. We implemented a systematic process within Power Apps to ensure each record had a clear status and additional required information, which we then provided within a new Power BI dashboard to provide the business with better visibility.

The Outcome

The business now has an organised repository allowing users to access and amend data relevant to them, with a degree of trust in the data they’re using. Given the multi-level permission model on the data, users will see data relevant to them and their needs rather than having to navigate through numerous records, which saves employees time and ensures better security for their data.

Management also now has better visibility and oversight of their contracts through the Power BI reporting elements we were able to provide them with. As Power Platform Specialists we were able to ensure we applied best practices when tailoring the power platform products we used to implement this solution.

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

Internal Controls Risk Register - Power Apps

UK Asset Management Company

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

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