web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patch to un-select a C...

Power Apps

Answered

Patch to un-select a CDS Optionset?

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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 Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for this!
Confirmed, this works perfectly.

Was this reply helpful? Yes No

Join the conversation