Suggestion, getting photos out of SQL in a use-able way

[schuess3]

I am looking for some suggestions. I used a PowerApp to store some photos in an Azure SQL Table and I need to get them into an HTML document using Flow so that I can turn it into a PDF. I am successful using the SQL Action – Get Rows to get the Blobs I need, but not sure what to do next. Any ideas for me?

How can i get these photos out of SQL in a useable way?

[manuelstgomes]

Hi @schuess3 

You can convert them into a file and store them somewhere. There's a template that can get you in the right track:

https://emea.flow.microsoft.com/en-us/galleries/public/templates/b683e658a70a48a5b3d5f8cfff709f96/cr...

If this doesn't work please let me know and I'll try to help you further.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel