Send email to a column that contains a value

I would like to send an email to the name where the column ‘Updated? (Y/N)’ is actually ‘N’

Screen Shot 2020-04-09 at 10.24.02 AM

I have tried with
DataTable.Rows(0).(“Updated? (Y/N)”).ToString.Contains(“N”)

but it still sends an email to A,B,C and D

Hi,

Can you share your workflow, if possible?

Regards,

Please refer to download link for the UiPath file:

https://we.tl/t-m7IiDiieMx

Hi,

Thank you for sharing.

Perhaps you should write the condition of If activity as the following.

row("Updated? (Y/N)").ToString.Contains("N")

Regards,

I have tried it but there is an error

Compiler error(s) encountered processing expression “outputdatatable.row(“Updated”).ToString.Contains(“N”)”.‘row’ is not a member of ‘System.Data.DataTable’.

Have provided the excel file here too:
https://wetransfer.com/downloads/3eef11c70b7296e614a299c6f407136420200409031400/7cb109

Hi,

Can you check the following image?

img20200409-3

Regards,

1 Like

It works now. Thank you so much.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.