The user can log a know issue against a IT Device added to a list called 'Devices'.
This is the Workflow I've set up:
I've set up a Workflow with a Run If Action below. So the email needs to be sent out if the number of issues logged against a Device is 5 or more. So far I've got an email sending out if there are 5 Known Issues generally. So would it be the Run If I would set up and how would I set these conditions?
It's worth pointing out that 'Devices' is the Title field on that list so it's free text. A user could type in 'Acer 123' then in Known Issues could log a known issue against the 'Acer 123' which appears in a drop down. The email needs to go out if the number of issues is 5 or above.
Adding a Device creates a unique incremental number in a column called DeviceID, so I suppose I could use an action to count how many unique numbers there are and send an email when the unique number gets to 5 or above?