Patch multiple records in a collection

(0) Share

Report

Posted on by Seanan

I have a shopping app that allows users to purchase items. I am currently having an issue trying to patch/update my gallery collection. The issue occurs when a user tries to increase the quantity in the checkout screen, the price should adjust in the collection. However, when I increase the quantity, instead of the price going 200, 400, 600, 800 etc. it goes 200, 200, 400, 800, 1600 etc. Almost like it is doubling.

The code I am using is:

Patch(ColProductOrder,ThisItem,{Price:ThisItem.Price * Value(ThisItem.Qty),Qty:ThisItem.Qty + 1,Name:ThisItem.Name,Brand:ThisItem.Brand,Colour:ThisItem.Colour,Size:ThisItem.Size,Image:ThisItem.Image})

I have also tried using Update instead of Patch and this has the same outcome.

Any help would be much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Seanan ,

Before using patch , please save the Qty value in a variable firstly and use it in patch Price field.

Set(var,Value(ThisItem.Qty));Patch(ColProductOrder,ThisItem,{Price:ThisItem.Price * var,Qty:ThisItem.Qty + 1,Name:ThisItem.Name,Brand:ThisItem.Brand,Colour:ThisItem.Colour,Size:ThisItem.Size,Image:ThisItem.Image})

Best Regards,

Wearsky

Was this reply helpful? Yes No