I have 2 lists.

One list has a quantity field and the other list has assigned quantity field. When a user create or update a new item in the list with assigned quantity. I would like to do some workflow calculation by taking the quantity field of the first list minus the assigned quantity field and then set the result value to the first list quantity field.

Is this possible?

  • can u please tell me in detail – user23786 Feb 19 '14 at 11:18

Yes u can perform this. If u know the basic spd list workflow then try this--- Whenever you are updating or using an item of some other list (on which the workflow is not running), then you need to have a column in that list whose value will match with the column of the item, on which the workflow is running. Now in your case, both the lists (list1 and list2) must have a common column value for each list item. This is required because you need to tell the workflow that out of several items on the other list, which item he should update. Therefore, for that you need to use a column of an item in the other list whose value equals any of the column value of the item on which the workflow is running. In short, for unique identification. By using this u can get value of list2(assigned quantity) and minus it from list1 (qauntity field) and save back it to list1.

enter image description here enter image description here

Hope it helps



| improve this answer | |
  • THanks Dhaval. I did try that but i got error: Coercion Failed: Unable to transform the input lookup data into the requested type. – naijacoder Feb 19 '13 at 0:41
  • when u compare look up value u have to set 'Return field as:' Lookup Value(as Text). It means u compare it with text value of lookup not by id. Hope u got it. – Dhaval Kariya Feb 19 '13 at 5:12
  • please see my updated answer. – Dhaval Kariya Feb 19 '13 at 5:21
  • Yes thanks.Figured it out myself yesterday.thanks alot – naijacoder Feb 19 '13 at 20:24
  • gr8...you r most welcome.. – Dhaval Kariya Feb 20 '13 at 6:43

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