Filter Excel Table and Create HTML Table, Email output via Power Automate 

Thanks for this. One thing that I want to note for folks who, like me, are struggling with getting the int expression to work properly: I wound up having to turn the criteria to string instead. Worked like a charm for the filter.

fantastic video

I HAVE BEEN LOOKING FOR THIS ANSWER FOR DAYS! well made video!

Great, clear, video. Much appreciated.

Hi Damo, I'm looking for help with a similar issue - I have a table from Excel which contains 20 distinct rows (Stores, operational objectives), I want to create an HTML table that send out the information to each individual store, so it shows there operational objectives. The issue I've been having is that instead of sending out the table's info to each individual store - it sends out the entire HTML table, so each store receives 20 rows of data pertaining to other stores. This situation you posted is similar but I can't figure out how to solve my issue. Any tips? Thank you for any help!!!

Thanks for video..this sorted one of my blocker..

Hello sir, I have a doubt... How to add the 10 members mail in outlook email by using expression

Great demo. How do I filter using dates? E.g. I have a table showing a Due By column and I want to just filter all of the overdue rows to send an email in power automate

Hello Sir, thanks for the guidance, i need some more guidance, i have multiple invoices details pertaining to different people, how to filter and email them the list of invoices with invoice date , amount , with customized subject and multiple emails in cc

It is very useful. But I have another requirement. I have a table with around 1000 records and each record has a field for email Id. Number of email Ids is around 50. I have to filter this table based on the email Id and send the filtered table to the respective email Id (not as attachment, but pasted in the body of the email). Is there any solution?

I followed ur steps but at last apply to each i am facing issue "To cannot be null or empty"... I wanted to filter by email and send all specific rows to receipint as one email. Similarly wanted to send table rows for other unique email.. Plz help me

How can send an email with just the contents of an excel file ? Don't need to have multiple emails as there is only one recipient.

Hi, I am struggling with adding the serial numbers to the create html table. Can you please help me???

Very useful. THanks..

Friend! thank you so much, this was so usefull for me

Great video! Thanks!

Hi, what I am struggling how to send individual excel line to respective people in the HTML format.

Great