cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrianHFASPS
Continued Contributor
Continued Contributor

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
v-xida-msft
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
v-xida-msft
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.
BrianHFASPS
Continued Contributor
Continued Contributor

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (5,917)