Upload Signatures to SharePoint Using Power Apps with Pen Input

[@Velten-i6w]

4:20 I don't have the options ask in Power Apps. Only "contentBytes or Name"

[@andrewhess123]

I believe this recently changed, I'll have to take a look. Check in the Power Apps Trigger

[@user-mp2gr8ps5m]

I was wondering if you have a same flow however using powerapps v2 trigger ?

[@andrewhess123]

Hi, I created a new video using the PowerApps V2 Trigger, not the exact same flow, but I believe the functionality could help you get to the same answer. kzbin.info/www/bejne/kGfIlHuNapaIa80

[@PierreBLIN]

Comment puis-je faire maintenant avec Power Apps V2 ? Je ne peux pas faire "Ask In Power Apps"

[@andrewhess123]

J'ai quelques vidéos utilisant Power Apps V2, je devrai faire une autre vidéo sur Power Apps V2. I have a few videos using Power Apps V2, I will need to make another video about Power Apps V2

[@workdesk9128]

This is exactly what I was looking for, thank you for this tutorial. I don't even think a third-party app would be able to integrate the signature this well.

[@andrewhess123]

Awesome work desk, thanks for watching! Hope it's an easy method to follow!

[@toanuk]

I would like to know 1. Do we have to get a function in Json for Upload signature into sharepoint list. 2. PenInput is an image (Picture) why in a sharepoint Cannot have the same Image field. please let me know. thanks Toan

[@andrewhess123]

Hi Toan, 1. I am not sure about JSON for upload. I think it could be possible, but I have not done. 2. Not sure I understand, you can have same image field in SharePoint.

[@dusancomic1312]

I have a problem with save signature. UploadSignature.Run failed the method 'Run' has invalid value for parameter 'Addattachement_FileName'

[@andrewhess123]

Try putting in "test.jpg" in Power Automate with no variable, then see if that works, then work from there

[@dusancomic1312]

@@andrewhess123 No, it reports the same error

[@andrewhess123]

@@dusancomic1312 Would need more information to help solve, what is your UploadSignature.Run() command entirely in Power Apps? I'm 100% sure the solution works, maybe recreate the Power Automate entirely, a warning Microsoft gives for all Power Apps that use Power Automate can be corrupted if the trigger is modified.

[@janibekkadraliyev6671]

Nice video, Andrew! Thanks for sharing your implementation

[@andrewhess123]

Thank you for your support Janibek! I appreciate it!

[@icepath2019]

Still work? I need a Signatures.

[@andrewhess123]

Old way, still works but some things have changed.

[@icepath2019]

@@andrewhess123 I tried following the clip but it didn't work. The id shows numbers but when I press submit the form nothing happens. My code = SubmitForm(EditForm1); signature.Run( DataCardValue3, DataCardValue6.Text, Mid( JSON( PenInput2.Image, JSONFormat.IncludeBinaryData ), Find( ",", JSON( PenInput2.Image, JSONFormat.IncludeBinaryData )) + 1, Len( JSON( PenInput2.Image, JSONFormat.IncludeBinaryData )) - Find( ",", JSON( PenInput2.Image, JSONFormat.IncludeBinaryData ) )-1 ) )

[@PierreBLIN]

Comment puis-je faire maintenant avec Power Apps V2 ? Je ne peux pas faire "Ask In Power Apps"

[@marcosrenan93]

whta if it's a new data...how can i make this work (because i won't have the ID from the sharepoint list for instance).cheers

[@andrewhess123]

Hi Marcus, can you submit form or patch the data before you run the Power Automate? The ID field would be the best unique identifier, you could maybe use title but what if someone uses the same title field twice. Patch/Submit Form first, then Run() the Power Automate

[@nurulhjemran8892]

This is great Andrew, thank you so much for doing this video. It is very easy to understand and follow. I have a question, how can we protect the signature image so that the owners of the SharePoint will not misuse it for other means. Is there a way that the signature to be removed after a certain period of time? Looking forward to your reply :-)

[@andrewhess123]

Hi Nurul, Thanks for watching! You could build a Power Automate that looks at the list and deletes or moves the line items to another list based on the created date. It would be a scheduled flow, maybe monthly? This would be great for archiving too.

[@luisaugustomeyer2038]

Hi Sir, How can we print as PDF the information + signature picture? It is possible?

[@andrewhess123]

Hi Luis, sounds possible. Not sure how to explain through text. But totally possible to print as PDF + signature picture.

[@bergiotecnologiaymas6536]

Andrew, I know this is kind of old, can you give me a hand pretty please? I've been trying to implement this into my PA but I keep getting a "The function "run" has some invalid arguments" error. I don't think there's something wrong with the code, I've already tried deleting and creating the Flow in Automate several times. I don't really use the title column in this form so I didn't include it in the flow. SubmitForm(Form3); UploadSignature.Run( ID_DataCard1, Mid( JSON( PenInput1.Image, JSONFormat.IncludeBinaryData ), Find( ",", JSON( PenInput1.Image,JSONFormat.IncludeBinaryData ) ) +1, Len( JSON( PenInput1.Image, JSONFormat.IncludeBinaryData ) ) -Find( ",", JSON( PenInput1.Image, JSONFormat.IncludeBinaryData ) ) -1 ) )

