Send an email from excel file with Power Automate

[Anonymous]

Dear experts, 

I am new to PAD an I have created an automated flow that sends an email for each row, but as most of the IDs are repeated in the rows, each of them would receive more than 1 email. What I need is to be able to send one email for each "requisitioner", listing all the "blocked invoices" I have under his name. 

Thank you in advance! 

[MichaelAnnis]

This is not PAD.  This is PA flows (cloud).  The D in PAD is for Desktop, and the interface looks much different.

In PAD, we handle this by identifying the filenames on each row and then have a logic similar to the following:

For each row in Excel

    Add attachment to %Attachments%

    If the next email does not match this email

        Send Email with %Attachments%

        Clear list %Attachments%

    End (if)

End (for each)

This basically adds up all the filenames in a list called %Attachments% and analyzes the next row to see if the email is the same.  If it's the same, it adds the next one, but if it is not the same, then it sends out 1 email with all the attachments, then clears the attachments list.

In order for this to be successful, the Excel file has to be sorted by the 'email to' field.

Good luck!

[Anonymous]

Thank you very much for your answer, but as you said, I'm not using PAD but PA flows. Do you have suggestions on how to use this same logic there? 

[Nived_Nambiar]

Hi @Anonymous 

Would it be possible to share a sample file to get an idea how to do  and how to acheieve it ?

[Anonymous]

This is the structure of the excel file, what I need is to send, for example, a single email to Lara containing all the invoices I have under her name. 

[Nived_Nambiar · Accepted solution]

Hi @Anonymous 

You can try this way.

I have created a table for demo purpose like below

Flow is designed like below

1. List all rows present in the table

2. Select the email from the values which is output from List rows in tableaction.

3. Use apply to each loop to loop through each unique values of email like below

expression: union(body('Select_emails_'),body('Select_emails_'))

4. Inside the loop follow below steps

 4.1 Filter the value with email = current iteration email

 4.2 Now create HTML table out of filter array like below 

Here i am only considering Invoice num in table. You can other column if you need here , then use the output from create HTML table to be send via email.

Hope it helps 🙂

Mark it as solution if it resolves your query 🙂

[Anonymous]

In the free version of Power Automate that I'm using I don't have the variables "Select emails" and " Filter values with each email value". Which version are you using? Thank you very much. 

[Nived_Nambiar]

Hi @Anonymous 

I am using developer version which is provided for learning purposes