web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Can't Create Note with...
Power Automate
Unanswered

Can't Create Note with jpg image from SQL Server connector of varbinary(max) data type using Power Automate

(0) ShareShare
ReportReport
Posted on by

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."

hnejad_0-1639003949556.png

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:
I have the same question (0)
  • VJR Profile Picture
    7,635 on at

    Hi @hnejad 

     

    Are you saying that you have referred to the solution in this link.

     

    Could you also see if this link is of any help.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard