Adding the quantity of two identical products in a collection

(0) Share

Report

Posted on by beatrizmoura26

Good afternoon

Someone help me?

I am adding products to a collection and I would like that when 2 equal products were added, only 1 would appear and the value would add up to the total value of the products

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Gochix 1,935 Moderator on at

Like (0)

Report
Hi @beatrizmoura26 ,

How are you adding these products to your collection?
If that's via Patch then you have to check if there is any records already in collection with this Products ID / Name.

If(IsBlank(LookUp(DataSource,ProductID = Value(ProductIDTextLabel.Text)), Patch(DataSource, Defaults(DataSource), { Product_Value: Value(ProductValueTextLabel.Text) } ), Patch(DataSource,LookUp(DataSource,ProductID = Value(ProductIDTextLabel.Text)), { Product_Value: Sum(Filter(DataSource, ProductID = Value(ProductIDTextLabel.Text))) } ) ) )

As you haven't said how you are adding new records in collection then this would be for a manual use.
If needed for Gallery then the code would have to change a bit.

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
beatrizmoura26 98 on at

Like (0)

Report

I added a check button inside a gallery, and inside the oncheck I added a collection
Collect(
colProdTranf,
Filter(
Product,
CallID = ThisItem.ID
)
);
Inside this collection I have 3 fields
code
product
the amount
and I wish that if the collection already had a product with the same code, it would just add the amount

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (0)

Report
You can try this:
If( IsBlank( LookUp(colProdTranf,ID=ThisItem.ID) ), Collect(colProdTranf,ThisItem), Patch(colProdTranf,LookUp(colProdTranf,ID = ThisItem.ID), { Amount:LookUp(colProdTranf,ID = ThisItem.ID).Amount + 1 } ) )
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
beatrizmoura26 98 on at

Like (0)

Report

It didn't work, it just adds 1 to the quantity and not the value that is in the quantity column.
Ex.: PRODUCT 1 WITH QUANTITY 10
PRODUCT 1 SELECTED AGAIN WITH QUANTITY 5
He should add and leave a line with PRODUCT 1 WITH QUANTITY 15
But with this function, it is actually adding 1 more to the first included product, making the amount equal to 11

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (0)

Report
try this then please:
If( IsBlank( LookUp(colProdTranf,ID=ThisItem.ID) ), Collect(colProdTranf,ThisItem), Patch(colProdTranf,LookUp(colProdTranf,ID = ThisItem.ID), { Amount:LookUp(colProdTranf,ID = ThisItem.ID).Amount + ThisItem.Amount } ) )

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No