Middle brough council
Power Apps, Sharepoint — 12

🎯 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 CatalogTransactional Lists: Requests, History, Comments
- Lookup columns ensure relationships
- Cascading dropdowns & ID linking
📊 UI & Wireframe Highlights
Home: Dashboard summary, quick linksRequest 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







