Solved: Send different emails with multi rows content

Kamacete · ‎02-25-2021

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

manuelstgomes · ‎03-04-2021

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.

View solution in original post

Kamacete · ‎02-26-2021

anyone can help, please?

manuelstgomes · ‎03-02-2021

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 · ‎03-03-2021

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 · ‎03-04-2021

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 · ‎03-04-2021

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 · ‎03-04-2021

Hi Manuel,

A huge thanks for all the support

Br,

Rui

Anonymous · ‎10-09-2021

Hi @manuelstgomes ,

I like the solution, could you explain the thought process why the condition used is People contains Email then if falls Append Array is Name: People and Value: Email.

Sorry I am not a programmer but would like to understand the design.

Cheers,

kbw