Multi Filters in Excel Database

(0) Share

Report

Posted on by tritran

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!

kaizen database.JPG

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (2)

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
tritran 18 on at

Like (0)

Report
Copy link

Link copied!

Exactly what I mean. I want to display 3 columns and count number of rows of these.

Thanks

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Verified answer

tritran 18 on at

Like (1)

Report
Copy link

Link copied!

@efialttes

My flow is working perfectly!
Thank you!

Was this reply helpful? Yes No