close copilot

Device Tracking Solution with PowerApps

Period
Domain
Team
Tech
2022 - Present
Automotive
1 engineer
Microsoft Power Apps, Microsoft Power Automate, Microsoft Dataverse, Azure Functions

Project Description

Our customer is a telematics provider, which developed proprietary truck hardware that monitors various parameters, including location. Within their operations, tasks like device assembly and disassembly are pivotal. The project aimed to streamline these processes, enabling seamless ingestion of data from device assemblers into a centralized system. This data would then be accessible to administrators and integrated with other IT systems for centralized truck monitoring.

Device Tracking Solution with PowerApps

Problem

The assembly, disassembly, and replacement steps in the business process require manual work. Without a digital tool, it becomes inconvenient to pass information and integrate with the system developed on top of the Microsoft ecosystem. System administrators are also tasked with overseeing data from all assemblers.

Solution

A decision was made to implement a Power Apps solution that could be utilized by assembler employees equipped with mobile devices. This Canvas App included various features for different operations. The data generated from these operations, such as mappings between license plates and device IDs and other crucial data points, was subsequently collected and stored in the Microsoft Dataverse database. Finally, operator employees would utilize a distinct Model-Driven App to oversee this data.

Key Results

  • Canvas App used by assembler employees significantly simplified operations and reduced delays
  • System administrators received a convenient tool to see and manipulate data in Model-driven App.
  • Power Automate flows implemented to perform custom pairing activities via external API calls.
  • High-performing synchronization of data between Dataverse and Azure SQL Database.

Device Tracking Solution with PowerApps

Period
Domain
Team
Tech
2022 - Present
Automotive
1 engineer
Microsoft Power Apps, Microsoft Power Automate, Microsoft Dataverse, Azure Functions
Device Tracking Solution with PowerApps

Project Description

Our customer is a telematics provider, which developed proprietary truck hardware that monitors various parameters, including location. Within their operations, tasks like device assembly and disassembly are pivotal. The project aimed to streamline these processes, enabling seamless ingestion of data from device assemblers into a centralized system. This data would then be accessible to administrators and integrated with other IT systems for centralized truck monitoring.

Problem

The assembly, disassembly, and replacement steps in the business process require manual work. Without a digital tool, it becomes inconvenient to pass information and integrate with the system developed on top of the Microsoft ecosystem. System administrators are also tasked with overseeing data from all assemblers.

Solution

A decision was made to implement a Power Apps solution that could be utilized by assembler employees equipped with mobile devices. This Canvas App included various features for different operations. The data generated from these operations, such as mappings between license plates and device IDs and other crucial data points, was subsequently collected and stored in the Microsoft Dataverse database. Finally, operator employees would utilize a distinct Model-Driven App to oversee this data.

Key Results

  • Canvas App used by assembler employees significantly simplified operations and reduced delays
  • System administrators received a convenient tool to see and manipulate data in Model-driven App.
  • Power Automate flows implemented to perform custom pairing activities via external API calls.
  • High-performing synchronization of data between Dataverse and Azure SQL Database.