Skip to main content

Notifications

Power Automate - Using Flows
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

 

 

  • Verified answer
    tritran Profile Picture
    tritran 18 on at
    Re: Multi Filters in Excel Database

    @efialttes 

     

    My flow is working perfectly!

    Thank you!

  • Verified answer
    efialttes Profile Picture
    efialttes 14,756 on at
    Re: Multi Filters in Excel Database

    @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

  • tritran Profile Picture
    tritran 18 on at
    Re: Multi Filters in Excel Database
    Exactly what I mean. I want to display 3 columns and count number of rows of these.

    Thanks
  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Multi Filters in Excel Database

    @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

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics

Restore a deleted flow