cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hancha
Resolver I
Resolver I

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

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.

View solution in original post

6 REPLIES 6
v-xiaochen-msft
Community Support
Community Support

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.

View solution in original post

thanks for the info

___Pool___
Frequent Visitor

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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,322)