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.

  • No, Calculated Columns can't do this.. So do NOT bang your head against that wall again .. it is giving you the wrong answers – Danny '365CSI' Engelman Jun 24 '17 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 '17 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-Florin Popa Jun 25 '17 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 '17 at 9:03
  • It is not clear what you need, could you clarify? – Juan Pablo Pussacq Laborde Jun 26 '17 at 13:58
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?
  • If you explain more about the lookup field. I can better explain how step 3 works. – HiTech Jun 30 '17 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, privacy policy and cookie policy

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