Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Unable to update field...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Unable to update fields to null value using action

(0) ShareShare
ReportReport
Posted on by Nuwan Chamara 20

Hi,

We have an action to update certain entities in our system where we have to pass a null value to the following data types:

Decimal

Single Line Text

Multi Line Text

We are using a late bound with Post Operation Synchronous action running on server. We use Dynamics 365 online version (Server version: 9.1.0000.10951, Client version: 1.3.2539-191119-175232). We can update value to any non empty value without any issue.

We are also using CRM dll version 9.0.7 and we have updated it to the latest version as well but no luck. Any suggestions?

We are unable to post this to Microsoft Dynamics CRM forum

  • Suggested answer
    Roma Gupta Profile Picture
    Roma Gupta 725 on at
    RE: Unable to update fields to null value using action

    Hi Harindu

    Is there any specific reason for setting null value. Try setting it 0 & see if that can help.

    Also, what happens if you first set it to non -null or 0 & then set it to 0. I know its double work but   if you really want to have a null value.

    Also, are you getting any errors? Try doing it in pre-operation instead of post - operation.

    Regards

    Roma

  • Nuwan Chamara Profile Picture
    Nuwan Chamara 20 on at
    RE: Unable to update fields to null value using action

    Hi,

    It dose not throw any errors and the fields old values still remains

  • Harindu_Hansana Profile Picture
    Harindu_Hansana 5 on at
    RE: Unable to update fields to null value using action

    Hi Erhan,

    We need to remove the value of those fields. When we set null the value doesn't change and remains the old value. We used string.empty and null for SLT and MLT and empty for decimal. Did not work.

  • erhan.keskin Profile Picture
    erhan.keskin 2,247 on at
    RE: Unable to update fields to null value using action

    Hi,

    What you are saying is that when you temp to set Null to Decimal, SLT, MLT fields, Null value is not updated. What error do you face? What happens to the existing data in those fields after Null update?

    Regards,

  • Nuwan Chamara Profile Picture
    Nuwan Chamara 20 on at
    Unable to update fields to null value using action

    Hi,

    We have an action to update certain entities in our system where we have to pass a null value to the following data types:

    Decimal

    Single Line Text

    Multi Line Text

    We are using a late bound with Post Operation Synchronous action running on server. We use Dynamics 365 online version (Server version: 9.1.0000.10951, Client version: 1.3.2539-191119-175232). We can update value to any non empty value without any issue.

    We are also using CRM dll version 9.0.7 and we have updated it to the latest version as well but no luck. Any suggestions?

    We are unable to post this to Microsoft Dynamics CRM forum

  • erhan.keskin Profile Picture
    erhan.keskin 2,247 on at
    RE: Unable to update fields to null value using action

    Hi,

    What you are saying is that when you temp to set Null to Decimal, SLT, MLT fields, Null value is not updated. What error do you face? What happens to the existing data in those fields after Null update?

    Regards,

  • erhan.keskin Profile Picture
    erhan.keskin 2,247 on at
    RE: Unable to update fields to null value using action

    Hi,

    What you are saying is that when you temp to set Null to Decimal, SLT, MLT fields, Null value is not updated. What error do you face? What happens to the existing data in those fields after Null update?

    Regards,

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

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans