Knowledge Base

Using a List Option Lookup

How can we help?

Browse Common Categories

Getting Started with SmartConnect.com

Using a List Option Lookup

  1. On the Integration tab click on Additional Columns tab.
  2. Click on Add Additional Column button.

  3. The Additional Column window will open.
  4. Name – enter a name for the column.
  5. Tab off the Name field to enable the Type field.
  6. Type – select List Option Lookup from the Type dropdown list.

  7. Entity – select the entity that contains the required list option.
  8. Picklist – select the required list of options.
  9. Column Name – select the source column that contains the data to be looked up within Dynamics 365 Sales.
  10. If No Data – select the required option if not data is found when filtering lookup values with the supplied value.
    1. Return error if no match – SmartConnect will stop processing if the supplied value does not match a value in the option list.
    2. Return blank if no match – SmartConnect will return blank for the option set if the supplied value does not match a value in the option list.
    3. Return default if no match – SmartConnect will return a default value for the option set if the supplied value does not match a value in the option list.
  11. Default Value – if ‘return default if no match’ has been selected, enter the default value to be returned.
  12. Save the column settings.
Support

Email an Expert

Start a Ticket
Support

Chat with Us

Support

Submit a Ticket

Support

Call Us

Product
Connections
  • Microsoft Dynamics 365
Templates
Engage
Get Started

SmartConnect is designed with specialty & deep experience in the core technologies we focus on.

iPAAS & on-premise integration tools that let you connect your cloud and on-premise applications.

© 2021 SmartConnect|eOneSolutions
Privacy PolicyTerms of ServiceEULA

How can we help?

clear