Fetch data from data table

Help
, , , ,
1

Hi Everyone ,

Can anyone please let me know how to fetch data from data table .

I have an excel file with distribution lists (there are three columns in excel file - Division , To_email, CC_email )

I’m writing data from excel sheet to data table using read range activity .

now can anyone please let me know how to fetch data corresponding to each division , I.e To_email and CC_email .

here I’m passing division as dynamic data .

I have attached sample excel file , can anyone please help .Distribution List (1).xlsx (15.5 KB)

2

@priya_joshi_thaneti Use For each row and give input as datatable variable, Inside loop row(0).ToString Gives Divison Value
row(1).ToString Gives To Value
row(2).ToString Gives Cc Value

Each time loop run u will get new values from each row

3

@Manjuts90
Could you please let me know the code for relating the three columns.

4

@priya_joshi_thaneti Please Find below for workflow.

distribution-------.xaml (12.0 KB)

1 Like
5

Hi,
Refer the code below.

Main.xaml (10.9 KB)

1 Like
6

@Manjuts90 @Uthraa

Thank you so much for your prompt response

2 Likes