Answered

Patch to un-select a CDS Optionset?

(0) Share

Report

Posted on by Community Power Pla...

I have a CDS Back-end serving my power app.

several of my fields are for test results {pass, fail, disqualified}
i added these as OptionSets, with those as the defined options.

however... I need to have a way to "reset" many fields (reactivating a resigned employee upon rehire).
is it possible in a patch command to "unset" an optionset value?
in an edit form, i can simply un-select the item... however I cant use 'column name (tablename)'.optionName, as i am trying to un-set the item.

I had hoped it was one of:
Result:Blank(),
Result:[],
Result=''

Anyone able to offer any advice here?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-jefferni on at

Like (1)

Report
Hi @Anonymous ,

Please refer to below thread:
Solved: How to blank an option set field in CDS with Patch... - Power Platform Community (microsoft.com)

So you need to turn the formula level error management first
then use a Patch function:
Patch(<entity>, <item>, {<optionset>: Blank()})

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

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

Like (0)

Report

Thank you for this!
Confirmed, this works perfectly.

Was this reply helpful? Yes No