The expression is valid but its result type '<type>' is not one of the expected types: Text

This happens when the expression specified in the CSV file locale property of the Export action does not yields a text value. Update the expression to return a valid locale identifier.

Export CSV failed because CSV file locale is missing.

This happens when the expression specified in the CSV file locale property of the Export action yields an empty string rather than a valid locale identifier. Update the expression to return a valid locale identifier.

Export CSV Failed. CSV file locale 'en-XX' is invalid.

This happens when the expression specified in the CSV file locale property of the Export action yields an invalid locale identifier. Update the expression to return a valid locale identifier.

Exporting Phone Numbers with Leading Zeros to Excel

If you export Phone type field contains leading zeros, the leading zeros may not be displayed when you open the CSV file in Microsoft Excel. The leading zeros are present in the CSV file. You can verify this by opening the CSV file in Microsoft Notepad. To get the leading zeros to be displayed in Microsoft Excel, you can use the "Second and more 'surgical' way" described here. Admittedly it is a bit painful.

Did this answer your question?