Send email to a column that contains a value

[foppishinc]

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

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

[Yoichi]

Hi,

Can you share your workflow, if possible?

Regards,

[foppishinc]

Please refer to download link for the UiPath file:

https://we.tl/t-m7IiDiieMx

[Yoichi]

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,

[foppishinc]

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

[Yoichi]

Hi,

Can you check the following image?

Regards,

[foppishinc]

It works now. Thank you so much.