BOM Management by using Microsoft tool- Share Point/ Power App

@kamran2012

Hello, I will build your BOM management system in Power Apps with a SharePoint backend — multi-level BOM tree up to Level 5, parent-child linking, versioning with lock and draft workflow, and the ECN/DCN approval flow through Power Automate. I will use your existing Excel macros and PPT as the reference for data structure and UI. For the version comparison, I will store each locked BOM as a snapshot in SharePoint so the side-by-side diff pulls directly from versioned lists rather than recalculating — this keeps comparison fast and accurate even with large assemblies. Questions: 1) How many parts does your typical BOM contain at the deepest level? 2) Should the ECN/DCN approval route to a single manager, or does it need multi-level sign-off? Looking forward to discussing further. Best regards, Kamran

@technologiesit

With over a decade of experience leading projects as a Certified WordPress Developer, I understand the intricate ropes of managing multiple tasks and integrating complicated functionalities seamlessly. My team and I have worked on similar integration projects involving complex data handling and streamlining processes, and we are confident we can tailor the designed workflow to your specific needs. Additionally, my team consists of experts in custom SPFx web part development using SharePoint Framework. Implementing BOM comparison logic is our specialty. The color-coded table displaying additions, removals, and quantity changes based on two selected BOMs will provide your users with unprecedented visibility into their data. Essentially, our carefully amalgamated skill-set is specifically aligned with your project requirements

@ffulb

Your Excel-to-SharePoint BOM integration needs Power Automate flows for bi-directional sync between your centralized folder and three SharePoint lists, plus the release management workflow from Draft to Submit for Review status. I'll build the file monitoring triggers, data parsing logic, and status-change workflows using Power Automate and SharePoint Lists. I built something similar with my price aggregation system that processes 800+ products across multiple data sources and generates comparison pages automatically. Also created content automation flows that handle multi-site data sync and status management. You can check out my work at ffulb.com. I can start right away but need to assess your current SharePoint setup and Power Automate environment first. If you can share your Microsoft 365 admin access and SharePoint site details, I'll confirm the best approach and get the flows configured.