Collection: calculacted value based on value within own record?

(0) Share

Report

Posted on by oguruma

I'm tyring to build shopping cart type functionality.

I have a table called tblProducts like {Product_Name: "T-Shirt,Price:20}

I have a collection called colShoppingCart like {colProduct_Name:"T-Shirt",Quantity:2,Product_Total: ???}

What I'd like to do is for Product_Total to be something like LookUp(tblProducts,Product_Name = colProduct_Name, Product_Price)*Quantity

So, basically, I want to loop through each colShoppingCart Record, lookup the price for the product in the tblProducts table, and then multiply it by Quantity in the colShoppingCart collection.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @oguruma ,

Please try:

ForAll( colShoppingCart.colProduct_Name As TableB, Patch( colShoppingCart, LookUp( colShoppingCart, colProduct_Name = TableB[@colProduct_Name] ), { Product_Total: LookUp( colShoppingCart, colProduct_Name = TableB[@colProduct_Name] ).Quantity * LookUp( tblProducts, Product_Name = TableB[@colProduct_Name] ).Price } ) )

Best Regards,

Bof

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @oguruma ,

Much simpler simply adding the column

AddColumns( colShoppingCart, "Total_Price", LookUp( tblProducts, Product_Name = colProduct_Name ).Price * Quantity )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No