cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dfarrar
Frequent Visitor

Downloading PDFs from SQL Server

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?

1 ACCEPTED SOLUTION

Accepted Solutions
mogulman
Impactful Individual
Impactful Individual

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.

View solution in original post

4 REPLIES 4
v-yuxima-msft
Community Support
Community Support

Hi @dfarrar ,

 

Do you want download PDF from the PowerApps?

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

20190314downloadtoPC2.PNG

 

Hope this could be helpful.

 

Best Regards.

Yumia

@v-yuxima-msft 

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

mogulman
Impactful Individual
Impactful Individual

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.

Hi @dfarrar @mogulman ,

 

Thanks for your post and solution.

 

Best Regards.

Yumia

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (4,052)