Save image in SQL from Power apps

(0) Share

Report

Posted on by lisha

Hi everyone,

How can we submit the form having image column from power apps to MS-SQL?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

Julien59 44 on at

Like (1)

Report
Hi
After saving your form, you will have to patch it using this method.
Picture is a field type "image"
Picture_varchar is a varchar
Patch( '[dbo].[pictures]'; { picture: UploadedImage.Image; picture_varchar: JSON( UploadedImage.Image; JSONFormat.IncludeBinaryData ) } )

Was this reply helpful? Yes No
lisha 80 on at

Like (0)

Report

Hi @Julien59,
Thanks for the sol, but whenever I tried to use this sol, the patch function show me the error of server response failed. Can you please tell me how can I solve this?

Was this reply helpful? Yes No
Julien59 44 on at

Like (0)

Report

Do you have a primary key on your table ?

Was this reply helpful? Yes No
lisha 80 on at

Like (0)

Report

Yes, ID is the primary key for the table.

Was this reply helpful? Yes No
Julien59 44 on at

Like (0)

Report

Can you share the table schema and also the patch function ?

Was this reply helpful? Yes No
lisha 80 on at

Like (0)

Report

SubmitForm('frm_edit info_1');Patch(User_data_1, Defaults(User_data_1), {Id:DataCardValue12_1,Picture_var:UploadedImage3_1.Image,Picture_var: JSON( UploadedImage.Image, JSONFormat.IncludeBinaryData ) } )

Was this reply helpful? Yes No
Julien59 44 on at

Like (1)

Report

Your Picture column should be Image type and not varbinary(max) type
For ex :

Was this reply helpful? Yes No
KI-13090739-0 12 on at

Like (0)

Report

I wonder if varchar(max) is the right field type for images. It has been told to use varchar(max) from some users, but why is the image type so much easier to use on the PowerPlattform?

Was this reply helpful? Yes No
MissingLink 236 on at

Like (1)

Report

You probably want to watch this. It explains what is going on between PowerApps and SQL. PowerApps: Save images from Camera, Pen and Add Picture control to SQL and display in a Gallery - YouTube

Was this reply helpful? Yes No