Is there any way of sending a pdf which is stored in a SQL varchar(max) column as an email attachment from powerapps without using Azure Blob Storage?

Is there any way of sending a pdf which is stored in a SQL varchar(max) column as an email attachment from powerapps without using Azure Blob Storage?
Hi @Kollenel26,
It's a bit tricky but doable.
Here are the steps I would do:
- install an on-premise data gateway on your SQL server
- in your Power App add the SQL Server connector using the gateway details
- once the connection is added select the table
- bind the table to a combo box or gallery
- add the Office 365 Outlook connector
- add a button
- on the OnSelect property of the button add something like:
Office365.SendEmail("destination email","email title",ComboBox1.SelectedItems)
Hope this helps,
Ovidiu