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 / Multi Filters in Excel...
Power Automate
Answered

Multi Filters in Excel Database

(0) ShareShare
ReportReport
Posted on by 18

Hi experts,

I have a database like this with many columns. I want to filter only 3 columns and send results to manager by email.

It's very easy to use pivot table but the problem is I can not send pivot table by email in flow.

Could you please give me some ideas to solve this database.

 

Thank you!

 

report.JPG

kaizen database.JPG

 

 

Categories:
I have the same question (0)
  • efialttes Profile Picture
    14,756 on at

    @tritran 

    Let me see if I understood. You want to send only three columns via email, so the resto of the columns should not be displayed on the ody of the email, right?

    If so, this post from John Liu will be useful for you

    http://johnliu.net/blog/2018/4/how-to-use-select-to-simplify-create-html-table-and-create-csv-in-microsoftflow

    Hope this helps

     

  • tritran Profile Picture
    18 on at
    Exactly what I mean. I want to display 3 columns and count number of rows of these.

    Thanks
  • Verified answer
    efialttes Profile Picture
    14,756 on at

    @tritran 

    In order to show some columns only, this post from John Liu will be useful for you

    http://johnliu.net/blog/2018/4/how-to-use-select-to-simplify-create-html-table-and-create-csv-in-mic...

    The example described by John is based on Sharepoint lists, but the procedure is the same than for excel: I am assuming you use 'List rows present in a table' action block to read the excel table.

    In order to count number of rows, you can use the expression lenght(). You shall apply this function to 'List rows present in a table' action block output, so the resulting expression can be added to the email body also

    Hope this helps

  • Verified answer
    tritran Profile Picture
    18 on at

    @efialttes 

     

    My flow is working perfectly!

    Thank you!

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
David_MA Profile Picture

David_MA 223 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 205 Most Valuable Professional

#3
harshdeol Profile Picture

harshdeol 167 Moderator

Last 30 days Overall leaderboard