Sending one email containing information from multiple rows

[lweston]

Hi,

I'm looking for a bit of help on using power automate to send an email containing information from a list we have of orders placed by employees. The list is shown below and you can see on there that single order IDs can contain several rows (one for each different item ordered) 

What I am trying to do is to send one email that includes all the information for an individual order (by grouping them together by order ID). All I seem to be able to manage at the moment is where it sends one email per row (or item ordered). This isn't really what we need as if an employee orders 10 different items, this will send off 10 emails. 

Hopefully what I've asked has made a little sense and any help would be much appreciated!

[v-yetonggu-msft]

Hi @lweston ,

If I understand correctly, are you sending an email with item information grouped by OrderID?

I did a test for your reference.

In my scenario:

My SharePoint List:

My Outlook Inbox:

My Flow:

item()?['OrderID']
union(body('Select'),body('Select'))

item()?['PartName']

<b>OrderID:</b>@{items('Apply_to_each')}<br/>
<b>PartName:</b><br/>@{body('Join')}<br/><br/>

Best Regards,

Sunshine Gu

[lweston]

Hi, 

Thank you very much for posting this. I managed to do something very similar previously where it posted the orders into a HTML table but what I'm trying to do is send one email every time a new order is placed. 

So basically whenever a new Order ID is submitted into the list, an email is sent containing the information of every row containing that new Order ID. 

[v-yetonggu-msft]

Hi @lweston ，

Do you mean that when you create a new item, send an email contains information about the newly created item?

Best Regards,

Sunshine Gu

[lweston]

Hi, 

That's correct. So for example, when a new order is created and several rows are added showing the new order ID, it groups all these rows together for the same order and sends an email containing this information. 

Hope this makes sense 🙂

[v-yetonggu-msft · Accepted solution]

Hi @lweston ,

I did a another test for your reference.

Please check this test:

OrderID eq '@{triggerOutputs()?['body/OrderID']}'

My Outlook Inbox:

Best Regards,

Sunshine Gu

[lweston]

Hi, 

Thank you so much for your help on this! That seems to have worked and it's now doing what I need it to 🙂