I have an excel file like the table above which contains a list of people, their RO’s name and email and indication if the person’s license have expired. So, if the person’s license has expired, the automation needs to send an email to the person’s reporting officer. Instead of sending one email at a time, I would like the automation to identify all the people whose license has expired and send to the RO in one email. For example, Person A should receive an email with person 1 and 3 names in one email.
First read data into datatable use filter datatable to filter for the required status
Now create a variable of type array fo string and use assign or set variable with variable on left and on right use filtereddt.AsEnumerable.Select(function(x) x("RO Email").ToString).Distinct().ToArray this will give all unique ro emails which have status of yes
Now use for loop on the array
Inside array use filter datatable with filter as currentitem which is the email on the email column and save to different datatable..so the output would contain only rows belonging to the manager email id and license as yes..so you have all in one table
For each iteration you would have different manager related set of datatable..