A fully integrated HR Inventory Management System built using Microsoft Power Apps, Power Automate, and SharePoint.
The system digitizes the internal giveaway ordering process, enforces real-time inventory control, and automates the full lifecycle of requests — transforming an informal, manual workflow into a structured, scalable, and traceable system.
Standard user interface and admin interface with extended operational controls
Users interact with inventory in real time, submit requests seamlessly, and admins manage the full lifecycle through a unified application.
The HR Inventory Manager handles the complete lifecycle of giveaway requests:
- Employees browse available inventory
- Employees select items and adjust quantities
- Requests are submitted through the application
- Notifications are automatically triggered
- Admins or stock keepers process requests
- Requests are marked as Delivered or Cancelled
- Delivered requests are archived for long-term tracking
The system is designed as a single unified application with role-based behavior, rather than separate apps.
The system follows a layered architecture:
- Employees
- Admins
- Stock Keepers
- Power Apps Canvas Application (responsive UI)
- Power Automate workflows for lifecycle orchestration
- SharePoint Lists for persistent storage
Detailed architecture:
docs/architecture.md
- category-based filtering
- visual inventory gallery
- intuitive item selection
- real-time interaction
- inline quantity adjustment
- cart-based confirmation flow
- validation against available stock
- seamless submission experience
- view incoming requests
- update request status
- manage delivery lifecycle
- maintain operational oversight
- request submission notifications
- cancellation communication
- delivery-based lifecycle transitions
- automatic archiving of completed requests
- desktop
- tablet
- mobile
The UI adapts dynamically to ensure consistent usability across all devices.
| Status | Description |
|---|---|
| Pending | Request submitted and awaiting processing |
| Delivered | Request fulfilled and completed |
| Cancelled | Request terminated before fulfillment |
State transitions trigger automation and data movement across the system.
The system uses SharePoint as the primary data store.
| List | Purpose |
|---|---|
Gift_Stocks |
Inventory source of giveaway items |
Giveaway_Requests |
Active request tracking |
Admins |
Role-based access control |
Stock_Keepers |
Operational stakeholders |
Delivered_Items |
Archived delivery records |
Full schema:
sharepoint/schema.md
The system uses event-driven automation through Power Automate.
- Request notification flow
- Cancellation handling
- Delivery-triggered archiving
Detailed documentation:
powerautomate/README.md
The frontend is built as a Canvas App with:
- responsive layouts
- role-based UI logic
- inline interaction patterns
- real-time SharePoint integration
Details:
powerapps/README.md
This system is built around:
- event-driven architecture
- separation of concerns
- scalability through data archiving
- low-code, high-impact design
- configuration-driven access control
Detailed decisions:
docs/design-decisions.md
hr-inventory-manager/
│
├── powerapps/
│ ├── exports/
│ │ └── hr-inventory-manager.msapp
│ └── screenshots/
│ ├── normal-view.png
│ └── admin-view.png
│
├── powerautomate/
│ └── README.md
│
├── sharepoint/
│ └── schema.md
│
├── docs/
│ ├── architecture.md
│ ├── process-flow.md
│ └── design-decisions.md
│
├── README.md
├── LICENSE
└── .gitignore
- Microsoft Power Apps
- Microsoft Power Automate
- SharePoint Online
- Microsoft 365
This repository contains:
- application structure
- schema documentation
- sanitized screenshots
No confidential or proprietary data is included.
The system can be deployed in any Microsoft 365 environment:
- Create SharePoint lists
- Import Power Apps application
- Configure data connections
- Deploy Power Automate workflows
- Populate role-based lists
This project demonstrates how the Microsoft Power Platform can be used to build a complete internal business system with:
- real-world workflow transformation
- system design thinking
- scalable data modeling
- automated lifecycle management
- role-based application architecture
MIT License — see LICENSE.
Developed as part of a real-world HR workflow automation initiative using the Microsoft Power Platform.