Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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? 

Resident Rockstar
Resident Rockstar

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?

I believe it is of binary type. @EricLott 




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

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

Frequent Visitor


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


Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,296)