Answered

Send One Email per Person in a Mixed List

(0) Share

Report

Posted on by menphis

Hi,

I Have a graph showing Amounts per partners. Lets suppose that i select 2 partners on this graph , i will get the following data :

Year	Month	Partner	Email	Current Amount	Aging 31-60 days
2023	1	A	A@email.com	10	30
2023	1	B	B@email.com	20	40

I want to send emails on selected partners that contain html data that sum up the information.

To do that, i have created an instant cloud flow and added a button on this graph to allow the managing partner informs there partners by sending them an email.
The result is that its sending 2 mails , and on each email, it displays in the html table the data of the 2 selected partners :

Year	Month	Partner	Email	Amount	Aging 31-60 days
2023	1	A	A@email.com	10	30
2023	1	B	B@email.com	20	40

And of course, the second partner must not see the data of the first partner.

I want just to filter the data for each partner concerned , that means
For Partner A, should receive :

Year	Month	Partner	Email	Amount	Aging 31-60 days
2023	1	A	A@email.com	10	30

and partner B should receive :

Year	Month	Partner	Email	Amount	Aging 31-60 days
2023	1	B	B@email.com	20	40

How can i dot please ?

Thanks

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@menphis

It is difficult to provide a definitive answer without seeing more of your Flow.

I believe that you have one row for each person. If so, add an additional loop after the filter array and loop through the data for each person. The Select, Create HTML table, etc. should be inside of the new loop.

That said,

I believe that you want to loop through the data for each person. Then,

Was this reply helpful? Yes No
menphis 58 on at

Like (0)

Report
Copy link

Link copied!

Hi @ScottShearer ,

Thank you very much, it solved the problem.
If i had few lines for each partner (by client), how should i do ?

Also, i added on mail parameter in the "Send as" a measure userprincipalname()
i granted access to someone else and i still receiving from Me to me.
Do you know how ?

Thanks

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@menphis

Can you post a screen shot of your Seand an email action configuration?

Was this reply helpful? Yes No
menphis 58 on at

Like (0)

Report
Copy link

Link copied!

Sure, thank you

Was this reply helpful? Yes No
menphis 58 on at

Like (0)

Report
Copy link

Link copied!

Hi @ScottShearer ,

Did you get the screenshot ?

About my flow, when i duplicate it to use with a different email column , its still send mutliple email.
of course i changed the email column
Have you an idea ?

Was this reply helpful? Yes No