cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

Capture signature via pen input and upload to SQL?

I found this thread about a workaround for getting Pen Input Image into sharepoint. However it seems like it isn't a very direct solution due to storage of pen input. I am wondering if anyone has gotten this to work with SQL? If so can you share the data type in SQL and the Patch command. I have searched for this and can't find any refernces showing syntax.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @BrianHFASPS,

Do you want to save/store Pen Input Image from an app into your SQL table?

If you want to save/store the Pen Input Image from an app into your SQL table, I think the Image type column in SQL Server could achieve your needs.

Please check and see if the following blog would help in your scenario:

https://powerapps.microsoft.com/en-us/blog/upload-files-from-powerapps-to-sql-server/

 

On your side, you should create a Image type column in your SQL table firstly. Then set the OnSelect property of the "Save" button to following:

Patch(
'[dbo].[TestBlobUpload]', Defaults('[dbo].[TestBlobUpload]'), { FileName: TextInput1.Text, ImageTypeColumn: PenInput1.Image /* <-- PenInput1 represents the Pen Input control in your app */ } )

Note: The blog I provided above would also be applied to Pen Input control.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Hi @BrianHFASPS,

Do you want to save/store Pen Input Image from an app into your SQL table?

If you want to save/store the Pen Input Image from an app into your SQL table, I think the Image type column in SQL Server could achieve your needs.

Please check and see if the following blog would help in your scenario:

https://powerapps.microsoft.com/en-us/blog/upload-files-from-powerapps-to-sql-server/

 

On your side, you should create a Image type column in your SQL table firstly. Then set the OnSelect property of the "Save" button to following:

Patch(
'[dbo].[TestBlobUpload]', Defaults('[dbo].[TestBlobUpload]'), { FileName: TextInput1.Text, ImageTypeColumn: PenInput1.Image /* <-- PenInput1 represents the Pen Input control in your app */ } )

Note: The blog I provided above would also be applied to Pen Input control.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted

Thanks I also watched https://www.youtube.com/watch?v=qX3i8456YwU to give me some guidance.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (5,172)