[@andrewhess123]

Hi bergio, In your code it looks like the part where it says ID_DataCard1 is incorrect. Try putting in a simple text or something first to troubleshoot. Also, Those flows directly from Power Apps are very fragile, if you can and it's not too much work, I would try to recreate the entire flow if the problem isnt ID_DataCard1. Another option is when you create your Run code, check those parameters in the "intellisense" do they match the same amount of parameters?

[@toanuk]

Can you do the same for upload photos to sharepoint. Take photos upload to sharepoint. Look forward to it. Thanks

[@andrewhess123]

Hi Toan, yes you can. I have a video on it already although I think this video is cleared. Let me get the link

[@andrewhess123]

kzbin.info/www/bejne/g5a1fn2JeLOniJY&t

[@andrewhess123]

Thank you for watching, also!

[@andrewhess123]

There is also a new way to upload attachments to SharePoint, Reza Dorrani actually has an amazing video about it here, it's brand new! Check it out: kzbin.info/www/bejne/n4iclaN6o9l-qLs

[@SadaraxTutorials]

Are you able to save it as an image in an imagine column in sharepoint list?

[@andrewhess123]

Yes, Image column, attachment to list, or document library. All 3 can work.

[@SadaraxTutorials]

@@andrewhess123 thanks mate

[@basehumax]

Hi Andrew, thank you, I was looking this but the only problem I have is I need to create the records from PowerApps the only file I need the flow to handle is the pen input is this possible? if yes guide me please thanks

[@andrewhess123]

Hi basehumax, not sure I understand. In a List, the file needs to have at least a title and then you can add an attachment. Same if you pushed it to a document library the file needs a name and then the pen input.

[@basehumax]

@@andrewhess123 Hi Andrew, sorry I ask wrong question, I mean need to attached multiple files when patching forall using attachment control not a form, is that possible?

[@laszlogyor6628]

Thank you this video, it is very useful for me.

[@andrewhess123]

Thank you for watching Laszlo

[@leratotsoela7432]

This so much better very less complicated

[@andrewhess123]

Thank you Lerato! Glad this worked for you!

[@jmstampe]

Great video. So easy to understand

[@andrewhess123]

Thanks for your continual support Jonathan

[@toanuk]

please can you send the link for a last(previous video). i have the problem with attachement.ID for power automate. thank

[@andrewhess123]

Hi Toan, here is the link to the previous video before this one: kzbin.info/www/bejne/pKWnfmhuZ7J0rLc&t

[@javierpereyra7098]

Nice video Andrew! Would you like to share me your email? So I could send you some projects, I would like to share with you my grain of sand

[@andrewhess123]

Hi Javier, my email is [e-mail] , its also in the description of my youtube. Would love to see! Thanks so much for sharing!

[@markylon]

Thanks for this, truly amazing, I have one question. When I create a new item there is no task ID so it won't save the signature. So when I go back in the second time there is an ID number so it lets me save the signature. How do I get this to work the first time when there is no ID

[@andrewhess123]

Hi Mark, Thanks for watching, I believe your question may get answered in my previous video here: kzbin.info/www/bejne/pKWnfmhuZ7J0rLc&t which is how I set up the 2 galleries.

[@carlosalc3756]

Great video, thank you

[@andrewhess123]

Thanks Carlos!

[@processlive9376]

Excelent Thanks

[@andrewhess123]

Thanks for your support Process Live!

[@Pnp1983]

Clean and easy to understand ! thanks for Sharing

[@andrewhess123]

Thank you Perla! Glad it was helpful

[@PuellaMagiHomuraAkemi]

@@andrewhess123 How to do it with the trigger PowerApps V2?

[@andrewhess123]

I have some videos with using PowerApps V2 trigger, but not exactly on signatures. Writing this down.@@PuellaMagiHomuraAkemi

[@PuellaMagiHomuraAkemi]

@@andrewhess123 All good, you do this for free and I still know what to look out for while I had no clue before :)

[@SBB12]

The image that is getting saved as an attachment in my SharePoint is not the pen signature but a blank white box.

[@andrewhess123]

Hi Packers771, not sure why that is. Would need more info to help out.

[@SBB12]

@@andrewhess123 Hi, I use the same flow and it's run successfully, for my save button I use the code you outlined and also runs successfully. The issue is I face is, when I select the attachment in SharePoint the file gets save as a .jpg but when I select to view the file is shows a blank white box instead of the signature. I checked the input pen signature controls and could not figure out why this was happening. My form is set to edit mode when saving to SharePoint. SubmitForm(Form2); Upload_Signature.Run( IDLabelTest, TitleLabelTest.Text, Mid( JSON( PenInput2.Image, JSONFormat.IncludeBinaryData ), Find( ",", JSON( PenInput2.Image, JSONFormat.IncludeBinaryData ) ) + 1, Len( JSON( PenInput2.Image, JSONFormat.IncludeBinaryData ) ) - Find( ",", JSON( PenInput2.Image, JSONFormat.IncludeBinaryData ) ) - 1 ) );

[@tweebs1]

I like it!

[@andrewhess123]

Thanks for watching Ryan!