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!

sholinaty
New Member

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,004)