Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

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

Posted on by 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:
  • Re: How to blank an option set field in CDS with Patch()

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

  • Verified answer
    R3dKap Profile Picture
    R3dKap 1,594 on at
    Re: How to blank an option set field in CDS with Patch()

    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!

  • R3dKap Profile Picture
    R3dKap 1,594 on at
    Re: How to blank an option set field in CDS with Patch()

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard