Updating a field in a list with a number from a different list

Question

I'm working on SharePoint 2010. I have two lists, Devices and Knownissues. In Devices I have the ID column with an item generated number which I want to update in a column in Knownissues called DevicesID.

I already have a Lookup field in Knownissues. I tried updating the field using Nintex Workflow but have been banging my head against a brick wall (the best result I can get is returning '1' and not the actual number in the ID column). Surely there's a straight forward way of doing this? I was thinking a calculated field, but I am happy to hear suggestions.

Answer 1

You could add a event handler for the Devices list that will update the Id column and DeviceId column when a item is added to the list. Event handlers are more complex than workflows but here is the basic info on Event Handlers. They offer more flexibility than workflows and allow you to easily access info from other lists.

Answer 2

Using a SharePoint designer workflow should be able to do this just fine. I'm not familiar with "Nintex Workflow" but out of the box SharePoint can do this. Base on your description and names of fields, follow these steps:

1. Create a workflow on for the list "Devices".
2. In the workflow settings screen set the "Start Option" to "Start workflow automatically when an item is created".
3. Add the action "Update List Item" to your workflow.
4. Edit the action and choose the list "Knownissues".
5. Click "Add" and choose "DevicesID" under "Set this field:"
6. Choose "ID" under "To this value:"
7. Save and Publish your workflow.
8. ...
9. Profit?

Answer 3

Create a lookup column IssueID in Devices list. Then in the desginer workflow start a workflow when an item created in Devices list, do the following

First set workflow variable issueId with integer type & assign IssueID (lookup column) integer value in the currentlist(Devices).

Now use update list item action, Select Knownissues list & assign DevicesID field with currentItem ID(Devices list item ID). Find List Item by matching ID field with workflow variable issueId.

For Reference link