How to convert varBinary(SQL) to Binary(SharePoint)

[GottiJay]

i have an sql old database that stores documents on using the Image column format. i want to download one of the files to sharepoint using the Create file connector on power automate.

i have tried the base64tobinary expression, but that doesnt seem to do it. the file is created, but its corrupt when i try to open it.

i think it has to do with the mechanics of how to covert the binaries. i was hoping someone can point me in the right direction here

[abm · Accepted solution]

Hi @GottiJay 

I have tested with varbinary and image format.

You don't need to convert at all. Here I have used local SQL Server.

Here is the video explaining about this.

https://youtu.be/rf0n-L8wCws

Thanks

[GottiJay]

thank you :). i was probably overthinking it

[CliveMM]

Hi the video is very helpful, but do you have an example creating a PDF instead of an image from a SQL Varbinary field. Following what you did with images i can create a pdf file but it does not open and looks to be the fromg type of format.

[abm]

Hi @CliveMM 

I tested with PDF. Here it is.

This is my SQL Table

I have used the below code to populate PDF/Docx

I can see the document in SharePoint document library and received the document as attachment too.

Overall it worked fine for the PDF and Docx files.

Question here is how you storing it. Where you creating this file to? SharePoint or Onedrive or send as email? 

[CliveMM]

Hi abm, thanks for the update, but I still cant get it to open the pdf. The PDF is created in Sharepoint but when you try to open the PDF it wont open.  This is what I have:-

Any ideas? 

[CliveMM]

OK I have fixed this myself in the end.  Basically the above example is over complicated. To fix it I removed the PDFData Initialise variable and the Set variable then in the create file put the dynamic link to the original varBinary column.  Sorted!  Thank you all for your suggestions in particular abm.