Download Image from SQL Server

[nvrhughes]

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? 

[EricLott]

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

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

[nvrhughes]

I believe it is of binary type. @EricLott 

0x89504E470D0A1A0A0000000D49484452000.....

[EricLott]

@nvrhughes 

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

[JayJayOliveira]

@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?

[Giole]

Hi

I encountered the same issue and got your results.

So I tried to retrieve the Image File stored in SQL directly from SQL and not from Powerapps. It works like a charm

first "get the row (V2)" via ID from SQL, then "create file" in OneDrive using the column from SQL.
works for me