Grouping multiple rows based on a unique column and sending one mail for each group

Like (0) Share

Report

Posted on 27 Jun 2024 09:27:08 by Tony_M

Hi everyone,

this one might get a bit tricky. I have been looking for a solution for over a week and have been stumped.

I have an excel which has several rows of data from several teams. Each team has a unique code. I want a flow which can loop through the rows and send only one email for each code. the email ids can repeat across the teams. I need the mail t go to one email, but also keep other email ids in cc. also, based on the team code, I need some data from other columns to be presented as a table.

Here is how my excel looks.

So in short, I need a way to make the flow filter out the excel rows based on the team code, and send one email to each team. If i group the excel rows based on the code and then use that excel file on power automate, can it select those groups?

Could someone please help me with this?

Categories:

Business Process Flows

All responses (1)

Answers (0)

ManishSolanki 15,085 Super User 2025 Season 1 on 27 Jun 2024 at 09:49:59

Like (0)

Report

Re: Grouping multiple rows based on a unique column and sending one mail for each group

Hi,

You may refer the logic for grouping data as mentioned in my blog:

Single consolidated email to user (owner) for single select user field in SharePoint - Microsoft Power Platform (manish-solanki.com)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.