I would like to create a copy of an existing “template” record (custom entity) and then set the lookup on the new record to a parent, in this case the account from where I start the on-demand workflow.
And with the help of Andrew Butenko’s Ultimate Workflow Toolkit I can set the lookup field on the cloned record. First I use the workflow activity UWT: Request Builder > Set Lookup Field to set the Field Value with the Record URL of the Account and the Field Name (internal value) from the entity of the cloned record that should be updated.
Finally with the workflow activity UWT: Bulk Operations > Update Records I can update the “requested” lookup field at the cloned record that I fetch with its Guid in the FetchXml Query.
So now by starting the on-demand workflow from an account, a copy of the template record is created and linked to the account.
Easy peasy, thanks to our workflow heroes Demian and Andrew. Cheers!