Create New List Item with Lookup Fields in Workflow

List A and List B both have a lookup field against List C. You’d like to have a workflow so that an entry in List A will generate an entry in List B setting the value of the lookup field from one to the other. However you’re getting the error: “Coercion Failed: Unable to transform the input lookup data into the requested type.”

 

The key is to get the ID of the field from the lookup table. Even though the field you use in the lookup table is the Title, or something else, the value you’re using to set it with will be the ID from the table.

 

Advertisements

One Response to Create New List Item with Lookup Fields in Workflow

  1. KS says:

    Thank you so much! This really helped me! Just simple, clear and straight to the point…appreciate it 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: