Middle brough council

Power Apps, Sharepoint — 12

Hero Image
IT Service Management System

🎯 Project Objective

Develop a centralized Power Platform-based system for handling IT requests, incidents, assets, and approvals within an enterprise setup.

🧩 Functional Modules

🔹 1. Ticket Management
- Submit new service or incident requests
- Auto-assign by department/category
- Track status: Open → Assigned → In Progress → Closed

🔹 2. Service Catalog
- Predefined service request options
- Dynamic form based on selected service

🔹 3. Asset Management
- Maintain IT inventory with details
- Linked to ticketing for asset-based requests

🔹 4. User Roles & Views
- End Users: Submit and view their tickets
- IT Team: View, update, close assigned tickets
- Admins: Full control + dashboard + assignment

🔹 5. Workflow Automation
- Email alerts on request submission and assignment
- SLA violation notifications
- Daily checks for pending/overdue tasks

🧱 SharePoint Architecture

Master Lists: Users, Departments, Categories, Assets, Service Catalog
Transactional Lists: Requests, History, Comments
- Lookup columns ensure relationships
- Cascading dropdowns & ID linking

📊 UI & Wireframe Highlights

Home: Dashboard summary, quick links
Request Details: Timeline, updates, asset info
Admin Panel: Assign/filter/view all tickets

🔐 Security & Permissions

- SharePoint item-level access (user sees only their tickets)
- PowerApps role-based UI (Admins, Technicians, Users)

📦 Deliverables

- PowerApps Canvas App (.msapp)
- SharePoint Lists (import-ready)
- Power Automate Flows (.zip or JSON)
- Deployment Guide + Training Material

Gallery