
Geschlossen
Veröffentlicht
Bezahlt bei Lieferung
Phase 1: Meta BOM Data & SharePoint Structure This phase focuses on getting the initial meta-Parts data into the system and setting up the foundation. Excel as the Source: Specified that the master BOM data will start in Excel files located in a centralized folder (Ex: C:\Input Data\BOM). This is a crucial step. A Power Automate flow can then be set to trigger whenever a new Excel BOM is added or modified in that specific library. Data Flow to SharePoint: A Power Automate flow will read the new/updated Excel file, identify the header and line items, and populate into three SharePoint lists: BOM Header List , BOM Parts List, Part Master List (for all required data) Bi-directional Sync ("vice versa"): Mentioned that creating a new part in the system should feed back to the centralized Excel BOM. This is achievable. A second Power Automate flow can be triggered when a new item is created in to SharePoint Part Master list. This flow would use the "Excel Online (Business)" connector to find the correct Excel file in the document library and add the new part number as a new row. Phase 2: Release Management Process The workflow is very well-defined and perfectly suited for Power Automate. Here is exactly how it would be built: Initial State: When parts are created from Excel, the flow will set their default status in SharePoint to "Draft". Trigger: The Designer changes the status of an assembly from "Draft" to "Submit for Review." This change triggers the main Power Automate release workflow. Validation (CN Number Check): The very first step in the flow will be to check if the CN Number field for that assembly is filled in. As you stated, releases only happen based on a CN Number. If the field is empty, the flow will stop, change the status back to "Draft," and email the Designer with an error message: "Please assign a CN Number before submitting for release." First Approval (Design Lead): The flow uses the "Start and wait for an approval" action and assigns the task to the Design Lead. The Design Lead receives an email and a Teams notification with "Approve" and "Reject" options. If Rejected, the flow changes the status to "Rework (Design)" and sends a notification back to the Designer with the Design Lead's comments. The workflow ends until the Designer resubmits. If Approved, the flow proceeds to the next step. Second Approval (Project Manager): After Design Lead approval, the flow assigns a new approval task to the Project Manager. If Rejected, the flow changes the status to "Rework (PM)" and notifies the Designer with the Project Manager's comments. If approved, the flow moves to the final step. Final Release Selection (by Designer): Upon Project Manager approval, the flow will send a final email to the original Designer. This email will contain links that, when clicked, set the final release status. This gives the designer control over selecting the flag. The links could be: "Set status to Preproduction (Yellow Flag)", "Set status to Tooling Kick Off (Green Flag)", or "Set status to Production (Dark green Flag)". Once the designer clicks a link, the status is set, the item is locked from further editing, and the workflow is complete. Phase 4: BOM Compare - This feature directly addresses a key user need. Technical Implementation: This functionality requires custom logic that is beyond standard SharePoint web parts. As we discussed previously, this is the perfect use case for a custom SharePoint Framework (SPFx) web part. User Process: The user would open the BOM Compare page, be presented with two dropdown menus (populated from your BOM Header list), and select the two BOMs they want to compare. Backend Logic: The SPFx code would then fetch all the child items for both selected BOMs from the BOM Parts List. It would compare the two lists of child parts to identify additions, removals, and quantity changes, and then display the results in a color-coded table.
Projekt-ID: 40106216
13 Vorschläge
Remote Projekt
Aktiv vor 2 Tagen
Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
13 Freelancer bieten im Durchschnitt ₹7.885 INR für diesen Auftrag

As a seasoned Full stack developer with 7 years of experience, I have worked extensively with Excel, Power Automate, and SharePoint specifically for tasks like yours. More importantly, I specialize in digital processes that are aimed at creating efficient work flows. Your Meta BOM Data Integration and SharePoint Setup is a perfect fit for my skill set as it requires deep expertise in all these areas. My approach to projects is one of complete dedication to customer satisfaction. That means you can be assured of my commitment to providing the lowest possible time span for your project while maintaining high quality outputs. Having worked with reputed firms like Metlife GOSC, DXC technologies and Elite Services, I understand the importance of data integrity in critical business processes-just like yours. With my honest and transparent communication style matched only by my work's quality, I am genuinely looking forward to building a long-term relationship if selected. I am also happy to offer you four additional days of support after project completion to ensure everything is working smoothly
₹12.000 INR in 5 Tagen
8,5
8,5

Dear Sir, I hope this message finds you well. With 15+ years of experience in Project Management, I’m confident I can bring value to your project by leveraging advanced tools like ClickUp, JIRA, Asana, and monday.com. These tools have enabled me to streamline workflows, optimise efficiency, and enhance project execution. I have successfully led both web and mobile development projects, overseeing all phases to ensure timely and on-budget delivery. My expertise in automation tools has further allowed me to reduce manual tasks and improve team collaboration, driving consistent project success. Clients have praised my commitment to delivering high-quality results and maintaining transparent communication. In addition to technical skills, I offer training in project management and automation tools, empowering teams to excel in their roles and achieve project goals more efficiently. I am eager to collaborate and confident in my ability to help you achieve your vision. Let’s discuss how we can work together to make your goals a reality. Best regards, Zayer Tech
₹7.000 INR in 7 Tagen
6,8
6,8

