Sending PDFs as attachments in outlook mail form SQL using powerapps

[Kollenel26]

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?

[a-ovbord · Accepted solution]

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