Preventive Maintenance System

The Preventive Maintenance System is a user-friendly Power Apps solution designed to efficiently manage and track asset maintenance activities. It enables technicians and administrators to monitor maintenance schedules, submit requests, record work updates, and ensure timely servicing of equipment. The system helps improve operational reliability and reduces unexpected breakdowns through scheduled preventive tasks.

Key Features:

1. Maintenance Scheduling
- Schedule preventive maintenance tasks for each asset by setting due dates and next maintenance dates. This feature ensures proactive maintenance rather than reactive repairs, helping reduce equipment downtime and increasing asset lifespan.

2. Asset Management
- View and manage all organizational assets in one place. Users can select assets from a dedicated screen and see associated maintenance records. The system allows linking asset IDs with scheduled tasks, enabling quick lookups and streamlined operations.

3. Technician Management
- Add, edit, and manage technician profiles, including their name, email, phone number, and unique technician ID. When a technician is added, their ID is linked to multiple tables, ensuring centralized data management and easier task assignments.

4. Work Record Logging
- Technicians can view and update work records including asset ID, technician details, issue description, task status, completion date, and more. This log ensures full traceability and acts as a historical reference for every maintenance action performed.

5. Dashboard Overview
- A clean, informative dashboard screen displays summarized maintenance activity, including upcoming schedules, pending tasks, and completed requests. It acts as the central hub for monitoring the system's performance and updates.

6. Interactive Side Menu
- A reusable side menu component offers easy navigation to important screens including Home, Details, Maintenance, Technician, and Technician Details. The menu uses icons and labels and enhances usability across all devices.

7. Search and Filter Capabilities
- Users can quickly locate specific records using the search input feature on gallery screens. It helps in managing large volumes of maintenance data efficiently without manual scrolling or filtering.\

Key Challenges:

1. Manual Maintenance Tracking
- Prior to this system, maintenance schedules and records were managed manually using spreadsheets or paper-based logs, increasing the risk of missed maintenance and asset downtime.

2. Lack of Real-Time Updates
- There was no centralized way to track technician assignments, work progress, or status updates, leading to communication gaps and delays in addressing issues.

3. Difficulty in Asset History Management
- Without a unified digital system, accessing historical data of asset maintenance, completed tasks, and technician logs was time-consuming and error-prone.

4. Limited Reporting and Visibility
- Managers lacked real-time dashboards and insights into maintenance trends, completion status, or technician performance, affecting decision-making.

5. Inconsistent Technician Data Recording
- Technician details were scattered and not linked efficiently to maintenance records, making it hard to track performance, assign tasks, or contact the right personnel.


Benefits to Organizations:

1. Reduced Downtime and Increased Asset Lifespan

- Regular and timely maintenance reduces equipment failures, enhancing performance and extending asset life.

2. Improved Efficiency and Productivity

- Automating task assignments, technician tracking, and updates streamlines operations and saves manual effort.

3. Better Decision-Making with Real-Time Insights

- Dashboards and records provide managers with accurate data to plan, prioritize, and allocate resources effectively.

4. Enhanced Accountability and Compliance

- Centralized records ensure transparency, technician accountability, and easier compliance with industry standards.