Microsoft Dynamics 365 | Integration, Dataverse...

Unable to update fields to null value using action

(0) Share

Report

Posted on by Nuwan Chamara

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

I have the same question (0)

All responses (7)

Answers (0)

erhan.keskin 2,253 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Nuwan Chamara 20 on at

Like (0)

Report

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

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Harindu_Hansana 5 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Nuwan Chamara 20 on at

Like (0)

Report

Hi,

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

Was this reply helpful? Yes No
Suggested answer

Roma Gupta 725 on at

Like (0)

Report

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

Was this reply helpful? Yes No