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

  • 20 June 2017
  • 1 reply
  • 41 views

Badge +10

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.


1 reply

Badge +9

Hi Darren Floyd,

1. Query list action fetch the item id which value is 5.

2. Update "knownissues" list items which field you want.

3. Query list from "Known Issues".

4. Collection operation.

5. Run If condition.

6. Send Notification.

7. Update "Known Issues" items.

Hope this will helps you. If anything needed kindly let me know.

Thanks,

Lakshmi Narayana C

Reply