Power Platform Community Forum Thread Details

I need to create and email an excel as an attachment. The data source is sql server, It must be a .xslx file and not a csv.

Is there a way to create an .xlsx from power automate and send it by email?

I don't want the Excel to be stored in OneDrive or SharePoint, I just want it to read the data from the SQL Server and send the Excel.

Categories:

Building flows

Hi @Supremelimo

Let's clarify a bit. You don't want to create a file, you want to create an in memory representation of a file, which is different.

There is no way I am aware of, at least not exactly. You can easily create the Data in an array, and then you could write it to a file, with an extension of XSLX.

Then read it back off using Get Content

And then send that as an Attachment.

But just in memory create a workbook, not that i know of.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey