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

Leave a Comment


eOne Sessions at Community Summit North America 2022
Dynamics SL to D365 Business Central Migration - Recordings Now Available!
Technical Update for SmartConnect regarding D365 Business Central
Connect with eOne at Summit North America 2022 - Live in Orlando!
NEW WEBINAR: Dynamics SL to D365 Business Central Migration - Next Week!


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 Meet the Team 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

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.