cancel
Showing results for
Did you mean:
Impactful Individual

## Apply to each subtracting value each time it runs

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?

4 REPLIES 4
Super User

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.

Impactful Individual

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?

Super User

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

Impactful Individual

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.

Announcements

#### Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Our team will be reviewing posts using the new "Copilot" label to ensure we highlight and amplify the most relevant and recent content, so you're assured of high-quality content every time you visit. If you share a post that gets featured in the curated gallery, you'll get a PM in the Community to let you know!The curated gallery is ready for you to experience now, so visit the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community. We can't wait to see what you "cook" up!