Is it possible to use an expression to specify target value when doing a Target lookup ?
The target field in SFDC is a userlookup field that needs to get populated with Salesforce Id of a user. The source values are users networkid's .
The link is the Alias field in Salesforce user table
I am trying to get this via a Targetlookup
Lookup object 'User'
Result Column 'Id'.
Under Lookup Key Column , I have selected 'Alias' ( in SFDC this field has the users newtwork id's ) .
RIght now the options available are
'Constant' - Can just provide constant value
'Column' = Can pick up just an existing column
Target .Source Lookup
I would like to use an expression (if condition) to input the source value
confirmed_by=='on file' ? 'mickum03':confirmed_by
Is this possible to acheive using target lookup option ? If not is there any other option with which I can make this transformation - Thank You