Summarize values via UpdateContext

(0) Share

Report

Posted on by PavelKrayushkin

Hi, I create the app which will be possible to summarize the quantity if details. My SharePoint list looks like this:

WorkOrder Quantity

00000333 133

00000343 451

The task is to summarize the total quantity (DataCardValue22) of details continuously during a day. For example, for work order 00000333"1+32+51+49=131" etc.

To solve it I created a "TextInput" in the EditForm for new values and created an "Add" button. OnSelect of this button has such formula:

UpdateContext({var:TextInput3+DataCardValue22})

The formula works good. there is no problem with summarizing but the problem is that the total quantity stays the same for each work order when I open an EditForm - in other words, for each new work order the total quantity equals to the last calculated value.

Please help, how can I calculate the separate quantity in accordance with the proper work order?

Should I use any Filters or Patch function?

Please if you have any ideas give a feedback.

Also see the attached images for more information. Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @PavelKrayushkin ,

Do you set var variable to the total quantity?
This issue is due to the var variable , the variable still store the last total quantity , you need to reset the variable when you open an new EidtForm.
Please put the following formulas to OnSelect of Button that open an new EditForm.
UpdateContext({var:Blank()})
Hope this can help.
Best regards,
Sik
If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

Was this reply helpful? Yes No
PavelKrayushkin 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your advice, but that is the problem - a can't just reset this information because I need to make some changes in my EditForm and each total quantity must be summarized. The issue is to make a conformity between the total quantity and the appropriate work order 😣

If you have time please look at the attached images - the first is my DetailScreenForm which is used to make changes with already inserted data. When I press "Edit" button I come to my EditForm and as you can see the "accepted" field is not equal for these both screens - for EditForm this quantity is equal to the last total quantity, as you mentioned before.

How can I save this quantity in accordance with its workorder? Is it possible?

Thank you

Was this reply helpful? Yes No