Downloading PDFs from SQL Server

[dfarrar]

I have PDF files stored in my SQL Server database and can display them in my app using the PDF Viewer. Is there a way I can download them from the app?

[v-yuxima-msft]

Hi @dfarrar ,

Do you want download PDF from the PowerApps?

Add one button, and Button1.OnSelect:Download(Gallery2.Selected.'Link to item')

Hope this could be helpful.

Best Regards.

Yumia

[dfarrar]

@v-yuxima-msft 

Problem is that the files are on a SQL server, so no url.

[mogulman · Accepted solution]

I may be surprised but I just don't think it is possible.  SQL Server stores pdf in a blob which is binary storage.  The rendering of the url expects a mime type (.pdf).  I just don't how this can be done.  You probably need to create a web service that can take a url, figure out which pdf in SQL Server, extract pdf and place in file on webserver and trigger the appropriate response to PowerApps.

[v-yuxima-msft]

Hi @dfarrar @mogulman ,

Thanks for your post and solution.

Best Regards.

Yumia