function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jenny jadejenny jade 

Copy Text Value to a Lookup Field

How should I copy a text field to a lookup field
I tried doing it with workflow field update but its in vain as workflows dont update lookup field
and my next approach was process builder ,but this too is failing because since I am updating a lookup field its should update the ID not the name .

This is the error for Process builder:Error Occurred: The flow tried to update these records: null. This error occurred: MALFORMED_ID: Previous: id value of incorrect type: Mike Dan. For details, see API Exceptions.

My two fields are Previous Manager which is a text field 
Previous is a lookup field 
Akhil ReddyAkhil Reddy
You can't update the reference field with Text field. 
You might be thinking that by the appreance it is text filed but in the back end the reference fields are always bind with ID of a record, view layer renders the name on Page. So grab the ID of the record and update in the lookup field. 
Hope it make sense to you.
jenny jadejenny jade
Yup got it 
Akhil ReddyAkhil Reddy
please mark it solved if my answer solved your poblem