If row contains specifik value, then send that row, to an email

[supermanPunch (Arpan)]

@christian.bendtsen

The format of the email. would just be something like this:
"hallo here is status

insert the whole specifik row that contains a specifik name

kind regards"

I’ll attache the excel.

@christian.bendtsen ,

Assuming you are already handling the logic of contains of particular word that you want to filter the row.

Then after the row contains the particular word is a match, you could convert the row to Datatable using the below Expression :

{row}.CopyToDatatable

Above expression will convert only that particular row to Datatable, which will also include the headers of the Datatable.

After performing the above operation, Check the below post on converting the datatable to HTML table, so that you could add it in email body.

DataTable to HTML using Assign Activity

Hi @JavRR , Glad to know that it is useful to you You could try below expression to get what you wanted to. HTMLBodyStr="<table border=2><b><tr><td>"+String.Join("</td><td>",TestDt.Columns.Cast(Of DataColumn).Select(Function (x) x.ColumnName).ToArray)+"</td></tr></b>"+ "<tr>"+String.Join("</tr><tr>",(From x In TestDt.AsEnumerable Let cells="<td>"+String.Join("</td><td>",x.ItemArray)+"</td>" Select cells).ToArray)+"</tr>" Thanks,

Let us know if you are not able to understand the steps or if the requirement is not as mentioned.