🤔 Problem
When formulas are used in agents with field mapping (LDAP, SharePoint, Salesforce, CRM agent), the whole returned value is empty, should one of the source attributes be empty.
Example:
Sn + ' (foo)' causes the result to be empty when there is no value in Sn. The expected result is (foo) .
When there is a value in Sn, the expected result is returned, e.g Doe (foo).
🌱 Solution
To handle null values in source attributes, wrap the source attribute in TOSTRING(<attribute>).
Example: TOSTRING(Sn) + ' (foo)'
If you are using PeopleSync 25.10, please upgrade to PeopleSync 26.4, because of Formulas Cause Fields to Be Empty in Agents With Field Mapping.