Bring Picklist Values to your Salesforce Report

A Quick Tip to Make your Work with Salesforce Reports Even Easier

When you first pull a report from Salesforce to Excel using XL-Connector’s Get Reports function – it will not populate your picklist columns with drop-downs containing all available picklist values. Here’s how to fix that:

After you run a report, click on Edit Flow -> Steps, and double-click on the step that was created during the report run.

Check the Enforce Picklists box under Pull from Salesforce

Click Push to Salesforce -> Column Mappings and make sure that your picklist column in Excel is mapped to the correct picklist field in Salesforce:

Click OK in all the dialog boxes to close the template editor.

Hit Refresh up in the XL-Connector ribbon.

Your picklist values should now be populated:

Please, note that you need to be running XL-Connector Enterprise Admin edition of the software to be able to access the Edit Flow functionality.