From Excel Chaos to Automated Product Lifecycle Management
Using Microsoft PowerApps and Azure Functions to streamline workflows, enhance collaboration, and improve data management.
From Excel Chaos to Automated Product Lifecycle Management
Using Microsoft PowerApps and Azure Functions to streamline workflows, enhance collaboration, and improve data management.
Managing Product Development with Offline Excel Files
The client faced multiple challenges in managing their product development lifecycle with online Excel files: version control issues, limited collaboration capabilities, complex workflow management, inefficient tracking and reporting of progress, and manual data integrity enforcement.
Scaling Product Lifecycle Processes
These challenges hindered real-time updates and the ability to scale product lifecycle processes. The client approached Edstem to develop a PoC for solving these challenges by leveraging possibilities of PowerApps, specifically looking for a low-code solution which can be delivered in a fast-track manner with enough customizations to cater to their needs.
Low-Code Solution with PowerApps & Azure Function
Edstem developed a PoC using Microsoft PowerApps and a custom Azure Function API to address the pain points with data definition, access control, PowerApps UI, and a serverless Python API for complex logic.
Technology Stack
PowerApps-Based Low-Code Solution with Azure Function Integration
The solution was developed in multiple phases including data definition, access control, PowerApps UI, and Azure Function API for version management logic.
Data Definition & Structure
Custom table schemas with relationships derived from existing Excel sheets and automated import compatibility
Access Control & Lifecycle Management
Two levels of access control, including read/write permissions and version lifecycle rules
PowerApps UI & Azure Function Integration
Fast low-code UI development with drag-and-drop elements, integrated with tables and custom serverless API
Data Modeling
Tables with primary and foreign keys reflecting Excel data relationships
Access Control
Read/write permissions and lifecycle management
Low-Code UI
PowerApps screens integrated with data and workflow logic
Serverless Logic
Azure Functions handling complex versioning and workflow processes
Impact & Outcomes
Project completed in just over two months, ahead of the three-month schedule. Replaced manual Excel-based processes with streamlined low-code solution, enhanced collaboration across teams, supported multiple workflows and lifecycle management, robust version control and automated data updates via Azure Function.
Before
- Manual Excel tracking
- Version control issues
- Limited collaboration
- Complex workflow management
After
- Custom PowerApps solution
- Enhanced collaboration and workflow automation
- Serverless API handling versioning logic
- Fast PoC delivery and scalable low-code platform
MORE PROJECTS
