Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Is it possible to set null values in business rule?

Posted on by 160

Can i set null values in business rule

*This post is locked for comments

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: Is it possible to set null values in business rule?

    Hi Smith,

    When you  clear field value using Business Rules  that means you are basically clearing the current value  , if the field have any default value  then you can see always its set to default value. If there is no default value for the field  in that case field value will store as NULL in the database.

    Can you please share with us what exactly your requirement , or if you have any specific issue .

  • Suggested answer
    Gaurav Tempe Profile Picture
    Gaurav Tempe 20 on at
    RE: Is it possible to set null values in business rule?

    Use the following condition as we cannot set value as NULL.

    IF

    Tenant ID does not contain data

    THEN

    Hide field Agreement

    ELSE

    Show field Agreement

  • Suggested answer
    Alagunellaikumar Profile Picture
    Alagunellaikumar 6,210 on at
    RE: Is it possible to set null values in business rule?

    HI

    You can clear value to the field. May i know what purpose do you need to make it null?

  • Suggested answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: Is it possible to set null values in business rule?

    If you are trying to set null value of field then it is not possible..

    busetvalu.PNG

    when you set one field value from another field, and parent field has null/empty value then second field value will be set to null/ empty. 

    busetvalu.PNG

    But I don't understand why do you want to set null value, and not clearing field value. 

  • ggghj Profile Picture
    ggghj 160 on at
    RE: Is it possible to set null values in business rule?

    Yes I know about clear field value...but I want to know it takes null value or not.

    Kindly share with example.

  • Suggested answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: Is it possible to set null values in business rule?

    Hi,

    You can clear values using Business rule.

    for more information check

    www.powerobjects.com/.../clearing-a-field-value-using-business-rules

    www.powerobjects.com/.../using-business-rules-to-clear-cell-values

  • hellosuresh Profile Picture
    hellosuresh 525 on at
    RE: Is it possible to set null values in business rule?

    yes you can but not in Busienss rule interface. Put some dummy value while creating business rule and save the business rule. After that download the solution which contains the entity where business rule is attached.  Unzip the solution, go to folder "Workflow", find the business rule by name. Search for the field and enter empty value and zip the solution and import into the system. This is a work around solution in CRM 2013. May be in the latest version, CRM allows to set null,  I have no idea. 

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans