Powerapps Simplifies Tool Inspection Process

Case Study

PowerApps simplifies the tool inspection process for a US-based manufacturer.

Download the Case Study

Industry: Manufacturing

Technology: PowerApps

Client Business Description

Our client is a US-based industrial manufacturer that deals in manufacturing hardware tools.

Challenges

As our client is into hardware manufacturing, they wanted to streamline their inspection and quality check process for every individual hardware item they manufacture. They were also required to generate a quality certificate before it was shipped to the customers.
Currently, they use a windows application where they had a large inventory list of the hardware products. It was a tedious process for the staff to choose the product from the large inventory list and receive their inspection status from the existing system. They find the products from their inventory list and manually update the quality status before getting the certificate and shipment of the item and this process was cumbersome and time taking.

Solutions

We suggested developing a quality check application, which we developed with PowerApps as the front end and Azure SQL Server as its back end. We understand the client's requirements in detail and simplified them. The objective was to automate the entire tool inspection process and generate digital certificates in minutes.

We created batches of multiple products. Batches were created customer order-wise. Each batch could have multiple items.

We also save the batch into specific locations- the status of this batch is shown as “created”.

The batch is moved to a second warehouse where the items are inspected. The PowerApps scans the items, so they can be easily inspected using the bar code scanner that is integrated with the hardware.

The items are scanned and inspected using the multiple check properties. The properties have three parameters – passed, failed, or not tested. If everything is passed in the inspection, then the batch status is changed to “passed.”

Now each item generates a specific certificate in this batch. This certificate is printed and packed with the item before shipping to the customers.

Result

Saved Time: The customer saved a lot of time in the manual inspection of these products.
Digitized the process: The client automated their process to improve the accuracy of their inspection process.
Made the search smoother and easier: The bar code scanner integration helped make the search of their tools easier. This eliminated the manual searching process and saved a lot of time.
Improved quality of products: It is now easier to check the quality of the product to determine which batch did not have the quality hardware item.
Saved paper: The system generated digital certificates for each item while saving the paper for printed certificates.
High Efficiency: PowerApps automated the process to ensure a more accurate system to help employees focus on completing high-value tasks.

Technology Stack

Power Apps

MS SQL Server

Power Automate

Print Node

Screenshots

Check Out Our SharePoint Custom Development
Portfolio.

Learn More

How our HR-Directory 365 Helped A Japanese Manufacturing Conglomerate manage and access large data thus saving massive time.

Data analytics company migrates to cloud with a new team site intranet to boost employee engagement

Leading US-based Hospital and healthcare center adopts Custom SharePoint application to manage inventory and Post Covid situation

JSC Consultants leverages web-based custom development solutions to automate risk and action management and help organizations stay ISO 27001 compliant.

Power BI dashboards helped a manufacturing company make better decisions on task and resource allocation

Electronic Device Manufacturing Giant Leverages Power BI to Gain Insights From Their Production And Test Data.

European consultancy firm adopted Microsoft Teams to improve team collaborations across multiple touchpoints

Advisory Company Leverages the Benefits of SharePoint Cloud by Successful Migration from Older SharePoint Version

Africa’s leading staffing company leverages SharePoint Document management system to organize its key company information and improve employee’s productivity