SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have SP 2010 and SPD 2010. I have list A that has a single line of text column named Res ID #. This provides the source for List B as a lookup column. I want to create a WF that will put the info from Res ID # column from list A into the lookup column in List B when other List B fields are modified.

I am having trouble with coercion errors in the WF. I don't have enough info on choosing the correct fields in the Lookup Integer box. Here is what I have:

Field Data to Retrieve

Data Source: List A

Field from Source: Res ID #

Return field as: As Integer (grayed out)

Find the List Item

Field: ID (this pulls from list A)

Value: ? (as a default it is pulling from current list (list B) and I don't think this is correct)

Shouldn't the Value pull from the Res ID # column in list A? When I click on the fx button, I get another Lookup for Integer box with all of the same choices and this confuses me more. I am using WF variables to store the info from List A to set current field in List B. I have logs set to show me what the results are at each step of the WF. Sometimes the info will populate the log and other times there will be the coercian error. I have changed the Data types for the WF variables and have even had the WF complete, but no values show up in the List A lookup column.

Any thoughts or direction would be appreciated

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.