Power Platform Community Forum Thread Details

Good afternoon all! I'm trying to build a flow that takes information from one list (List1) on a status change, filters another list (List2), and adds information from the first list to the second if the values match. Below is an example of what I'm trying to accomplish:

This is List1, where orders are being populated:

This is List2, where I have all of our inventory:

The goal again is to take the number in the quantity column from List1 once the item has been changed to "Enroute" and add that number into the "Quantity Pending Delivery" column in List2.

Additionally, I'd like to build a second PowerAutomate flow where once the status in List1 has been changed to "Delivered", it moved the quantity from the "Quantity Pending Delivery" column in List2 to the "Quantity Delivered in Total" column in List2 and keeps a running balance.

Any ideas on how to accomplish this? I've failed miserably at building this flow. X_X

Thank you!

Categories:

Building flows

I think I would approach your problem as follows for the "Enroute" status:

Workflow runs when the item is updated with a trigger condition where the Status = Enroute
- You're going to need to figure out how to prevent the flow from running again if the item is updated and the status does not change. Otherwise the quantity pending delivery value will not be accurate. Maybe add a yes/no field (QPD) to list 1 with a default value of No that is hidden so it cannot be change by the users. Then your workflow can update this to yes when it runs. You can then use that in your trigger condition along with the status of Enroute (Status eq Enroute and QPD eq No)
Initialize a variable of Integer for storing the final quantity amount
Then use a Get items action on list 2 with a filter to only return the items matching list 1. I assume your "Stock/SKU" field is to unique values, so it should only return one row.
Next use an apply to each action
Add a set variable action with an add expression to do the math for adding the quantity in list 1 to the quantity in list 2
Follow this by an update item action to set the value in list 2

You can then use about the same logic for the Delivered status.