Unanswered

Patch to Dataverse table with a Lookup Column

(0) Share

Report

Posted on by rowan_preston

Hi - hoping someone can help me! I've searched and searched but haven't been able to find a solution that works yet!

I have a table: 'AU RA Details'

This table contains a lookup column to another table called 'Product Masters' (so that users can select a product code on various forms/dropdowns etc)

I have a gallery (GalInvLines) that has data from another table: 'AU invoice lines' I want to patch into 'AU RA Details'. This might be one line, or could be 50 lines with different product codes. The codes will all match exactly.

I've tried lots of various things - the closest it's come to working is this:

However, this is patching either a blank value or if an item in the gallery has been selected, the same value for each record....... How can i get the product code from each line of GalInvLines into 'AU RA Details'. All other information is copying correctly, just the SKU code isn't!!!

Thanks for any help!

Rowan

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Re: Patch to Dataverse table with a Lookup Column

LookUp() function will return a record.
Wouldn't you specify which specific field (from the record) you want to store in SKU?

Was this reply helpful? Yes No
rowan_preston on at

Like (0)

Report

Re: Patch to Dataverse table with a Lookup Column

Hi Sudeep
Yes - I want to patch the value from lblSKUCode into the column in 'AU RA Details' for the SKU Code. But this column is a lookup column and I can't get it to just accept the label value.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Re: Patch to Dataverse table with a Lookup Column

Two questions:
1) Why are you referring the control with @, why not the control name directly?
2) Have you investigated what LookUp('product masters',PMPART=LblSKUCode.Text) returns?

Was this reply helpful? Yes No