How to get All row data based on Column

[Vincent_Nuestro]

Hi,

i want to filter out all record based on “Immediate Manager - Current”

then send Email to Manager, Norma

and Proceed to next “Immediate Manager - Current”

• Send Email to Nuestro, Vincent

so on…

Thank you in advance
-Vincent

[Palaniyappan (Palaniyappan P)]

Hi

Hope the below steps would help you resolve this

—use a excel application scope and pass the file path as input and get the output with a variable of type datatable named dt using Read range activity

—now use a FOR EACH ROW activity and pass the above dt variable as input

—inside the loop use a SEND OUTLOOK OR ANY SEND MAIL ACTIVITY and in the property of the activity pass the TO recipient as
row(“Immediate Manager - Current”).ToString.Trim

And then mention other properties like mail subject and mail body as you want

This will read each row one by one and include the TO recipient from the column you mentioned
And sends mail one by one

Hope this would help you resolve this

Cheers @Vincent_Nuestro

[Vincent_Nuestro]

hi @Palaniyappan

im sorry buddy but i missed out the condition statement.

It it supposed to be getting all the record Under “Immediate Manager - Current”

Expected Output.

Write in Excel

then attached it in Email and Send.

Next Loop…

[Palaniyappan (Palaniyappan P)]

@Vincent_Nuestro

It it supposed to be getting all the record Under “Immediate Manager - Current”

Is it like you want to group by that column and send mail
@Vincent_Nuestro

[Vincent_Nuestro]

yesss. @Palaniyappan

send all records under “Immediate manager - Current”

[Palaniyappan (Palaniyappan P)]

Fine

First let’s splitting up datatable by grouping that column
And then will read them one by one and send the mail

Refer this thread to split datatable on group by of a column

How to split datatable based on Group by and values in a column in Linq Query? Please Help

I need to split datatable into two datatables based on Group by and another column values. From the Source Datatable, I need to move records based on Group by columns “Col 1” and “Col 2”. In addition, if the values in the “Col 3” contains “I” & “A”, then the set of records should be moved to new datatable (DT1). And rest of the Source Datatable should be moved to another new datatable (DT2). Please help me to solve this. What I have: Source Datatable: [image] What I need: In a New Datatabl…

Cheers @Vincent_Nuestro

[MEHER_BJ]

Read the excel and output as dt.Get Unique column values from ‘current manager’ column. Output should be array of strings. (Linq query can be used.) Using for each (item in array) filter dt with item and send email ( for that email ID.

[Vincent_Nuestro]

hi @Palaniyappan the output of this Thread is not the result what i expect.

is there any other way?

[Vincent_Nuestro]

@Palaniyappan @MEHER_BJ

there is a possibility that is more than 2Immediate Manager in the record this is a dynamic data. Sometime it is more than 4 records or Less

[Vincent_Nuestro]

hi @MEHER_BJ can you share workflow on this? please

[Ying_Zhu]

thanks, it works for me