My flow is sending more 1 email

(0) Share

Report

Posted on by menphis

Hi,

New in the community 🙂

I am trying to set up a feature that send email from power bi application.

i am displaying in a screen the collection amount per month and year and in another graph, i am displaying the repartition by clients
In power automate, i would like to send an email that contains :
- User
- Year

- Month

- Client

- Collection Amount

Currently i am receiving the right email, but i am receiving 11 times (11 clients for the test user)

How can i correct it ?

Thank you,

Avy

Categories:

Using flows

I have the same question (0)

All responses (20)

Answers (0)

Sort by

menphis 58 on at

Like (0)

Report
Copy link

Link copied!

@David_MA @Expiscornovus @Pstork1 @wskinnermctc
help please 🙂

Was this reply helpful? Yes No
Pstork1 69,323 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I assume the Apply to Each is looping on the clients. To get one email for all the clients you need to assemble the body of the email inside the loop, but send the email after you leave the loop. Create the body of the email by appending things to a variable inside the loop. Then use that variable after you exit the loop to send one email.

Was this reply helpful? Yes No
menphis 58 on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1,

Thank you for your help. can you tell me how can i do it ? which step i need to add and where in my flow ?

Thanks

Was this reply helpful? Yes No
Pstork1 69,323 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

1) Add an Initialize Variable for a String Variable just after the Trigger.

2) Replace the Send an Email with an Append to String action inside the loop.

3) Add a Send the email after the loop and use the string variable in the body.

Was this reply helpful? Yes No
menphis 58 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Pstork1
Sorry i am new in power automate and i am not fully understanding how i can follow your steps
Sorry to ask you that , but can you send commentaries based on my flow screenshot ?
It will help me to understand where i need to add the think and how can i do it.

Thanks

Was this reply helpful? Yes No
Pstork1 69,323 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Your screenshot doesn't include what you are doing inside the loop. But here's the basic placement of the things I was telling you to do.

Was this reply helpful? Yes No
menphis 58 on at

Like (0)

Report
Copy link

Link copied!

I think I've done something wrong. How do I fill in the Append to a string Value?

I've put the Partner Emails.
To summarize, i have this data :
Year Month Partner Email Client Amount
2023 1 A A@email.com C1 10
2023 1 A A@email.com C2 20
2023 1 B B@email.com C1 10
2023 1 B B@email.com C2 20

I want to send an email to each Partner the table that contains only his information with the list of his clients
Means that :
" Hi Partner A,
Year Month Partner Client Amount
2023 1 A C1 10
2023 1 A C2 20
"

Second email
" Hi Partner B,
Year Month Partner Client Amount
2023 1 A C1 10
2023 1 A C2 20
"

With my current flow, its combining both partner in the same email and sending it X times ( X = nb of clients)

Attached my flow ( Inside the step "Compose" there is only CSS code to format the table+ Output)

Thanks for your help and sorry to disturb for something that seems to be simple for someone that knows the basic of Power automate

Was this reply helpful? Yes No
Pstork1 69,323 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It wasn't clear from your original post what you were running the loop on. What you are proposing looks very different from the flow you currently have. Let me try to put together something similar and I'll send you some screenshots.

Was this reply helpful? Yes No
menphis 58 on at

Like (0)

Report
Copy link

Link copied!

Thank you @Pstork1 for your time and your patience 🙂

Was this reply helpful? Yes No
Pstork1 69,323 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Take a look at this Blog post I wrote on the topic. Its based on SharePoint, but other than the trigger the process should be the same. Send One Email per Person in a Mixed List – What Me Pa..Panic? (dontpapanic.com)

Was this reply helpful? Yes No