I have one list called Devices, and another called Knownissues.
Items are added to the Devices list (lap top, router etc). In this list is a column named ID which auto generates a number.
In the Knownissues list I have a Lookup column called Device:ID which gets the number from the Devices ID column, I also have a free text field called DeviceID which I'll come to later.
So what I need the Workflow to do is to run query the Device:ID column and if the number is 5 to send an email and update a Drop down list in Knownissues which is either Sent or Not Sent, and to also update the Device:ID number to the previously mentioned DeviceID column. Does that make sense?
There's a diagram below.
So far this is what I've got, but I can't get past the Query list because of the warning.