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

(0) Share

Report

Posted on by R3dKap

1,594

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...

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

R3dKap 1,594 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

R3dKap 1,594 on at

Like (2)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No