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.