cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
darrenfloyd666
Nintex Newbie

Updating item action

Hi

I've got two lists one called Devices and the other called Knownissues. I'm querying a numerical column in Devices called ID and storing it in a variable called ID_Number. Then what I want to do is to update a column in Knownissues called DeviceId. I don't think I'm configuring the Update item action right? What am I doing wrong?

Labels: (1)
0 Kudos
Reply
11 Replies
christopheraucq
Nintex Newbie

Re: Updating item action

ID_Number is declared as Integer or Number?

0 Kudos
Reply
darrenfloyd666
Nintex Newbie

Re: Updating item action

A number

0 Kudos
Reply
christopheraucq
Nintex Newbie

Re: Updating item action

Just make sure your 'where' returns the item you want

0 Kudos
Reply
darrenfloyd666
Nintex Newbie

Re: Updating item action

Right, so is the 'Where' field where I get the data from?

0 Kudos
Reply
courtney_shelto
Nintex Newbie

Re: Updating item action

The "Where" is set up correctly. You're saying that the item you want to update has an ID that matches your workflow variable ID. The parts after that are the fields you want to update. What you have set up right now is that you want the item where DeviceID == ID_Number and then you're going to be setting DeviceID == ID_Number which should already match. Does that make sense?

Let's say your ID_Number is 5. So you're looking for the item where DeviceID == 5. So now we know DeviceID is 5. Now, you're telling it you want to set the DeviceID of that to ID_Number, both of which are already 5. That's why nothing is changing.

0 Kudos
Reply
darrenfloyd666
Nintex Newbie

Re: Updating item action

Thanks. I think I'm getting it.

The Device:ID is the column which contains the number I need to query and then return the result to DeviceID. So I thought the Where should be Device:ID and the Field should be set to Device ID?



This is how I've set it up again and I put a Stop Worflow after to see if it works but I'm getting an error and nothing's updating...

0 Kudos
Reply
courtney_shelto
Nintex Newbie

Re: Updating item action

So basically, you want to "copy" the Device:ID column into the DeviceID column, is that correct?

0 Kudos
Reply
darrenfloyd666
Nintex Newbie

Re: Updating item action

yes

0 Kudos
Reply
courtney_shelto
Nintex Newbie

Re: Updating item action

Does this run as a list workflow on the item? If so, I would use the "Set Field" action. This way, you're updating the item you're already on and you can set the field DeviceID to the value of Device:ID

0 Kudos
Reply