📌 Project Overview

This custom application serves as a single entry point for managers and team leads. It provides an intuitive navigation hub that connects daily utilization dashboards, manager-level submission forms, and new employee onboarding data directly to a centralized SharePoint backend.

📱 Application Structure & Key Pages

1️⃣ Main Navigation Hub (Landing Page)

The primary screen features a clean, user-friendly interface with 3 main navigation controls:

Employee Utilization Dashboard Button: Directs users to the real-time utilization analytics view.

Daily Data Entry Button: Navigates to the manager submission form.

New Employee Onboarding Button: Opens the form to register new employees into the database.

2️⃣ Employee Utilization Dashboard

A centralized monitoring view designed to assess team bandwidth at a glance:

Categorized Bandwidth Tracking: Filters and displays employees categorized by Fully Utilized, Under-Utilized, and Partially Utilized status for any selected day.

Actionable Insights: Enables resource managers to identify available capacity and reallocate project hours effectively.

3️⃣ Daily Utilization Entry Form (Manager Portal)

An efficient form tailored for managers to submit individual employee utilization records:

Manager Submissions: Allows managers to select team members, input hours worked, assign project codes, and log daily status.

SharePoint Integration: Submits entries directly to the backend using optimized form submission logic to ensure data integrity.

4️⃣ Employee Directory & Onboarding Form

A structured data entry interface to expand and maintain the team directory:

New Employee Registration: Captures essential details (Name, Department, Role, Target Capacity, Join Date).

Live Database Sync: Instantly creates a new record in the primary SharePoint Employee List upon submission.

🛠️ Tech Stack & Architecture

Frontend / UI: Power Apps (Canvas App)

Backend Database: SharePoint Online Lists (Employee Master List & Daily Utilization Logs)

Functions & Formulas: Navigate(), SubmitForm(), Patch(), Filter()

📈 Key Benefits & Business Impact

Centralized Navigation: Eliminates complex menus by providing a clean, 3-button landing hub.

Improved Capacity Planning: Gives managers immediate visibility into under-utilized team members to rebalance workloads.

Seamless SharePoint Sync: Ensures reliable, real-time data entry for both daily utilization and employee onboarding.