PROJECT OVERVIEW
Apollo had long used SharePoint to manage various production and quality processes. Microsoft’s suite of Cloud technologies, including PowerApps, Flow, SharePoint Online and Azure SQL Server, made a compelling case to begin creating cloud-based services and moving away from on-premise servers.
THE CHALLENGE
A key process at Apollo is the requesting and tracking of sample testing from their in-house laboratory. This is an important process to manage efficiently to ensure that testing is done in a timely way, and that results are fed back accurately.
Apollo was running a number of similar processes on legacy servers and wanted to begin moving these onto a modern platform whilst re-using current in-house technical skills.
THE SOLUTION
Transparity delivered PowerApps sample testing cloud migration, moving legacy request and tracking workflows to Microsoft Power Platform for Apollo. Built with Power Apps, Power Automate and SharePoint Online (with Azure data services), the new solution streamlines submissions, approvals and reporting while improving visibility and auditability.
Taking advantage of Apollo’s Office 365 infrastructure, an integrated SharePoint Online, PowerApps and Power Automate solution made sense for the business. This gives people seamless access to the system with no new passwords to learn, meaning that users can easily access the system from any location. Power Automate takes care of all of the messaging, letting people know when a sample has been received, when a test has been carried out and what the results were, providing quick links to test results.
THE IMPACT
Moving Apollo’s process into the cloud means that new technologies can be rapidly and consistently trialed in a low-risk environment. This means that the IT team can focus more of their time on creating new tools to help the business, and less time maintaining and upgrading on-premise servers.
The project ran extremely smoothly, with the new PowerApps system providing all of the functionality needed to manage service requests efficiently. The notifications that the system provides deliver the required information in a timely way. In addition, the reporting capabilities of PowerBI mean that administrators can quickly access system logs to look at how the system is being used, and to check for issues.
As a result of this successful implementation, we went on to work with Apollo Fire to build an audit management process, product testing Power Apps, and a SharePoint intranet.
