Skip to main content

Notifications

Power Automate - Using Flows
Answered

Send One Email per Person in a Mixed List

(0) ShareShare
ReportReport
Posted on by 50

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 :

 

YearMonthPartnerEmailCurrent AmountAging 31-60 days
20231AA@email.com1030
20231BB@email.com2040

 

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 :

 

YearMonthPartnerEmailAmountAging 31-60 days
20231AA@email.com1030
20231BB@email.com2040

 

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 :

YearMonthPartnerEmailAmountAging 31-60 days
20231AA@email.com1030

 

and partner B should receive :

YearMonthPartnerEmailAmountAging 31-60 days
20231BB@email.com2040

 

 

How can i dot please ?

 

Thanks

  • menphis Profile Picture
    menphis 50 on at
    Re: Send One Email per Person in a Mixed List

    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 ?

     

     

  • menphis Profile Picture
    menphis 50 on at
    Re: Send One Email per Person in a Mixed List

    Sure, thank you

  • ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Send One Email per Person in a Mixed List

    @menphis 

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

     

  • menphis Profile Picture
    menphis 50 on at
    Re: Send One Email per Person in a Mixed List

    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

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Send One Email per Person in a Mixed List

    @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, 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics

Restore a deleted flow