Email alert

[Svav]

Hi Team,

I have an out put which four columns . So in first and second column we will have null values (based on the query). If we have null values in the column 1 and colunm 2  it should send a one email alert no null values no email. How to do that.its urgent please help.Thanks.

 

 

[Garabujo7]

Hello @Svav ,

You may use a filter with this condition IsNull([column1]) and isnull([column2]).

Gabriel

[acarter881]

Do you mean NULL is present in both column 1 and column 2 in the same row or that there exists at least 1 NULL in column 1 and 1 NULL in column 2?

I've accounted for the latter scenario; I believe Garabujo7's reply accounts for the former. See attached for my workflow.

[Svav]

Its based on the query some times we have multiple nulls in both columns. And i want to trigger only one email for all the nulls in both columns

[Svav]

I tried the filter but it is throwing n number of emails . I want only one email

[Svav]

Hi, Thank you for the quick response. I have null in the column a but it is not sending any emiail

[Svav]

hi, I am unable to download the workflow can you post the image please. Much appreciated for quick response

[Felipe_Ribeir0 · Accepted solution]

Hi @Svav 

Just use a sample tool with the configuration First 1 after the filter to send just one email.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[KrishnaChithrathil]

How about this @Svav ??

[Svav]

Thank you so much. It worked amazingly.