Success Story.

Power Platform Transformation for a Leading American Plumbing Manufacturer

About the Client

The client is a major U.S.-based manufacturer of faucets and plumbing fixtures, serving the building materials sector with innovative products and solutions.

Engagement Snapshot

Industry Headquarters Project Technologies

Building Materials USA SharePoint Online, PowerApps, Power Automate, On-Prem SQL

Industry	Headquarters	Project Technologies
Building Materials	USA	SharePoint Online, PowerApps, Power Automate, On-Prem SQL

Business Need

The client’s manufacturing unit struggled with inefficiencies in its product testing and approval processes. Their legacy Nintex-based Parts Testing System was prone to workflow failures, causing business continuity issues and increasing license costs. Manual coordination for testing and approvals across five labs and 250+ users led to delays, data management challenges, and slower time-to-market for new bath accessories.

Key objectives included:

Redeveloping the Parts Testing System on Microsoft Power Platform to streamline workflows and approvals.
Automating test result uploads, approvals, and data exports for better traceability and reporting.
Ensuring robust, role-based permissions and error handling to support business agility and compliance.
Enabling scalability to accommodate future business growth and evolving requirements.

Solution

YASH Technologies delivered a comprehensive solution leveraging Microsoft Power Platform:

Logical and Physical Design: Developed a robust architecture with role-based permissions, session management, and error handling.
Role-Based Access: Implemented permissions within SharePoint lists for secure app administration and enforced mandatory field validation.
Request Management: Enabled users to copy existing requests with pre-populated data for efficient processing.
Workflow Flexibility: Allowed administrators to revert workflow steps for data updates as needed.
Automated Notifications: Configured email alerts and reminders at every workflow stage to keep stakeholders informed.
Data Export: Supported exporting request data in PDF and HTML formats, including compatibility with Chinese characters.
Agile Delivery: Adopted three-week sprints and weekly meetings for iterative, collaborative development.
Code Promotion: Utilized Power Platform’s export/import tools for efficient code management across environments.

Benefits

The new Parts Testing System delivered significant business value:

Uninterrupted Opera

Eliminated workflow failures, ensuring continuous and reliable testing and approval processes.

Automated Communication

Email notifications and reminders replaced manual follow-ups, streamlining coordination across geographically dispersed teams.

Enhanced User Experience

Features like copy request and export to PDF/HTML made request management and reporting faster and easier.

Scalable and Agile

The solution’s architecture and agile delivery enable adaptation to evolving business needs and future growth.

Faster Time-to-Market

Streamlined approvals and automation accelerated the launch of new products.

Improved Data Accuracy

Mandatory validations and role-based controls reduced errors and enhanced compliance.

Download Full Case Study