cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Seralia
New Member

Send an unique email from Excel file

Hi All,

I have an excel file as example:

 

me@world.com | Today | 20

you@world.com | Yesterday | 25

me@world.com | Yesterday | 15

him@world.com | Today | 10

you@world.com | Today | 20

 

I'd like to build a Flow to send an unique email to recap the lines, so:

 

Mail 1

To: me@world.com

me@world.com | Today | 20

me@world.com | Yesterday | 15

 

Mail 2

To: you@world.com

you@world.com | Yesterday | 25

you@world.com | Today | 20

 

Mail 3

To: him@world.com 

him@world.com | Today | 10

 

I tried a Conditional check, but the only thing I got was to send an email for each row and not a recap... which is the right way to "group" data from excel and to use them in a single way?

 

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Gericom
Resolver II
Resolver II

Hi 

 

I have made a example 

Gericom_0-1622108301750.png

 

Gericom_1-1622108327852.png

Gericom_2-1622108492234.png

Gericom_3-1622108554462.png

Gericom_5-1622108592934.png

Gericom_6-1622108680646.png

Gericom_7-1622108803883.png

with kind regards

--------------------------------------------------------------------------

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

5 REPLIES 5
Gericom
Resolver II
Resolver II

Hi 

 

I have made a example 

Gericom_0-1622108301750.png

 

Gericom_1-1622108327852.png

Gericom_2-1622108492234.png

Gericom_3-1622108554462.png

Gericom_5-1622108592934.png

Gericom_6-1622108680646.png

Gericom_7-1622108803883.png

with kind regards

--------------------------------------------------------------------------

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

Seralia
New Member

Thanks for your answer.

I tried the solution proposed, but Power Automate do not save the Flow as per an error in Emailing action out of the Scope the "Foreach 2" action refers to...

I'm new to Scopes, not sure of how they works...

Gericom
Resolver II
Resolver II

can you send me a screenshot of the error ?

a scope is noting special is is used to group your code to getter 

Seralia
New Member

I had an issue using Italian function from English example... It works perfectly as needed... and I learned How to use Scopes 🙂

Thanks

Hi @Gericom

 

May I please see the entire flow to this I'm stuck at the start where you've Appended to Array Variable and I couldn't select Title from Select. 

 

I have a similar scenario where I need to send unique emails that contain a html table but couldn't quite figure out how to uniquely send each recipient an individual email containing their own data and not everyone else's. 

 

Please see images:

 

Excel.xlsx - Excel.pngFlow.pngResults.png

 

Thanks in advance. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Top Solution Authors
Users online (2,488)