Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Delete value from the "Yes/No" datatype

(0) ShareShare
ReportReport
Posted on by 46

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:
  • zdzunic Profile Picture
    46 on at
    Re: Delete value from the "Yes/No" datatype

    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 


     

  • H Sheild Profile Picture
    3,000 Most Valuable Professional on at
    Re: Delete value from the "Yes/No" datatype

    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.

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on at
    Re: Delete value from the "Yes/No" datatype

    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

  • zdzunic Profile Picture
    46 on at
    Re: Delete value from the "Yes/No" datatype

    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?

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on at
    Re: Delete value from the "Yes/No" datatype

    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

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics