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!
In order to show some columns only, this post from John Liu will be useful for you
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
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
Hope this helps