Answered

Trouble again with patch and lookup

(0) Share

Report

Posted on by ckserra33

421

Hi everyone. I am trying to update a DV table from inside a gallery where the datasource of the gallery is different from the DV table I am trying to update. I have used a lookup and patch in a similar situation but cannot figure this one out.

The datasource of the gallery is Depot-Lineitems, and I am trying to patch to the column crd63_qtyonhand in DV table Depot-Parts.

The error I am getting is below as well as the code from the patch. Thanks all for the help!

Patch(
'Depot-Partss',
LookUp(
'Depot-LineItems',
crd63_barcodenumber = ThisItem.crd63_barcodenumber
),
{crd63_qtyonhand:5}
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

HenWang Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ckserra33 ,

For this question, I need to know where this patch button exist, is it inside the gallery or outside the gallery?

Suppose it exist inside the gallery, then you have to use this formula instead:
Patch( 'Depot-Partss', LookUp( 'Depot-Partss', crd63_barcodenumber = ThisItem.fieldName_in_Depot-LineItems ), {crd63_qtyonhand:5} )

Only in this way can you update the row whose crd63_barcodenumber value equals to thisitem.fieldName in your Depot-LineItems list.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
Shaheer Ahmad 2,194 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

The Datasource of LookUp and Patch should be the same..
Mark as solution if this helps

Was this reply helpful? Yes No
ckserra33 421 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @HenWang , thank you very much for your help, that worked perfectly!

Was this reply helpful? Yes No
ckserra33 421 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ShaheerAhmad , thank you very much for your help, that worked perfectly!

Was this reply helpful? Yes No