Unanswered

Delete value from the "Yes/No" datatype

(0) Share

Report

Posted on by zdzunic

Is it possible to delete the value for the field "Yes/No" data type in Dataverse? This data type has a "default value" and when I try to delete the value for that field in a row a become Error. I tried to delete value using Export in Excel option. Is there any other possibility for deleting the value for a field in a row in Dataverse?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @zdzunic ,

You can clear the field through a standard workflow. See link here on how to accomplish. https://powerobjects.com/crm2011/remove-a-value-from-a-two-options-field-in-a-dynamics-crm-workflow/

Thanks!

Drew

Was this reply helpful? Yes No
zdzunic 46 on at

Like (0)

Report

Thanks for suggestion. I am currently working in powerapps and I am trying to test one example for AI BUilder. Is it possible to do delete "Yes\No" value in Powerapp or in Dataverse as a part of Powerapp?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

You can setup the workflow as "on demand" and you should be able to execute from the record and then it will clear. Is that what you are asking?

Thanks,

Drew

Was this reply helpful? Yes No
Hamish Sheild 3,005 Most Valuable Professional on at

Like (0)

Report

Hi @zdzunic

If you want users to be able to easily set a Yes No field to blank then you can use a Choice column with the values - blank, Yes & No, as an alternative. That way a user can easily set the field to blank in an app without having to run a workflow.

Was this reply helpful? Yes No
zdzunic 46 on at

Like (0)

Report

Thank you, @HSheild,
I need this import to check this example https://docs.microsoft.com/en-us/ai-builder/prediction-data-prep
for AI BUilder Prediction. So I need to import csv in which column "Revenue" has null values for some rows and "Yes&No" for others.
I made two experiments. First when I use "Revenue" column in table data type "Yes|No", then rows with null values get default value.
Second when I use choice data type for "Revenue" field in table but then import doesn't work (no rows are imported in table).
Any suggestion how to execute this import. If somebody has a time could also try this example which I sent. It requires 5 min. I would like to know is something with my environment, or it is a general problem.

Thanks

Was this reply helpful? Yes No