I have a custom flow that is pulling data from an outside data table and I want to populate fields in a Salesforce record. The issue I'm running into is that our outside data table only has the Account Names and not the Account IDs so it doesn't populate my lookup field in Salesforce. I believe the solution is to create a lookup in the Celigo flow that would search for the account name and return the account id.
How am I supposed to reference a piece of data from the export in my SQL query? How do I take a the output of that query and map it in my record update?
Please sign in to leave a comment.