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 | 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 | 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 | Amount | Aging 31-60 days | |
2023 | 1 | A | A@email.com | 10 | 30 |
and partner B should receive :
Year | Month | Partner | Amount | Aging 31-60 days | |
2023 | 1 | B | B@email.com | 20 | 40 |
How can i dot please ?
Thanks
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 ?
Sure, thank you
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
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,