- On the Integration tab click on Additional Columns tab.
- Click on Add Additional Column button.
- The Additional Column window will open.
- Name – enter a name for the column.
- Tab off the Name field to enable the Type field.
- Type – select Multi Lookup.
- Organization – either select a static D365 organization that this lookup should always run against, or select Runtime Organization to perform the lookup against the destination organization.
- Entity – select the entity to perform the lookup against.
- Return option set codes – Option sets within D365 have a value (held in the database) and a label (shown to the end user). Default queries to D365 return the value for option sets rather than the label. The return option sets as label checkbox on D365 data sources will return the label linked to the option set instead of the value.
- Click Add Attribute – use the Attribute section to select a filter criteria.
- Return Fields – select the checkbox for the fields to be returned from D365.
- Return error if no data found – mark this checkbox if an error should be returned if no data is found. If left unchecked, the integration will process without passing data into this mapped field.
- Click Save.