web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / E-mail reminders based...
Power Automate
Unanswered

E-mail reminders based on PowerBI table: one per addressee

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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!

Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,613 Super User 2026 Season 1 on at

    What's the rule for Table1 ? Why two rows there?

  • CU24070736-1 Profile Picture
    on at

    Good day,

     

    I don't know why this has been posted under Anonymous user. Each table should contain data for one individual user. So the rule is e-mail address.

     

    Thank you for your reply

  • lbendlin Profile Picture
    8,613 Super User 2026 Season 1 on at

    Table1 shows two email addresses?

  • CU24070736-1 Profile Picture
    on at

    Generally in the e-mail reminder itself I only need SKU codes listed, apologize for confusion.

    So all the other columns can be removed. Each table can contain multiple number of SKU codes, the key is that it's splitted against e-mail address which acts as an unique identifier..

  • lbendlin Profile Picture
    8,613 Super User 2026 Season 1 on at

    Use the union(list,list) trick.

     

    Group a List for Summary Using Power Automate (flyingpolymath.com)

  • Hamden Profile Picture
    2 on at

    Bonjour 

  • CU24070736-1 Profile Picture
    on at

    Hi lbendlin,

     

    thank you for this article. Do you think I can use Power BI Report instead of SharePoint list? Or should I first export PBI Report to SharePoint list?

     

    Have a good day

  • lbendlin Profile Picture
    8,613 Super User 2026 Season 1 on at

    I don't understand the question - you hadn't mentioned SharePoint lists before.

  • CU24070736-1 Profile Picture
    on at

    Indeed. I have a PBI report I'd like to use as a source. However in the article provided by you there's SharePoint list used. 

  • lbendlin Profile Picture
    8,613 Super User 2026 Season 1 on at

    Ah, now I understand.  The idea is the same.  The source of the arrays doesn't really matter.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard