Customer
H. Malone & Sons Ltd.
Technology Services Group
Technology Services Group is a national UK MSP, focused on digitally transforming customers in line with their business objectives. TSG’s SharePoint practice has been successfully deploying solutions for 15 years, and has recently changed the focus to Office 365, with a low/no-code approach, taking customers from migration to Office 365 for files and email, through security, compliance, workflow and automation and apps such as Microsoft Teams and PowerApps.
Learn moreSummary
Malone & Sons Ltd is a leading mechanical services contractor working with construction companies, local authorities, health companies and government departments in the North East region of England. They needed a solution to ensure their workers had secure access to all the information they needed, including those working remotely.
Challenge
Malone & Sons have used Office 365 since early 2017 and decided to expand their use beyond email and the Office package. They required help with auditing over 2,000 properties on behalf of the Byker Trust in the Byker Wall area of Newcastle upon Tyne. They had to securely determine whether the heating and domestic water systems and controls needed improving or even replacing.
Strategy
During a workshop, TSG worked with H Malone to design a business application built on a platform comprised of SharePoint, PowerApps, Flow and Power BI.
Management of the auditing process, from booking and tracking visits through approval and installation was performed using a series of PowerApps forms, Flow workflows, SharePoint lists and Power BI dashboards.
SharePoint lists were used as the data store for all elements of the solution including Addresses, Valuations, Aborted Visits, Tenant Questions, User Permissions etc. Document Libraries are used for storing Work Packages, Invoice and Appointment Letters. Storing the data in SharePoint Online ensured the data was secure and met relevant compliance requirements such as GDPR.
PowerApps provided the mobile workers with the interface required to capture audit information. An application was created using the SharePoint lists as it’s data source, and Power BI was used to create a series of dashboards visualizing audit stages, progress and cost analysis.
Results
With the combination of PowerApps forms, Flow workflows, SharePoint lists, and Power BI dashboards, workers were able to securely and easily access all the information they needed – regardless of their location – to monitor the domestic water systems in Newcastle.
