Inserting filtered table in attachments helps!

[maxiq_2k]

Hi, I have this problem, I have filtered a file in the cloud (Excel), and I need that the filtering be saved as an Excel file, and attach to the mail and send it to an X address, and I can't get it.

Thank you.

[abm]

Hi @maxiq_2k 

You can't create the excel file using Power Automate. What you could do is use the insert rows excel connector to insert the filtered rows into another existing file. The use the Get File Content to get the content and send as attachment via mail.

Have a look at this post

https://powerusers.microsoft.com/t5/General-Power-Automate/Create-Excel-file-through-flow-with-data-...

Another option is after the Excel action Filter step collect the results in a select action step , convert to HTML table.

Please see below.

The second option I haven't personally tried yet from excel filter results. This might work as well.

Thanks