How to get sepcific value from datatable using column name

Help
, , ,
1

Hi Guys I am struggling with the below issue.
I have an excel containing List of Sender Names and Sender Email ids
I want to read from the datatable DT the email id which is against sender - DEF.
How can i do this , pls advise.

image

2

@Rani1978 Please use If else condition,

3

@Rani1978
Here is the XAML file
GetEmails.xaml (8.3 KB)

image
image557×801 18.4 KB

4

Thanks MartianxSpace. I was wondering if there can be a direct way to just extract the item directly from datatable without using for each item. I know for sure there will be only one record in the excel pertaining to one sender. I tried the below code -
Assign >>
Array_of_ Datarow = DT.Select(“Sender = ‘DEF’”)
this gave me – DEF I def@gmail.com

i want to extract only def@gmail.com from this Array_of_Datarows. Is it possible to extract this.
else I’ll have to use For Each Item in DT.

Pls let me know.
Thanks.

5

@Rani1978 You can use Filter Data Table to Filter the Data

6

use assign activity like this enside for each row loop
Email = row(“Email Ids”).ToString
Email variable is of type String

7

Hi @Rani1978,

Please try this…

inputDt.AsEnumerable.Where(function(x) x(“Sender”).ToString.Equals(“DEF”)).CopyToDataTable.Rows(0).ItemArray(1).ToString

Thanks!