web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Patch Value on Gallery

Power Apps

Answered

Patch Value on Gallery

(0) Share

Report

Report

Posted on by Ben-00-38

176

how to calculate
PVU * QTY

and save the PVT value in the list.

Patch(('Devis détail');ThisItem;{PVT: {ThisItem.PVU*ThisItem.Qty}})

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ben-00-38

Your formula needs to be on a behavior action of a control. It almost looks like in your image that it is on a label text property.

But, if in a behavioral action, then your formula needs to be:

Patch('Devis detail'; ThisItem; {PVT: ThisItem.PVU * ThisItem.Qty})

I hope this is helpful for you.
Ben-00-38 176 on at

Like
a
(0)

Report
Copy link

Link copied!

Is it possible to adapt the code with the control below
calculation and recording of PVT.

so that PVT is sent during the action on the arrow.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Ben-00-38

Yes, change the formula to the following:

UpdateIf('Devis détail; ID=ThisItem.ID; {Qty: ThisItem.Qty + 1})
Ben-00-38 176 on at

Like
a
(0)

Report
Copy link

Link copied!

with
UpdateIf ('Detailed quote'; ID = ThisItem.ID; {Qty: ThisItem.Qty + 1})
PVT is not calculated.
by clicking on the arrow left or right I need pvt to be calculated and sent to the list.

the code works but I have not succeeded in adapting yours
With (
{
_itm: LookUp (
'Detailed quote';
ID = Gallery7_1.Selected.ID
)
};
Patch (
'Detailed quote';
_itm;
{Qty: _itm.Qty + 1};
{PVT: (ThisItem.Qty + 1) * ThisItem.PVU}
)
)

Join the conversation