Sending an email notification if there are 5 or more items using a drop down choice


Badge +10

The user can log a know issue against a IT Device added to a list called 'Devices'. Display and list

This is the Workflow I've set up:

Workflow


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? 



Run If


2 replies

Badge +10

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. 

Badge +10

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?

Reply