Update Item workflow errors

  • 8 February 2018
  • 2 replies
  • 4 views

Badge +1

How can I use UPDATE ITEM, to take the ID from a row, and add it into another column called MyID, which is then used by another calculated column to format this into an autogenerated number.  I am using SharePoint 2013 and Nintex workflow 2013.

 

I have attached a picture of the workflow with throws an error.

 

Please help.


2 replies

Badge +7

Go with this 

 

Badge +12

H‌i Robert Wilson‌,

When you said ID, did you meant item ID or Workflow Instance ID?

Are you updating the item in the same list?

In your screenshot, it seems that you're updating the same list. For, item ID and being updated in the same list run the workflow only when item gets created. Instead of lookup, you can use current item and equal to ID item property and update your MyID column for current item. You can also do your calculation within the workflow so that you don't need MyID column.

Also, if you use ID column as a part of formula in SharePoint's calculated column then it won't work. It will resets the ID value. You may have to write some JavaScript to avoid that. Instead using workflow will be an easy approach.

Reply