Problem

Discipline tracking was inconsistent both within and across factories due to multiple union policies, paper-based processes, and limited HR capacity. This led to delays, inconsistent outcomes, and increased employee grievances.

Users

HR teams and frontline supervisors.

Scale

Initially deployed at a single site, later expanded regionally as part of a standardization effort.

Constraints & Considerations

• Data platform: SharePoint only (Dataverse not available)
• Licensing: No premium connectors or flows (including Word connector)
• Security: Highly sensitive employee data with strict role-based access
• Performance: SharePoint delegation and query limits required careful data access patterns

Solution

I designed and delivered a Power Apps solution optimized for SharePoint’s limitations while maintaining security and performance.

Key decisions included:

• A hybrid, denormalized data model using explicit ID references instead of SharePoint lookups to support more flexible querying and relationships.
• Pseudo-joins performed in-app using targeted gallery logic and temporary collections, carefully scoped to avoid delegation and performance issues.
• A SharePoint-based document templating approach to generate discipline letters without premium connectors. This supported automated document creation, with known limitations around signature handling.
• Role-based access control that allowed HR to manage permissions and reassign incidents while maintaining consistent supervisor roles and restricted visibility.