Answered

Patch LookUp column with Blank() doesn't work

(0) Share

Report

Posted on by Dennis_Kozlov

Hi Community,

I am trying to patch the Parent Asset column in the Customer Asset Dataverse table with a Blank() value. I don't receive any errors, but the earlier value remains unchanged. Does anyone know what could be causing this? There are no errors showing in the "Monitor," and all requests are marked as successful. If I change the value to another Parent Asset value, it works well, but when I try to set it to Blank(), nothing happens.

Could you please assist?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Dennis_Kozlov 46 on at

Like (0)

Report
Copy link

Link copied!

below the code to Patch

If(CountRows(ToPatch_remove) = 2,
ForAll(
ToPatch_remove,
Patch(
'Customer Assets',
ThisRecord,

{'Parent Asset': Blank()}
//{'Parent Asset': LookUp('Customer Assets', 'Customer Asset' = combo_udstyr.Selected.'Customer Asset')} - working well

)

);

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Dennis_Kozlov ,

Based on my test, Patch Blank() to a LookUp column to clear the field should work.

It seems you have missed a closing bracket in your formula:

If( CountRows(ToPatch_remove) = 2, ForAll( ToPatch_remove, Patch( 'Customer Assets', ThisRecord, {'Parent Asset': Blank()} //{'Parent Asset': LookUp('Customer Assets', 'Customer Asset' = combo_udstyr.Selected.'Customer Asset')} - working well ) ) );

Best regards,

Was this reply helpful? Yes No
Dennis_Kozlov 46 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni

Thank you very much for your prompt response. Yes, you are correct regarding the missing closing bracket in my formula. However, this hasn't resolved my issue, unfortunately. I have just run some tests and figured out that when I use...
Patch('Customer Assets', ThisRecord, {'Parent Asset': Blank()}) i get empty body on monitor

And when i use Patch('Customer Assets', ThisRecord,{'Parent Asset': Blank(),ip:"test"}) i get request body only with ip: "test" the Parent Asset will be exclude 😞

Does anyone have any idea why this might be happening? Could it be something specific to the 'Parent Asset' column, considering it works with the 'account'? Could there be some configuration within Power Apps that I'm missing?

Was this reply helpful? Yes No
Verified answer

Dennis_Kozlov 46 on at

Like (0)

Report
Copy link

Link copied!

I have found a solution. I should use the 'Unrelate' function to remove the 'Parent Asset'. relationship in table

Was this reply helpful? Yes No