1

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.

7
  • No, Calculated Columns can't do this.. So do NOT bang your head against that wall again .. it is giving you the wrong answers Jun 24, 2017 at 17:25
  • The Workflow is giving me the wrong answer. I was wondering if there was another way to achieve what I need to do?
    – Dazza
    Jun 25, 2017 at 15:27
  • I would like to help, but I am very confused about what you are trying to achieve. Are you saying that you have several items in the Knownissues list and you need to update the lookup field named DevicesID for each of these items in the Knowissues list? If yes, then what criteria would you use to identify which ID from the Devices list corresponds to an item in the Knowissues list?
    – Mihail
    Jun 25, 2017 at 15:49
  • I just need to update the 'DeviceID' column in the Knownissues list with the 'ID' column number in the Devices list.
    – Dazza
    Jun 26, 2017 at 9:03
  • It is not clear what you need, could you clarify? Jun 26, 2017 at 13:58

3 Answers 3

0
+50

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.

0

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?
1
  • If you explain more about the lookup field. I can better explain how step 3 works.
    – HiTech
    Jun 30, 2017 at 12:33
0

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).

enter image description here 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. enter image description here

For Reference link

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.