Only Send Email in Task if There is Data in the Variables Table

[Katie]

I have a task that sets a variable of a list of agencies whose expiration date is equal to the current date. It then sends me an email with the variables table. It is working great, but it is possible to set it to only send me an email if there is data in the table? If none of the agencies expired today then I don't need an email at all.

See screenshot of task.

Thanks in advance for any help!

[ParkLoey]

Hi @Katie! Not sure if there are better ways to do this but it worked for me! What I did was I created a variable that basically counts the records returned using the same filters I have for my table variable. Then, I put the send email block in an if then block so it first checks if the variable count is 0 or not:

Hope this helps!!

[CoopperBackpack]

Hello @Katie,

It is possible to check if the Table Variable (the 'ProAgencies' Table Variable in this example) is not empty.

For that, please test any of these approaches:

1) To check if any field in the TOP 1 record of the Table Variable exists.

2) To check if any field in the TOP 1 record of the Table Variable is not blank.

[Katie]

Thank you both!! I ended up using CoopperBackpack's Solution #2. Perfect!!!