Power Platform Community Forum Thread Details

EXCEL FLOW TO SEND EMAIL TO RECEIPIENT BUT GROUP ALL ROWS FROM SAME RECEIPIENT

Hello Gurus,

I'm even sure if this is possible, but I would like to try. Maybe some bright minds may have a solution.

I have an Excel file, saved in a SharePoint folder, with a tab name "Test" and within the tab there is a table "Plan". Just your basic table with multiple columns which include email columns from the contact, supervisor, and project manager. The rows are individual projects associated with the contact.

Is there a way I can create a flow that sends an email to, lets say Donald, who has 3 projects to his name and include columns (that i want to include) and cc supervisor and project manager? Then provide a stamped date when it was sent on the same table.

For extra credit, can the trigger send to all the contact, not just Donald? The same requirement would be the same for the other Contacts. Individual email listing their projects.

TITLE	COST	DATE	COUNTER	CONTACT	Street	City	Email	Supervisor	Supervisor Email	PM Email	DATELASTEMAILED
PROJECT1	3	6/22/2023	511	DONALD	1235 MICKEY ST	DISNEYLAND	DONALD@123DISNEY.COM	MICKEY	MICKEY@123DISNEY.COM	ME@MEMEME.COM	date the trigger was sent
PROJECT2	5	6/29/2023	504	DONALD	3245 DONALD AVE	FANTASIA	DONALD@123DISNEY.COM	MICKEY	MICKEY@123DISNEY.COM	ME@MEMEME.COM
PROJECT3	10	6/21/2023	512	DONALD	2587 MINNIE LANE	LOS ANGELES	DONALD@123DISNEY.COM	MICKEY	MICKEY@123DISNEY.COM	ME@MEMEME.COM
PROJECT4	15	6/22/2023	512	MINNIE	1235 MICKEY ST	DISNEYLAND	MINNIE@123DISNEY.COM	DONALD	DONALD@123DISNEY.COM	ME@MEMEME.COM
PROJECT5	10	6/23/2023	512	MINNIE	3245 DONALD AVE	FANTASIA	MINNIE@123DISNEY.COM	DONALD	DONALD@123DISNEY.COM	ME@MEMEME.COM
PROJECT6	45	6/24/2023	512	MINNIE	2587 MINNIE LANE	LOS ANGELES	MINNIE@123DISNEY.COM	DONALD	DONALD@123DISNEY.COM	ME@MEMEME.COM

So the email will look something like this

The main purpose is to automate the emailing process without having to individually copy and paste into Outlook and sending it that way.

I appreciate the help and reading through this post.

Kind Regards

Categories:

Business Process Flows

Hi,

Yes, there are a ton of website blogs and YouTube's on this, and it is easy to duplicate. I found a flow of mine from a few years ago. Essentially my version of this sends one email for each primary email address for all related rows. The email itself contains a nicely formatted html table and is sent with a CSV attachment. Works well, I am using this one in production that has run for more than two years in a row every single day!

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

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Quick Links

Leaderboard