13
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.
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
Share
Report
All responses (
Answers (
