Share
ReportHi,
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.
All responses (
Answers (
7,635
