Send different emails with multi rows content

[Kamacete]

Hi all,

I have an Excel with several tasks per colleague. I would like to create a flow that sends a unique email with all tasks below 100% to the colleague with these tasks.

in the email body I would like to put the excel cells with his tasks

Thank you very much

[Kamacete]

anyone can help, please?

[manuelstgomes]

Hi @Kamacete 

Sure. There are a few steps, but I'll guide you through them. Also, I've attached a template that you can adjust to your needs.

First, we get all rows and add to an array variable the unique emails. These are the emails we want to send.

After that, we do an "Apply to each," filter the values from excel by email, generate a nice table to send to them, and then send the email.

Can you please check if and let me know if you have any questions?

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

[Kamacete]

Many thanks for your support. However the problem is that I just want to add excel lines in the body of the email where a cell is less than 100%.

[manuelstgomes]

HI @Kamacete 

In the "Filter Array," add a new line with the column name and 100. With this, you'll get a filter by people and by the completed task.

Can you please check if and let me know if you have any questions?

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

[manuelstgomes · Accepted solution]

Hi @Kamacete 

I forgot to tell you how to add a second condition. You need to go into "Advanced Mode" in the filter and then use the formula:

@and(equals(item()?['Email'], outputs('Compose')),equals(item()?['Avg'], '1'))

This will check 2 things:

1. If the email is the one we're parsing in this step of the loop.

2. If the Avg contains 1

You'll get something like this:

The end result works like this:

Can you please check if and let me know if you have any questions?

Cheers
Manuel

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

[Kamacete]

Hi Manuel,

A huge thanks for all the support

Br,

Rui