Apply to each subtracting value each time it runs

[golfnutt82]

Hello,
My apply to each is subtracting the value twice.
How do I stop this?
I am doing a Get Items action for the Supply Ordered Products where the OrderID eq OrderID so in my case it finds two Ordered Products using the same OrderID.
I run a Filter Array and get the values for each iteration of the Apply to Each.

I am getting the base value from a list and lets call this QTY = 10
I have another list called Orders and there could be one or more but each having their own SKU number.
In this case there are two SKUs under OrderID; 1 has a Ordered QTY of 7 and the other Ordered QTY of 8
This should be a simple math equation where I am subtracting the starting value of 10 and the ordered value of 7 for SKU 1 and the ordered value of 8 for SKU 2 and the answer should be 3 and 2 respectively but its not.

Im using this math function.

This is the output to my power app form -5 should not be the answer.

What am I missing?

[wskinnermctc]

It is difficult to tell what is the issue without more pictures of the steps in your flow. I can't tell where any of these values are getting put together or where the apply to each is being used.

7+8=15 and 10-15=-5 so that's about all I can see as a connection.

[golfnutt82]

Ok, Im sorry, I should add more info.
Here are the lists.
The below list shows the products and the quantity available

When a person orders products from this list the amount ordered will be subtracted and this list will be eventually updated with the correct available count.

This is the list that holds the history of what is purchased by OrderID.

Here is the first part of the workflow

What should happen 
First item in the for each is 7 and the instock qty is 10; the remaining amount should be 3

The next item in the for each is 8 and the instock qty is 10; the remaining amount should be 2

Instead I am getting -5 which almost leads me to believe the loop is adding 8+7 = 15 and then minus 10 gives -5

How can I fix this?

[wskinnermctc]

It is still difficult to tell; however, I think I can see where there are 3 issues that could cause the problem.

It appears that the variable strSKU1 is getting the first item of the order everytime. So you might always be pulling the first SKU number of the order. And maybe the same quantity.

The second and maybe related is that the first time the item quantity is updated, it changes it to 3 since 10-7=3. Then the Apply to Each runs again using the quantity of 8, but the same first SKU of the order which will be 3-8=-5

So you need to stop using the first item like body('Filter_array_Get_OSOP_Values')[0]?['SKU'] since it is always going to keep getting the first SKU of the the order.

The third is I don't know why "Apply to Each 2" exists. It is probably updating the office supply quantity multiple times for each item, or it is updating multiple items with the same quantity. 

You will have to investigate some of these things and see where it changes. I would start with getting rid of the "Apply to Each 2" since that is probably causing a problem somehow, or it is not necessary.

(Also change the names of your apply to each so that they are in order or defined for the objects.)

[golfnutt82]

Thank you for your input.
Based on what youve stated I will look at my design and see where there may be an issue.
I will followup later with an update.