Announcements
Hi everyone,
How can we submit the form having image column from power apps to MS-SQL?
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 ) } )
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?
Do you have a primary key on your table ?
Yes, ID is the primary key for the table.
Can you share the table schema and also the patch function ?
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 ) } )
Your Picture column should be Image type and not varbinary(max) type
For ex :
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?
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
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
wolenberg_ 119 Super User 2026 Season 1
WarrenBelz 107 Most Valuable Professional
Haque 103
