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