Unanswered

send an email for each distinct group in an excel online table

(0) Share

Report

Posted on by amcneil32

167

hello, i need to build a flow that filters an excel table and sends an email for each distinct group in the table. Here's a generic example of what my excel table would look like.

Given this excel table I would need to send one email to customerA@email.com with each invoice listed and the same for each customer. The customers from this source will change daily. I previously created a flow that iterates through an excel online table and sends an email for each row. The difference is i want one email for each group with all it's rows. How can this be achieved with power automate? thanks

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi @amcneil32

You would perform a union on the email field union(emailfield,emailfield) and this would return the three emails as an array. Using this array you would then perform an apply to each and for each value, filter the get rows from excel for the email in order to create an array, and send an email with only those select emails.

A bit like the apply to each here https://www.youtube.com/watch?v=cAHRrmZBzVU

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
amcneil32 167 on at

Like (0)

Report

@DamoBird365, thanks for response. I'm not too certain of the last step in my flow that requires emailing each email account with their corresponding filtered array. When I try to use the "send an email action" with the output of the html table it sends both filtered arrays to each email. Any thoughts? thanks again

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

@amcneil32

You would want the send email action within your apply to each 2.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
amcneil32 167 on at

Like (0)

Report

@DamoBird365 , this solution works. thanks for the help. The formatting of each html table isn't quite what I'm looking for though. Is it possible to have each filtered array sent as an excel file? It looks like the update row excel action only updates single rows. I guess what I'm trying to ask is is sending the filtered arrays as an html table my only option here? thanks

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi @amcneil32

If you want to create an excel file for each email and in a table, you might want to consider watching my recent videos here.

Using excel scripts you can build bespoke Excel Files.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
amcneil32 167 on at

Like (1)

Report

@DamoBird365 , I think I'll have to explore excel scripts in the future. For now I added CSS to my flow to format the tables. thanks for the help

Was this reply helpful? Yes No