Patching Blank() into CDS LookUp type field from canvas app

[Hancha]

Hi, 
I need to clear a CDS LookUp type field from my embedded canvas app using function Patch.

My embedded app is on a Dynamics 365 form.

The LookUp is into system entity User.

Simply I´m using the following

Patch(
Opportunities,
LookUp(
Opportunities,
Opportunity = ModelDrivenFormIntegration.Item.Opportunity
),
{Solver1: LookUp(Users, 'Full Name' = Blank())
}
);

I found out that my function works only if I activate Settings/Experimental Feature/Formula-level Error Management.

My question is if there is any other way how to clear such field as I´m not very comfortable with using Experimental features in Business app in Production Envirnonment.

Thanks

Hana

[v-xiaochen-msft · Accepted solution]

Hi @Hancha ,

Unfortunately, at my knowledge, there is no other way to replace this setting now.

If you have any ideas or suggestions, you could submit them to Here  .

Best Regards,

Wearsky

If my post helps, then please consider Accept it as the solution to help others. Thanks.

[Hancha]

thanks for the info

[___Pool___]

Hi Hancha, I am stucked with setting a lookup value on my record to null, I am using the following formula that seems reasonable:

Patch(myRecord,{Desk: Blank()})

or as alternative

Update(MyEntity,LookUp(MyEntity,'Id'=myRecord.'Id'),{Desk: Blank()});

Didi you found any way to achieve this?

[Hancha]

Hi @___Pool___ ,
have you activated the Formula-level Error Management option inSettings/Advanced Settings/Experimental Feature/Formula-level Error Management? 
After that it should not be a problem...

[Hancha]

the function which works for me:

Patch(
EntityName,
LookUp(
EntityName,
IDColumnName = Yourvalue.Id
),
{
'Column NameToPatch': Blank(),
})

[___Pool___]

Thank you @Hancha using this settings: Settings/Advanced Settings/Experimental Feature/Formula-level Error Management it is working, I just had to close and reopen the app in editing to let the changes be applied