AnsweredAssumed Answered

Setting up a Workflow to query a list, update another and trigger an email when list items are 5 or above

Question asked by darrenfloyd666 on Jun 20, 2017
Latest reply on Jun 21, 2017 by lakshminarayana

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.

Workflow Breakdown
So far this is what I've got, but I can't get past the Query list because of the warning.

Outcomes