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