Send different emails with multi rows content

Like (0) Share

Report

Posted on 25 Feb 2021 19:28:58 by Kamacete

160

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

I have the same question (0)

All responses (7)

Answers (1)

Community Power Pla... on 10 Oct 2021 at 02:45:09

Like (0)

Report

Re: Send different emails with multi rows content

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

Was this reply helpful? Yes No
Kamacete 160 on 04 Mar 2021 at 19:00:21

Like (1)

Report

Re: Send different emails with multi rows content

Hi Manuel,
A huge thanks for all the support
Br,
Rui

Was this reply helpful? Yes No
Verified answer

manuelstgomes 6,625 on 04 Mar 2021 at 16:41:03

Like (2)

Report
Re: Send different emails with multi rows content

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.

Was this reply helpful? Yes No
manuelstgomes 6,625 on 04 Mar 2021 at 08:18:09

Like (0)

Report

Re: Send different emails with multi rows content

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.

Was this reply helpful? Yes No
Kamacete 160 on 03 Mar 2021 at 09:31:12

Like (0)

Report

Re: Send different emails with multi rows content

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%.

Was this reply helpful? Yes No
manuelstgomes 6,625 on 02 Mar 2021 at 16:11:54

Like (2)

Report

Re: Send different emails with multi rows content

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.

Getitemsfromarray...

Was this reply helpful? Yes No
Kamacete 160 on 26 Feb 2021 at 10:30:43

Like (0)

Report

Re: Send different emails with multi rows content

anyone can help, please?

Was this reply helpful? Yes No