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.
Solved! Go to 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,
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,
Thanks I also watched https://www.youtube.com/watch?v=qX3i8456YwU to give me some guidance.
User | Count |
---|---|
255 | |
126 | |
104 | |
49 | |
49 |