Answered

Flow - Insert Image In Sql

Like (1) Share

Report

Posted on 5 Apr 2017 16:40:25 by Mateo_Escobar

Hi friends, I take a file picture from sharepoint (Image library) Through flows aplication with target a field varbinary into a data base sql server, and showed this error:

Sin título.jpg

Categories:

General Questions

All responses (3)

Answers (1)

Dawidvh 1,346 on 03 Feb 2019 at 19:19:31

Like (1)

Report

Re: Flow - Insert Image In Sql

Hi everyone.

I have managed to upload from Flow to SQL Binary. Go and check out these two videos and let me know if this works for you.

Introduction - https://youtu.be/wJj0E1C4z0c
Using Variables in file upload - https://youtu.be/sgAx3aaRL8E
SQL Binary - https://youtu.be/hif0VfOhhMA

There are some other videos in the series but that is for OneDrive and SharePoint.

twitter: @DavesTechTips
youTube: https://www.youtube.com/channel/UCIMe_ErQZP5chbI9UyW0xLw
Meneghino 6,949 on 08 Mar 2018 at 21:23:05

Like (0)

Report

Re: Flow - Insert Image In Sql

Please support this idea:
https://powerusers.microsoft.com/t5/Flow-Ideas/Support-for-varbinary-type-columns-in-Flow/idi-p/97027
Verified answer

v-yamao-msft on 06 Apr 2017 at 06:09:54

Like (0)

Report

Re: Flow - Insert Image In Sql

Hi Mateo_Escobar,

Per my certain knowledge, PowerApps doesn’t support SQL Server Varbinary column.

I guess that Flow also doesn’t support Varbinary column. So you were getting the error “Unknown Mashup Exception”.

As I haven’t seen a similar one on the Flow Ideas Forum, please consider to create a request on it, other customers who have the same request would vote your idea at here. I will also collect and report this from my side.
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,
Mabel Mao