Skip to content


Tech Tuesday : SmartConnect Update Blank Data

Today’s Tech Tuesday discusses the Update Blank Data feature. This feature can be used from the SmartConnect Mapping window.

This can be used to determine when updating records whether blank data should over-write fields. If Update Blank Data is checked, a blank field mapped to a destination field will cause the destination data store to be updated with the blank value. If Update Blank Data is unchecked, blank fields mapped to destination fields will not cause destination data source information to be over-written with blank values.

By default, Microsoft eConnect and CRM do not send blank data values to the stored procedures so there is no mechanism to remove a blank value once the data has been set. If you need the data to be blank, SmartConnect gives you that option with the Update Blank Data checkbox.


  1. Manny on November 18, 2016 at 5:50 pm

    Does this work with CRM Option sets?

  2. Maryna on August 20, 2020 at 7:13 pm

    This option doesn’t seem to work for us. Blank values are not updated in Destination whether the Update Blank Data is checked or not.

  3. Alex Tayurskiy on February 5, 2021 at 11:17 am

    CRM connector doesn’t clear picklist values

  4. Leh on December 8, 2022 at 3:21 pm

    There seems to be a flaw in the design of clearing the CRM field by disassociation. If a value being passed by the source is blank, how can I pass the old value for the lookup in the related entities?

    The demo for the CRM was not performed so I am not sure how you are able to perform a lookup when the source is passing a blank field. It would be great if the demo actually showed the source and the results of the run.

    In the example, if you are to remove a contact via disassociation what does your source looks like? In the demo, the assumption is my source still passes the old value (for the lookup to work) but if I don\’t have it in the source because it was already removed (which is the point of \”updating blank\” value), how else can I associate the old value?

Leave a Comment


Tech Tuesday: Popdock - Joining the tale of two States
Meet eOne Solutions at Directions EMEA 2023!
Connect with eOne Solutions at SuiteWorld 2023!
What is a Data Lake/Data Lake Management?
The Challenges & Benefits of Ad Hoc Reporting


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release Salesforce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.