Dear Power Automate Experts,
I have a following table in Power BI:
SKU Code First Name E-mail
A John John@mail.com
B John John@mail.com
C Mary Mary@mail.com
D Kate Kate@mail.com
How can I split it into different tables based on E-mail, so:
Table 1:
SKU Code First Name E-mail
A John John@mail.com
B John John@mail.com
Table 2:
SKU Code First Name E-mail
C Mary Mary@mail.com
Table 3:
SKU Code First Name E-mail
D Kate Kate@mail.com
I want to send e-mail using PowerAutomate to each user, however I want to send one e-mail per user, so John will receive only one. To such messages a table with data for each user should be added. How can I achieve this? It would be great if Name can be added to e-mail body as well.
Thank you in advance!
