Unanswered

Update a record and set the choice column value as null which previously had some value.

(0) Share

Report

Posted on by Usman2

124

Hi all,

I have a choice type column in my table and what I want to do is to set the choice column as null for existing records just like it is null for new records when the default choice is set to "None".

I tried patching Blank() to the record but it did not work

Patch(Cars,carRecord,{Color:Blank()})

Is it possible to set the choice type column value as null?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Re: Update a record and set the choice column value as null which previously had some value.

Hi @Usman2 ,

In my test, the value of the choice column can be set to null by patching Blank().
I guess it may be that the record "carRecord" in the formula does not exist in table.

Best Regards,
Habsburg Qian
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
Usman2 124 on at

Like (0)

Report

Re: Update a record and set the choice column value as null which previously had some value.

Hi @v-zhoqian-msft

I have checked and the record "carRecord" in the formula does exist in the table.

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Re: Update a record and set the choice column value as null which previously had some value.

Hi @Usman2 ,

This is strange. You could check if you can use Patch to update other column values of this record.
Or have you set the choice column as required?

Best Regards,
Habsburg Qian
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
Usman2 124 on at

Like (0)

Report

Re: Update a record and set the choice column value as null which previously had some value.

Hi @v-zhoqian-msft
Yes I can use Patch to update other columns and the choice column is no required it is optional.

Was this reply helpful? Yes No