Power Platform Community Forum Thread Details

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.↓

Best Regards,

Categories:

Building flows

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.