cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nvrhughes
Level: Powered On

Download Image from SQL Server

We have an app that uploads images to a SQL server and displays them within the app. 

 

The user needs to be able to download the selected image in a gallery to their local device. 

 

Is this possible to do from the app or flow? 

4 REPLIES 4
EricLott
Level 10

Re: Download Image from SQL Server

In Flow you can use the OneDrive connector to save images to your OneDrive. See below

flowExample.png

The tricky part is the File Content. How are you storing the image in SQL?

nvrhughes
Level: Powered On

Re: Download Image from SQL Server

I believe it is of binary type. @EricLott 

 

0x89504E470D0A1A0A0000000D49484452000.....

EricLott
Level 10

Re: Download Image from SQL Server

@nvrhughes 

That's good. That's what Flow expects.

JayJayOliveira
Level: Powered On

Re: Download Image from SQL Server

@EricLott This hexadecimal value that @nvrhughes showed is how the image is stored in SQL Server, but when accessing it on PowerApps it turns into a value like this
"appres://datasources/'Your DataSourceName'/table/'Your Table Name'/rows/'Row Number'/inline/'Your Image Column Name'".
So when using the method you showed saves a text like this on a file.
I'm trying to find workarounds but without success... Any other ideas?

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,864)