Greetings, With over 15 years of experience as a technology and business professional, I am confident that I can help you with SharePoint. I have a deep passion for SharePoint and have worked extensively with all versions, including SharePoint Online (Office 365). I have expertise in related Microsoft technologies such as Power Automate (Flow), Power BI, and Power Apps. By leveraging these tools, I have built comprehensive and integrated business applications that are robust and efficient. My proficiency extends to customization on SharePoint Server 2010/2013/2019 using Visual Studio C#, as well as implementing applications in ASP.NET with SQL Server Database integration. I also possess knowledge of Nintex Workflow, which further enhances my capabilities in workflow automation. I have had the privilege of serving as a Project Lead for prestigious organizations such as: -Ministry of Education Dubai, -Ministry of Social Affairs Dubai, -Public Portal for EmiratesAirlines, -Ministry of Finance Portal for the Diplomatic -Institute of Qatar, Office 365 Portal for LogicalOutcomes Canada. I firmly believe in following best practices and leveraging my extensive experience to guide organizations in avoiding common pitfalls. Come over and chat to discuss the deliverables and deadline. Rahim
₹12.500 INR in 7 Tagen
4,7
4,7

Hi there, I’ve carefully reviewed your phased approach—from Excel-driven BOM ingestion and bi-directional SharePoint sync to the CN-based release workflow and multi-level approvals. I can implement these Power Automate flows cleanly, ensuring draft-to-release status control, validations, and secure approvals via Email/Teams. For the BOM Compare requirement, I’ll build a custom SPFx web part to accurately compare BOMs and highlight adds, removals, and quantity changes in a clear, color-coded view. My focus will be a scalable, well-documented solution that fits naturally into your SharePoint environment. Looking forward for your positive response in the chatbox. Best Regards, Arbaz H
₹7.000 INR in 7 Tagen
2,5
2,5

Hi, I can help with this task. Ready to start immediately.
₹1.500 INR in 1 Tag
0,0
0,0

I read job description and I can do your project. J can even work on urgent basis and complete your project soon.. contact me.
₹7.000 INR in 7 Tagen
0,0
0,0

I am a mechanical Engineer and I also knownlage about design CAD Cam............. ..............,............. ..............,............. ................,.............
₹7.000 INR in 7 Tagen
0,0
0,0

I am a data entry freelancer. I can do data entry, copy-paste work, Excel, and web research. I work carefully and always try to give correct work. I complete tasks on time and follow instructions. Client satisfaction is important to me.
₹7.000 INR in 7 Tagen
0,0
0,0

Hello, I can deliver a complete BOM management and release automation solution using SharePoint, Power Automate, PowerApps, Excel, and SPFx within 15 days. Phase 1 – BOM Data Foundation: Centralized Excel BOM files as the source. Power Automate flows will detect new/updated files, extract header and line data, and populate BOM Header, BOM Parts, and Part Master SharePoint lists. A reverse sync flow will update Excel when new parts are added in SharePoint. Phase 2 – Release Management Workflow: Items are created in Draft status. On “Submit for Review,” CN Number validation is enforced. The workflow includes Design Lead and Project Manager approvals with rework handling. After final approval, the Designer selects the release status (Preproduction, Tooling Kick Off, Production), after which the BOM is locked. Phase 4 – BOM Compare: A custom SPFx web part will allow users to compare two BOMs, highlighting added, removed, and quantity-changed parts in a color-coded table. Cost: ₹10000 (Fixed) Timeline: 15 Days I ensure clean architecture, reliable automation, and clear documentation. Best regards, Meghana
₹10.000 INR in 15 Tagen
0,0
0,0

I have more than fifteen years of solid experience in SharePoint, including SharePoint Online development and architecture + solid experience in customizing SharePoint forms using Power apps and building Power Automate Flow. I have worked on 50++ projects for customers around the world. These projects include building SharePoint sites/lists/libraries, building business processes using Power Automate Flow, customizing SharePoint lists using Power App, writing Remote Event Receivers, migrating data from SharePoint on-premises to SharePoint Online, migrating data from SharePoint Online to SharePoint Online (same tenant and different tenants), building SPFx web parts, building custom connectors for Power Platform & building Copilot Agents using SharePoint Agents and Copilot Studio. I have also worked on many projects as a SharePoint architecture to set up the SharePoint design, best practices for building the different sites, the policies and setting regarding these sites
₹7.000 INR in 7 Tagen
0,0
0,0

Pune, India
Mitglied seit Aug. 30, 2025
₹1500-12500 INR
₹600-1500 INR
₹12500-37500 INR
$14-15 NZD
$30-250 AUD
₹600-1500 INR
€30-250 EUR
$250-750 AUD
$10-30 CAD
₹750-1250 INR / Stunde
₹12500-37500 INR
$15-25 USD / Stunde
$8-15 USD / Stunde
₹750-1250 INR / Stunde
₹12500-37500 INR
€12-18 EUR / Stunde
₹1500-12500 INR
₹1500-12500 INR
€400-600 EUR
₹600-1500 INR
$15-50 USD / Stunde
$15-25 USD / Stunde
₹1500-12500 INR