how can I set only the one value to required lookup field, when I create new item in workflow. I tried use workflow variable, ID but I do something still wrong.

So I have one list A wiht values AB, AC, AD etc. On list B when I select yes in choise field, workflow create new item in list C, where is also lookup field (required) with value from list A. And I only want to set value AB for every created items. Workflow ends with error: Coercion Failed: Unable to transform the input lookup data into the requested type. I found that I used wrong data type, but I don´t know what to do. My workflow set

  • 3
    Try to change Title to ID in the last picture.
    – Roman
    Commented Jan 12, 2016 at 10:34
  • You can use ID column for this scenario.
    – Bagavathi
    Commented Jan 12, 2016 at 10:37
  • Yes, change Title to ID works, thanks a lot Roman!!! So easy but ...
    – Zbyna
    Commented Jan 12, 2016 at 10:46

2 Answers 2


Hi, I got stuck in this issue and could solve it so I decided to share that in here: It's too easy, you should set the look up the field as the Current Item ID. then it will automatically collect the value for lookup.

in the picture bellow you can see that I've set lookup (my columnm' name) as 1 which means the item with ID 1 but it will set the value that I need in the connected list. Hope to be helpful.

enter image description here



Column name that the lookup is based on is named: [Lookup ID: ID]

I apply it when an item is added in SharePoint Designer.

I used set [Lookup ID: ID] to [VALUE, use below settings for this]

Field Data To Retrieve [Data Source = Other List / Field from Data Source = ID / Return/ Field as String]

Find the List Item [Field: Name / Value: Data Source Current Item / Field from Source: Name / Return Field as String]

Then you can use SharePoint designer to apply that ID to a different column using a lookup, but the lookup has be ID based. The Lookup by ID can return the other fields you actually want!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.