Answered

Shopping Cart - Reduce availabe amount when order submitted

(0) Share

Report

Posted on by NilsKirsch

Hi,

I've got two list. One that stores the ordered items with the ordered amount. In the second list I've got all my products.

In my ordered items list I've also stored the ID of the products from my productstable once an order is placed.

Now I want to do the following: I want to reduce the available amount of the product by the ordered amount of this product which is stored ordered items list.

My ordered Items List is looking like this

Title	Amount	Order ID	Product ID
Product A	2	1	4
Product B	4	1	2
Product XY	5	2 (different Order)	6

My Product List looks like this:

Title	ID	Amount
Product A	4	100
Product B	2	50
Product XY	6	10

The order can have various products and for all those ordered products I want to reduce the amount in the product list by the value of the ordered amount.

I know that I have to somehow compare the two tables by ID and then update the amount if there is a match. But I don't find the correct formulas.

Thanks in advance for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

SebS 4,863 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @NilsKirsch

I think this can help to sort out the challenge You experience:

https://www.matthewdevaney.com/build-a-shopping-cart-in-power-apps/

Hope it helps

Was this reply helpful? Yes No
Verified answer

SebS 4,863 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @NilsKirsch

Here is a patch function for You, keep in mind Amount column in both Lists needs to be set to number

ForAll( OrderItems As Order, Patch( ItemList, LookUp( ItemList, ID = Order.ProductID ), { Amount: LookUp( ItemList, ID = Order.ProductID, Amount ) - Order.Amount } ) )

Also You will need to handle if product will go to zero

Hope this helps

Was this reply helpful? Yes No
NilsKirsch 15 on at

Like
a
(1)

Report
Copy link

Link copied!

Woow excellent @SebS. Works as expected. Thank you a lot. That drove me nuts 😖

Was this reply helpful? Yes No