Capture signature via pen input and upload to SQL?

[BrianHFASPS]

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.

[v-xida-msft · Accepted solution]

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,

[BrianHFASPS]

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