Using Power Automate to send emails to unique users

[spshah1]

I am using the Power Automate visual in Power BI. My goal is to send 1 email to each unique user for a table. In the email, it will contain all of the order information for that user.

My table has a row for every order. Every order is associated with an individual and their email address. Individuals can be assigned to multiple orders. My Power Automate currently sends each user a separate email for EVERY order. 

How can I have only 1 email sent to each unique individual with a list of ALL of their orders? Thank you. 

EDIT: I have a Pro License. Please do not recommend anything that requires a Premium License. 

[Jack_Henderson]

Has this been answered for the Power BI process?

At the moment I have automation set up to send an email for each project reference. 
However a project manager will have multiple project references hence at the moment recieve multiple emails. 
I would like to be able to send just 1 email to each of the project managers that lists all of the project reference numbers that they need to update, can someone please help?

Cheers,

Jack Henderson

[Octavia]

So, I feel like the incorrect part of the question is being answered here. 

How do we get Power automate to distingush between send emails to ALL recipients that have a due date on a certain day and sending only the relevant information to the correct party.

If I have 2 row items with the same due date BOTH of those contacts receive BOTH of each others emails instead of only getting the email they are supposed to get

[v-eqin-msft]

Hi @spshah1 ,

Please refer to:

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-send-multiple-List-Items-in-single...

Power Automate HTML Table Styling

Working with HTML tables in Power Automate Flows | It Ain't Boring

How to send multiple list items in ONE email using Microsoft Flow

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@spshah1 that is just an idea that how you need to compose which you need to apply on Power BI dataset.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@spshah1 follow this post to combine orders together.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[spshah1]

The "Common Data Services" does not seem to be available for me in Power BI. In Power Automate, it seems to be a Premium service. I have a Power BI Pro License.