Power Platform Community Forum Thread Details

Hi,

I've created a flow in PowerApps that gets a photo from SQL Server connector. The column name in sql server table called applicant_image and data type is varbinary(max). I used the following query to upload a sample photo:

Update xxx set applicant_photo = (select BulkColumn from Openrowset(Bulk N'D:\xxxx\shrek.jpg', SINGLE_BLOB) image)
where registration_number =1234567891

I followed the solution noted at

by adding a Parse JSON

- Content: added "[applicant_photo]"

- Schema: Clicked on 'Generate from Sample' and added below code.

[{
"$content-type": "image/jpeg",
"$content": "Test Content"
}]

before gets to create the note it gives this error: "Invalid type. Expected Object but got String."

before adding Parse JSON I tried base64(applicant_photo) in note's Document column, Power flow runs with no error. However the image file can not open.

Any help is greatly appreciated.

Categories:

Using connectors