Dealing with Picklist and Lookup fields
XL-Connector 365 has a built-in tool that will make your life easier when working with fields of type picklist, multiselect picklist, or reference.
To use this tool, you’ll need to select a cell in a column that was either pulled from a field of one of the above types or is mapped to it via a flow step, and then click on the Context tab in the XL-Connector 365 user interface.
You can select multiple rows and columns.
Regular single select picklists can be set in two ways:
- Using the built in drop-down control that gets created when pulling a picklist field using a report or SOQL query:
- By selecting a cell in a column mapped to a picklist field and activating the Context tab:
Multi-select picklists can only be adjusted using the Context tab. Select a cell (or several) in a column mapped to a multiselect picklist field and activate the Context tab:
Id and Reference fields
Just like in the native Salesforce UI, you can look up related records using XL-Connector 365. Furthermore, you can do it for multiple cells at once. To bring up the record lookup interface, select a cell (or multiple cells) in a column that is mapped to an Id or Reference field and activate the Context tab: