cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
R3dKap
Super User
Super User

How to blank an option set field in CDS with Patch()

Hi all,

Anyone knows how to blank an Option Set field (which is not mandatory by the way) in CDS using the Patch() function from a Power Apps canvas app?

I've already tried this, with no luck:

Patch(<entity>, <item>, {<optionset>: Blank()})

 

Thanks...

1 ACCEPTED SOLUTION

Accepted Solutions

Ok, thanks to Hardit Bhatia, the solution is :

  • using the Patch() as mentionned in my initial post
  • enabling the Formula-level error management in the advanced settings of the application

Thanks Hardit for the tip about this setting which made it all work!

View solution in original post

3 REPLIES 3
R3dKap
Super User
Super User

Seriously? No one knows how to do this? There's gotta be at least one person here that faced this once in his life! 😁

Ok, thanks to Hardit Bhatia, the solution is :

  • using the Patch() as mentionned in my initial post
  • enabling the Formula-level error management in the advanced settings of the application

Thanks Hardit for the tip about this setting which made it all work!

View solution in original post

sholinaty
New Member

can you be more specific?
Does enabling formula-level error management" allow you to patch =Blank() ?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,308)