web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to automatically r...
Power Automate
Unanswered

How to automatically reduce parts when an order comes in.

(0) ShareShare
ReportReport
Posted on by 36

Hi Community, 

I really need your help.

 

I'm trying to create a production management application, but I'm stuck at the point where parts are automatically reduced.

 

*Product A is composed of X, Y, and Z parts.
A(1Ea) = X(3Ea) + Y(2Ea) + Z(5Ea)

 

BOM of product A was registered in SharePoint 1,

Orders List in SharePoint 2
SharePoint 3 manages inventory for each part.

 

Can you tell me how to implement the automatic subtraction method in parts management(SharePoint 3) when an order(SharePoint 2) comes.  use Power Automate?

 

I hope the photo below explains exactly what I want.↓

Elderscroll_0-1675326099979.png

 

Best Regards,

Categories:
I have the same question (0)
  • Verified answer
    AlexMCC Profile Picture
    293 on at
    Re: How to automatically reduce parts when an order comes in.

    Is your intention to have a unique List for each item BOM?

     

    There are a few other ways I would approach that.

     

    Create a product list and have a multiselect column to select the parts it consists of.

     

    Then, when an order comes in it triggers your flow.

     

    Let's say the trigger is when an item is added to the orders list.

     

    You have your product name and quantity from the trigger.

     

    Get items from your product list to get the required parts.

     

    Get items from your inventory list to get the inventory level of the parts.

     

    Subtract your order quantity from your inventory quantity and write it back to the original rows.

     

    Add whatever logic you want for quantities that reach critical levels, zero or negative.

     

    Since you are writing to the original lines, you probably want to use concurrency control to make sure only a single flow runs at a time. Same goes for your For Each loops in case you could have an order with multiple lines requiring the same parts.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard