web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps calculate in detail form

Power Apps

Answered

calculate in detail form

(0) Share

Report

Report

Posted on by tuonoman

163

Good morning to all,

I use an Excel workbook to manage a stock. In this workbook I have a table with 5 columns.
Movement_ID/Product_ID/Date/OUT/IN.

In my power apps page with the details of my products I would like to display the quantity of parts in stock.

Does Power apps have the possibility via the "Movement" table to make a subtraction according to an ID from the IN and OUT? quantities and to display it in my part's detail form?

Thank you for your help

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @tuonoman ,

The formula you looking for is:

With({movementSelectedProduct:Filter(Movement,ID=selectedID)}, Sum(movementSelectedProduct,IN)- Sum(movementSelectedProduct,OUT) )

What you need to do is to establish the way you want to select the Product_ID (and set the selectedID value from the filter).

Hope it helps !
tuonoman 163 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @gabibalaban
Thanks for your help.
I have modified your proposition.
That works perfectly !

I like Powerapps more and more
With({_movementSelectedProduct:Filter(MOUVEMENT;ID_PRODUCT=LISTEPRODUCT.Selected.ID_PRODUCT)}; Sum(_movementSelectedProduct;IN)- Sum(_movementSelectedProduct;OUT) )

Join the conversation