Unanswered

Flow Email Attachment Content as varbinary(max) parameter to stored procedure

(0) Share

Report

Posted on by Bukester

Hello,

Idea is Flow listens for emails and inserts attachments to a SQL Server FileStream filetable as such:

2019-05-26 16_41_29-Window.png

The stored proc executes with the following error:

400 - Invalid binary encoding

This is the cleanest way for me to do the insert for each attachment but comes down what is the binary type sent? I

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Hi @Bukester ,

FileSystem is not a datatype and is enabled as an attribute on a Varbinary (max) column.

Please use the conversion functions to convert the value’s type to see if it will work:

Base64ToBinrary

Best regards,

Mabel

Was this reply helpful? Yes No
Bukester 4 on at

Like (0)

Report

Thanks Mabel! Do we agree that its the "Attachment Content" that is the file itself? The payload so-to-speak? It has to be. I'll try your suggestion and update the post. It would be great if it was. Otherwise, I'd have to copy to the directory presented by the FileTable, which is not so bad anyhow.

Was this reply helpful? Yes No
Bukester 4 on at

Like (0)

Report

No luck. It still doesnt like the "Invalid binary encoding." I can also see that the stored procedure is never called, so Flow is not capable of constructing the RPC call at all. Its failing within flow.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Add-support-for-binary-data-types-in-SQL-Server-and-Azure-SQL-DB/idi-p/30178

This is saying its available in PowerApps but not in Flow. But thats as of August 2018.

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report

Hi @Bukester ,

Please try to input your function in the following way under Expression tab:

Best regards,

Mabel

Was this reply helpful? Yes No
jeremartin 2 on at

Like (0)

Report

I tried both base64ToBinary(ContentBytes) and base64ToBinary(body('Get_attachment')), but with the same error "Invalid binary encoding." I have a OneDrive Create File right before the Execute stored procedure (V2), and it successfully saves the attachment to the one drive folder. But the SQL component always gives a "Invalid binary encoding".

Was this reply helpful? Yes No