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

#### Copilot Cookbook Challenge | WINNERS ANNOUNCED | Win Tickets to the Power Platform Conference

We are excited to announce the "The Copilot Cookbook Community Challenge random winners have been selected for the Challenge.  Thank you to everyone who participated in this challenge.    Copilot Cookbook Gallery:Power Apps Cookbook Gallery: 1. @swaminawale  1. @renatoromao     2.  @SpongYe  2.   @nickpotts10  *Please note if for any reason a winner declines, we will have another random drawing.   Check out all of the Cookbook Submissions: 1. Copilot Studio Cookbook Gallery: https://aka.ms/CS_Copilot_Cookbook_Challenge 2. Power Apps Copilot Cookbook Gallery: https://aka.ms/PA_Copilot_Cookbook_Challenge   There will be 5 chances to qualify for the final drawing: Early Bird Entries: March 1 - June 2Week 1: June 3 - June 9Week 2: June 10 - June 16Week 3: June 17 - June 23Week 4: June 24 - June 30WINNERS ANNOUNCED - JULY 8th     At the end of each week, we will draw 5 random names from every user who has posted a qualifying Copilot Studio template, sample or demo in the Copilot Studio Cookbook or a qualifying Power Apps Copilot sample or demo in the Power Apps Copilot Cookbook. Users who are not drawn in a given week will be added to the pool for the next week. Users can qualify more than once, but no more than once per week. Four winners will be drawn at random from the total qualifying entrants. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once. If they are drawn multiple times, another user will be drawn at random. Prizes:  One Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 (\$1800 value, does not include travel, lodging, or any other expenses) Winners are also eligible to do a 10-minute presentation of their demo or solution in a community solutions showcase at the event. To qualify for the drawing, templates, samples or demos must be related to Copilot Studio or a Copilot feature of Power Apps, Power Automate, or Power Pages, and must demonstrate or solve a complete unique and useful business or technical problem. Power Automate and Power Pagers posts should be added to the Power Apps Cookbook. Final determination of qualifying entries is at the sole discretion of Microsoft. Weekly updates and the Final random winners will be posted in the News & Announcements section in the communities on July 29th, 2024. Did you submit entries early?  Early Bird Entries March 1 - June 2:  If you posted something in the "early bird" time frame complete this form: https://aka.ms/Copilot_Challenge_EarlyBirds if you would like to be entered in the challenge. Early Bird Submissions: @renato Week 1 Results:  Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1.  @Mathieu_Paris 1.   @SpongYe 2.  n/a2.   @Deenuji 3.  n/a3.   @Nived_Nambiar  4.  n/a4.   @ManishSolanki 5.  n/a5.    n/a   Week 2 Results:  Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1. Kasun_Pathirana1. ManishSolanki2. cloudatica2. madlad3. n/a3. SpongYe4. n/a4. n/a5. n/a5. n/a     Week 3 Results:  Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1. Parul_Yadav_Neo1. n/a2. SpongYe2. n/a3. n/a3. n/a4. n/a4. n/a5. n/a5. n/a   Week 4 Results:  Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1. @nickpotts10  1. @ShrushtiShah  2. @Suniti_0020 2. @swaminawale 3. n/a3. @farukhis786 4. n/a4. @ManishSolanki  5. n/a5.  n/a