Answered

Patch command is creating a new row rather than updating

(0) Share

Report

Posted on by oladimejishodip

I am trying to Update a row in the dataverse using the Patch command but it is adding a new row instead. I have created a key column in both tables to Lookup on. Despite there being a match, it is creating a new row.

Here is the syntax I am trying to use:

ForAll(

//"SIPGridData10" is a collection I want to patch to the table (SIP_Sales Summary Calculationss) in the dataverse

SIPGridData10,

Patch(
'SIP_Sales Summary Calculationss',
LookUp('SIP_Sales Summary Calculationss',

// 'Summary Table Key' is the column ID in both the collection and the dataverse table
'Summary Table Key'= ThisRecord.'Summary Table Key),
{

// These are the records I want to patch to the dataverse table (SIP_Sales Summary Calculationss)
'Summary Table Key': ThisRecord.'Summary Table Key',
Area_Test: Text(ThisRecord.Areap),
Prodhlvl3: Text(ThisRecord.PHLvl3p),
'Annu.figs':ThisRecord.Ann_netvalue
}
)
)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @oladimejishodip ,

Please try this:

ForAll( //"SIPGridData10" is a collection I want to patch to the table (SIP_Sales Summary Calculationss) in the dataverse SIPGridData10 As temp, Patch( 'SIP_Sales Summary Calculationss', LookUp('SIP_Sales Summary Calculationss', // 'Summary Table Key' is the column ID in both the collection and the dataverse table 'Summary Table Key'= temp.'Summary Table Key), { // These are the records I want to patch to the dataverse table (SIP_Sales Summary Calculationss) 'Summary Table Key': temp.'Summary Table Key', Area_Test: Text(temp.Areap), Prodhlvl3: Text(temp.PHLvl3p), 'Annu.figs':temp.Ann_netvalue } ) )

Best Regards,

Wearsky

Was this reply helpful? Yes No
oladimejishodip 16 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
oladimejishodip 16 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the support. I got this syntax error

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @oladimejishodip ,

Try this:

ForAll( //"SIPGridData10" is a collection I want to patch to the table (SIP_Sales Summary Calculationss) in the dataverse SIPGridData10 As temp, Patch( 'SIP_Sales Summary Calculationss', LookUp('SIP_Sales Summary Calculationss', // 'Summary Table Key' is the column ID in both the collection and the dataverse table 'Summary Table Key'= temp.'Summary Table Key'), { // These are the records I want to patch to the dataverse table (SIP_Sales Summary Calculationss) 'Summary Table Key': temp.'Summary Table Key', Area_Test: Text(temp.Areap), Prodhlvl3: Text(temp.PHLvl3p), 'Annu.figs':temp.Ann_netvalue } ) )

Was this reply helpful? Yes No
oladimejishodip 16 on at

Like (0)

Report
Copy link

Link copied!

@v-xiaochen-msft
Thank you for your help. The code works perfectly. However, I want to ask why it was necessary to load into temp ( rename the collection) to sync back correctly.

Was this reply helpful? Yes No