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
Solved! Go to Solution.
thanks for the info
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?
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...
the function which works for me:
Patch(
EntityName,
LookUp(
EntityName,
IDColumnName = Yourvalue.Id
),
{
'Column NameToPatch': Blank(),
})
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
182 | |
95 | |
66 | |
64 | |
60 |
User | Count |
---|---|
243 | |
163 | |
94 | |
82 | |
80 |