cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
erin_lynch
Regular Visitor

Pen input save as a image in a sharepoint list

Apologies if there have been questions like this before. The only solutions that I have found are for document library and not SharePoint list  I am just really stuck on this problem within my powerapp.

 

I have an app for construction sites where the user fills out a form and signs it at the end with a pen input. The information is then submitted into a SharePoint list (not document library). As many of you know, the pen input does not save in an accessible format so cannot be view again after submission.

 

Ideally, I would like the pen input to save as an image directly to the SharePoint list but not overly sure how this is possible.

 

So far, I have managed to get the pen input to save an image file in a document library, but I then need this reference in the SharePoint list

 

The options that I have thought of are

 

Either email the image from the document library as an attachment and then attaching that to the list. However, attachments are already an active field on my SharePoint list and therefore I need to guarantee that by updating the list with the new attachment of the image , it does not delete my other attachments that are already there.

 

The other option I have thoughts of is just putting the link to the file in the signature space on the SharePoint list.

 

Both would need to correspond with the correct ID of the list item that they are submitted with. Any suggestions would be really helpful on how I can get the pen input to save as an image on a SharePoint list.

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

Hi @erin_lynch ,

Do you want to save image in pen input to your sharepoint list?

You need to pay attention to these points:

1)Picture data type is read-only in powerapps.

So you need to update hyperlink data type with the data of the pen input.

2)Image in pen input is just blob data, which is not an image file that could be directly saved in sharepoint list.

So you need to firstly create image file by using blob data in powerapps, then upload this file to sharepoint library, get this file's link, then response this link to your app. Then update your sharepoint list with this link.

 

The steps should be like this:

1)create a hyperlink data type field in sharepoint list

2)create a flow about this feather:

( It's not supported to create image file by using blob data in powerapps. You need to use flow to make this.)

Here's a blog about how to create this kind of flow in details for your reference:

http://www.cleverworkarounds.com/2019/06/08/getting-pics-to-sharepoint-from-powerapps-is-getting-eas...

//please notice that the powerapps part in this doc needs a little change, since you use peninput not add picture, please see my formula below.

Please notice that the flow in this doc does not include the last two steps:

get this file's link, then response this link to your app.

You need to make a little change.

The flow should be like this:6251.PNG

 

6252.PNG

 

3)in your powerapps:

insert an peninput control

insert a button to call the above flow to call this flow

The button's OnSelect:

ClearCollect(pics, { Pic: PenInput1.Image, Name: Rand() & ".jpg"});Set(stuff, JSON(pics,JSONFormat.IncludeBinaryData));
Set(link,'Copyof-pic7'.Run(stuff))
//'Copyof-pic7 is my flow name

Then you could get the created file's link by using: 

link.response

Please use this to update your hyperlink column. This link will be directly connected to the image in your pen input.

The hyperlink column should be updated by data like this:
https://.......0.5270xxxx.jpg

 

 

 

Best regards,

 

Community Support Team _ Phoebe Liu
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

1 REPLY 1
v-yutliu-msft
Community Support
Community Support

Hi @erin_lynch ,

Do you want to save image in pen input to your sharepoint list?

You need to pay attention to these points:

1)Picture data type is read-only in powerapps.

So you need to update hyperlink data type with the data of the pen input.

2)Image in pen input is just blob data, which is not an image file that could be directly saved in sharepoint list.

So you need to firstly create image file by using blob data in powerapps, then upload this file to sharepoint library, get this file's link, then response this link to your app. Then update your sharepoint list with this link.

 

The steps should be like this:

1)create a hyperlink data type field in sharepoint list

2)create a flow about this feather:

( It's not supported to create image file by using blob data in powerapps. You need to use flow to make this.)

Here's a blog about how to create this kind of flow in details for your reference:

http://www.cleverworkarounds.com/2019/06/08/getting-pics-to-sharepoint-from-powerapps-is-getting-eas...

//please notice that the powerapps part in this doc needs a little change, since you use peninput not add picture, please see my formula below.

Please notice that the flow in this doc does not include the last two steps:

get this file's link, then response this link to your app.

You need to make a little change.

The flow should be like this:6251.PNG

 

6252.PNG

 

3)in your powerapps:

insert an peninput control

insert a button to call the above flow to call this flow

The button's OnSelect:

ClearCollect(pics, { Pic: PenInput1.Image, Name: Rand() & ".jpg"});Set(stuff, JSON(pics,JSONFormat.IncludeBinaryData));
Set(link,'Copyof-pic7'.Run(stuff))
//'Copyof-pic7 is my flow name

Then you could get the created file's link by using: 

link.response

Please use this to update your hyperlink column. This link will be directly connected to the image in your pen input.

The hyperlink column should be updated by data like this:
https://.......0.5270xxxx.jpg

 

 

 

Best regards,

 

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

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,966)