EMAIL DECISION

[grail0305]

Hello, Just want to ask if there a a way to solve this scenario;

after running the query, given the table below you can see that there is a total of 3 records.

ID_NO	Name
123	Mark
456	Bryan
789	Roger

So an email will be sent stating that there is a data in the table, but if another run the next day and the result

is like in the example below;

ID_NO	Name

An email will be sent stating that there are no data in the table, I have try using a decision tool but it seems both the true and false condition will be sending  the email,

I only need one email to be sent base on the condition, if anyone has an existing workflow, I humbly ask if you could share it here , Thank you so much.

[OTrieger · Accepted solution]

@grail0305 
You can use the Count Tool and then put a filter after it Count = 0. In this case an email will be sent only if there is no data