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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Bi table send em...
Power Automate
Unanswered

Power Bi table send email and summary in mail body through power automate

(0) ShareShare
ReportReport
Posted on by 2

Hi,

I have created flow for Power Bi tables using power automate, in which on click it will send table in csv format as attachment to intended receiver.

Here i want one help, i have many rows in table but i want summary (or can say pivot on first level) of that table in the mail body, i tried to mentioned by SELECT option but each row is getting in mail body.

 

Can you please help.

 

 

Categories:
I have the same question (0)
  • PowerAppsWizard Profile Picture
    388 on at

    Hi

    Can you maybe use the filter array action?

     

    Input: your array from the report

    Left filter side item()?['Column you want to filter']

    Set: equals to

    Right filter side: the value you want to filter on

     

  • avinashm15 Profile Picture
    2 on at

    Hi, 

    I will just reframe my question.

    There is detailed table report which i want to send as attachment in mail (till this i have done by compose - create csv table - create file - send an email)

    and summary or pivot (don't need all rows of table) of that report on selected level in the mail body - for this i am looking solution

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard