cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kamacete
Helper III
Helper III

Send different emails with multi rows content

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

 

1.png2.png3.png

 

Thank you very much

1 ACCEPTED SOLUTION

Accepted Solutions
manuelstgomes
Super User II
Super User II

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:

Screenshot 2021-03-04 at 16.36.17.png

 

The end result works like this:

Screenshot_2021-03-04_at_16_40_02.jpg

 

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

6 REPLIES 6
Kamacete
Helper III
Helper III

anyone can help, please?

manuelstgomes
Super User II
Super User II

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.

Screenshot 2021-03-02 at 16.09.19.png

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.

Screenshot 2021-03-02 at 16.09.33.png

 

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
Helper III
Helper III

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
Super User II
Super User II

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
Super User II
Super User II

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:

Screenshot 2021-03-04 at 16.36.17.png

 

The end result works like this:

Screenshot_2021-03-04_at_16_40_02.jpg

 

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
Helper III
Helper III

Hi Manuel,

A huge thanks for all the support

Br,

Rui

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (37,804)