How to get All row data based on Column

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

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

1 Like

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…

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

yesss. @Palaniyappan

send all records under “Immediate manager - Current”

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

Cheers @Vincent_Nuestro

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.

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

is there any other way?

@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

image

hi @MEHER_BJ can you share workflow on this? please