PowerApps Pen Input to SharePoint 

Great! I am going to explore using the pen input to mark up an existing image (like a chart or graph, circle the issue that needs fixing, etc)--I will report back if I get it working!! I think the pen input will just be an overlay relative to the image below (not actually altering that underlying image), but I think that should still work!

I haven’t watched it in full yet, but am bookmarking and liking in advance. Thanks!!!!

Thanks Shane! you are life saver, been trying everything for the last 2 days to fix the file doesn't seem correct format issue. You have finally addressed it here! Thanks for making such awesome content.

Great video, Shane. I used this to make a signature confirmation for training sessions. I was having issues getting the flow as you set it up to detect when a Sharepoint list item was created (tried adding a timer to delay the creation until I knew the flow would be ready to see it), so I just passed the JSON output to the Sharepoint list, and rewrote the flow to get the data from there. I wanted the file name of the image to have List info in it, so that seemed to work pretty well. Thanks for the help!

Hi Shane, I did everything on the video, but in the PDF, the image of the signature doesn't show up, instead there is just an X. Any ideas how to fix that?

VERY VERY VERY interesting video. I learned a lot. Thanks for going through the pain of figuring this out. And thanks for sharing it with us.

Hi Shane, I have watched almost all of your videos and would be nowhere close to where I am presently without them. This video solved part of an issue I had with gathering signatures and site sketches on mobile devices, but at that point the result could not be displayed on them (only opened in SharePoint or PCs with '{link}'). I have now solved that one (I am sure others have as well) and it may be worth a video some time to show how to others how to see signed forms on tablets. Briefly, the solution involved a "Thumbnail" field formatted as a Picture in the document library, a collection of signatures for the item (I keep all versions), a gallery with one item - the latest item (LastN) of the signature Thumbnail (large) , all identically sized (Gallery, Template and Image) and inserted into a Custom Card on the form. The pen input is on a pop-up and Patched with some metadata into SharePoint and the result is that after signing/drawing, the user (or customer) sees the result immediately on the form. Anyway, keep up the videos - every time I watch one, I learn something new.

Thank you! Great video! Very helpful!

Mi Brother luego de 12 horas rompiendome la cabeza con como convertir en Data Binaria, te encontre... no te abrazo porque hay pandemia... Buena vibra... aun vigente.

Thank you, you save my job.!

Hi. I wanted to share a solution to a question I had that I see often posed here, and eventually worked it out. Regarding the html pdf process - If you are trying to add a changing name from your Powerapps inputs instead of a static name, you need to select 'ask in powerapps' in your flow. Remember you can do this by selecting 'show more' when looking for options - it doesn't automatically show - save your flow once added. If you are editing existing an existing button run command in powerapps copy your HTML Code and paste in a note or word -important as you will otherwise lose it. Go to the flow in powerapps and remove it and re-add it. When you have done so, if you hover over the run command, it shows its expectations - it will have something like 'create content', 'create name' or something similar. You need to put your copied html content and name, separated by a comma in the order identified within the run command brackets. Your HTML quote marks should NOT wrap both commands - only the html command. If you want the name to be dynamic from your powerapp content, you need to enter the relevant powerapps input in the name. Something like this: PDFFloweg.Run(& DataCardValue1.Text & ".html", " your HTML code goes here before ending and closing the run bracket). Remember to follow the order of the run command. Note that I put ".html" at the end of my datacardvalue in the name, You could also add this in the flow in the create file but I found it easy to add here. I hope this helps and saves you and hopefully others the time it took to figure out :-)

Awesome tutorial Shane! You're the best!

EXCELLENT tutorial... quick question though. All is working as it should be... except a second picture. Shows fine in OneDrive, but sharepoint gives me 1 picture then the box with the red x. I'm sure I'm overlooking something small... ideas?

Thanks again Shane! Exactly what I was looking for!!! Love that I can have the signature show up in the body of the email!

Awesome Shane, you are a life saver. I would be interested in the 4 hour class l.

Thank you, Shane. Saved me days of struggle.

Very cool, very useful (as for all your channel). You saved me a lot of time, and maybe a lot of opportunities to give up. Man you rock.

Hi, I used your video to upload images using the out-of-the-box Upload Image button. I found out that if the uploaded image is PNG it works great with mid() with 24 characters. However, if the uploaded image is JPG is must be mid() with 25 characters. The workaround I found was to add an additional step on Flow to substring one additional character if the "Create file" failed (which it does with JPG) and the just "Create file" with the output of the substring step.

GREAT Video!! Thank you for taking the time to figure this out and put together the training video.

Works a treat, thank you so much for this!! Just have one question that I have been struggling with trying to tweak this to suit my needs... Is there a way to get the penInput image to save in to a Sharepoint List item as either an attachment or as a picture field?

Hi Shane, amazing video, can you help me how to collect multiple signatures into document? many thanks

Thank you so much for this video. Just what I needed!!

Shane You are the Best !!!!! If in the same flow i whant to set text input , and add manually the emails ti send and ser the summary with set that input email on sumarry

Fancy way of spelling Jason without an A, that cracked me up :-)). Brb after I watch the whole thing (brb is not just a fancy way of spelling Barb without an A). Edit: Great video, I kind of not like JSON and HTML which makes this video even more helpful!

Hi Shane! Love the video and it's really helped with my app! Just a quick question, I want the user who signed the signature to get the email with the PDF attached - hoping you can help on how to do this? Thanks! Big fan

Shane firstly I would like to thank you for your efforts on these videos, as a novice they have helped me so much. How does one save the image/attachment into sharepoint list and then call that image again on a display form. Thanks so much.

Excellent tutorial!!! Thank you Thank you and THANK YOU!

Brilliant tutorial as always Shane 😃👏🏻 Really good stuff 👍🏻

Hi Shane, please do you have a solution on adding a signature (as image or attachement) to sharepoint list rows with data already. Thanks so much for your awesome Videos.

Hi Shane, got to say I love your videos! You are my go to place as the way you explain things really works for me. So thank you. My question is: would the above work with the Add Picture function? I've tried it as: Set(varUPLOAD, JSON(UploadedImage1.Image, IncludeBinaryData) and it doesn't :/

This is an awesome video! I've tried taking parts from this video and an older one you did where the app had a green back ground. I'm having trouble with one part though. Your suggestion to name the file using the UTCNOW function works like a charm. I was hoping to take this a little further. I've rewatched the older video and this one and tried piecing together how to use an input box in the power app to collect the name of the person your taking a signature from and appending it to the beginning of the name of the file. I can't figure out how to edit the flow to accept the input text from the power app. I tried using the concat function, but i'm not getting anywhere after about 50 different changes to the wording. This is what i have for the powerapp side: Set(varSigName, SigNameInput.Text);Set(varSignature, JSON(SignatureInputPen.Image, JSONFormat.IgnoreBinaryData)); Set(varSignature, Mid(varSignature, 24, Len(varSignature) - 24)); PenInputToHODSharepoint.Run(varSigName, varSignature) This is what i have for the Flow side: File Name: concat(triggerBody()['varSigName'],utcNow(),'.png') I don't get errors in the power app or the flow when saving them respectively, but when i try and execute the powerapp , the flow fails. Any idea on what i'm doing wrong? Is it even possible? I've been successful in creating a static name for the file in FLOW, but not dynamically.

Hey Shane. Is it possible to place an image behind the peninput so that the user can markup the image? Like when you check your hire car for dents.

Great video. I have a question. Is it possible to send this in email without using Power Automate. Basically want to use SendEmail option in Power Apps and want to add a picture to the body of the email.

Very Good !!!

Thanks for videos and classes! I've learned tons! I've created my flow for One Drive and SharePoint. My Flow runs without error and I see my jpg in my One Drive folder but I don't see it in SharePoint list. I'm trying to store a signature and form data in a list so I can populate a Word template. Am I suppose to reference a column somewhere? Does it need to be a picture library? What am I doing wrong?

Excellent

Hi Shane, amazing video. I created a powerapps application using my account, inside the app I used your method for creating the pdf file, it works fine when I run it, then i shared the app with my team and when they run it, it doesn't create the file. The flow runs with no errors but the file is not created in onedrive, I think it's a permission issue, but I don't know how to fix it.

Hi Shane - But how could I allow the Pen input to be inputted along with a tagging number to identify the signature along with the from being submitted. Ex) Form identification number is #1 and therefore signature will be in another folder and I need a column to have #1 in the same signature column. Thanks for the great info!

Hey Shane, thank you for the video! it helped me a lot. Is there a way to generate a link to this signature immediately in powerapp forms so that when a user submits the survey, the link to her signature is already in the SP list? the column for the signature is a single line text and it would be great if there would appear a link to the signature in it by default. Thank you

Unless i'm missing something, the opening statement was that the pin input would be saved to a SharePoint List. I only saw a jpg being saved to a SharePoint Folder. That is not the same thing.

Hi Shane, great video. Do you have a guide for saving signatures to Dataverse?

Thank you ! Or as they say in my country : merci beaucoup Shane !

Hi Shane. Great tutorial as usual. I have one question I hope you have the time to answer. I have a power app created from the columns in a sharepoint list (basic powerapp) and want to include this signature as an attachment (image) when the powerapp submits the other form bits so that the columns populate and the signature image is saved as an attachment for each new item. So in the end use a powerapp to fill in some fields and get a signature and send these all to a list item. I have been a week trying to get it working and seeing as your tutorial is 90% of my solution I thought I would ask. Thanks for any help.

Hi Shane, great video. Hopefully a quick question. When inserting the signature image into the html and hence into a PDF. Can the html also include dynamic data from the form, such as other controls - customer names and such for example.

Hi Shane, great video - thank you! I'm trying to use the pen input app but everything is doubled. I can draw stuff and then when I lift the pen, or stop holding the mouse button, a copy of what I have drawn appears, about an inch to the right of where I drew originally - so it's duplicating it... Every time.... Any idea why this is happening or how I stop it?

Can I use that new JSON format to print the image in an HTML control directly without using flow?

Awesome,

This indeed was very helpful. Thank you so much

This is so awesome, thanks alot Shane! A quick question, is it possible to use the same process but instead insert the image to a Word Template in Power Automate? Would appreciate your insights.

How do you embed the signature into an existing PDF (append to the end)?

Nice work as always Shane

Hi Shane Great Set of video's! It has been a huge help and something I have asked for on Microsofts User Voice site. You are the man! I have one question though... What if you want to upload more than just the filename and the file itself? You get an error using SubmitForm together with your base64Binary function. Is it only possible with the Update File Properties action in PowerAutomate?

hey shane, great video, thank you for share all of your knowledge. i have a little question, ¿powerapps it's only the front end or both, front and back end? and if it's only front end ¿does exist any connector to some back end? all of this questions emerged because i want to build some robust apps for an enterprise enviroment. Regards from Colombia south america

Hi Shane :) thank you for this tutorial it was so helpful! I do have a question - it all works great, but is there a way to set the thumbnail as the pic also? In my pic library, the pen input saves as a file and does not seem to have any preview in SharePoint. If I click the file it automatically downloads rather than showing a preview.

Brilliant, thanks a lot, great video as usual 👌🏻

I am creating an order pickup app using a SharePoint list. Do you know of way to view the signature in a powerapp form with all the other data captured in the list?

Hey Shane, I'm wondering if there's a way to pull the saved drawing back into the pen input to edit. It seems like once they're saved, that's it. But it would be great to be able to edit a drawing after saving it. Just wanted to see if you had any input on this.

I'm trying to save signatures to a Sharepoint document folder, but when creating my flow, I have no option for CreateFile_FileContent. All that shows up is the CreateFile_FileName for the File Content field. Does anyone know a way around this?

Hi Shane, I have a quick question. I want to get the pen input to show in the HTML text control but when i add the flow to the button, the OnSelect shows an error. Is there a way to fix this?

Is there a way to Patch text from the app to a column next to the signature in Sharepoint? For an example their printed name.

Hi Shane, Love your videos and found this one really helpful, so thank you. One question , iss it possible to save the JSON conversion of pen input as a variable and patch to SharePoint list column as text?

Hello Shane I would like to ask you one question. How many device for one user can login to use this power app (1 User name can login 20 device (deviMobile, Tablet, Notebook, PC) ? or we can create a Central Username and allow 20 staffs members to use the App?)

Hi Shane I have share point list in the list I have column like signature how to save signature on that column let me know

Hi Shane, excellent video. How can I use a variable name for the file? Ex. The user logged in the powerapps.

Hi Shane, Great Vid, do you know of a way to get multiple pen inputs into one sharepoint or Sharepoint list, Example i have a Request log list where i need to save the recipients signature and the technician signature onto the same line in the List. Any help would be great

Thanks for sharing shane. :)

Hi Shane, Amy idea if it's possible to save 2 signatures from same button? I have tried 2 flows, but secondary image comes out blank. I suppose I would need to set varJson differently, but can't figure it out

I didn't watch the whole video, but I would like to do is be able to add a signature as well as the rest of the PowerApps Form Data to a Sharepoint List can you help?

I am getting the error "Invalid number of arguments: received 1, expected 0. The code I am using in PowerApps is Set( varJson, JSON( PenInput1.Image, JSONFormat.IncludeBinaryData ) ); Set( varJson, Mid( varJson, 24, Len(varJson) - 24 ) ); PAToSharePoint.Run(varJson) --> Getting Error on this piece

Amazing, thank you so much for this one

Gread Video(know its old), wish you could show how to merge a peninput on top of an image to one image

Hi there. Great video. I have one problem if you can help. It works fine for one drive but if i add the sharepoint save i get a warning on the flow "You may break your Powerapps triggered flow with the changes on the added connections" and my flow stops working. It neither creates OneDrive file nor Sharepoint save.. ? When i delete the sharepoint save action from the flow then the onedrive comes back in operation... Any ideas ? thank you

Hi Shane, how can you save multiple signatures from one form to a Sharepoint list?

Hi Shane is it possible to save pen input to a sharepoint list field. Thank you.

Hi Shane!，Regarding the video of "PowerApps Pen Input to SharePoint", HTML is converted to PDF. You can refer to your operation in apps and Flow. Flow is working normally, but the content of "PenInput1" is not inserted in HTML and PDF. Which step is the operation? Is it incorrect? Hope to get your help, thank you~

Hi Shane, must the users have the access to the Sharepoint list in order for this method to work?

Hi, Having issues following this as Microsoft has now deprecated the PowerApps option and replaced it with PowerApps v2 - which requires inputs etc. Any idea how I can get this to work with the new PowerApps connector in Power Automate?

Hi Shane, thank you for this video it has been helpful for attaching signatures to PDF I have tried to create a collection where you can collect signatures and display them in a table format at the bottom of a HTML text but have had no success, have you covered this in a video before or is that something you might be able to talk us through

Would it be possible to save in a sharepoint list, with the other fields of the form?

HI: This seems to solved an issue in a fancy way that's been around for sooo long. :-) But I have try it, and I get stuck on minute 18:06 When entering the formula of JSON in html code I get this error (sry, translate from Spanish): "There is a function of behaivior in a property that it is not a behavior. You cannot used this property for changing values in another part of the application." Does this make any sense to you? Do you know what the issue can be? Thanks in advance.

Thank you So Much , i have question Sir , i finsished from save pen input image to document list but this signature i need to appear in column in Eform approval Request ? please i need help how i can add this signature in Costume list column ?

when i put this (base64ToBinary(triggerBody()['Createfile_FileContent']) in the file content i get this messagem, how i fixe that ???? message(Unable to process template language expressions in action 'Create_file' inputs at line '1' and column '7537': 'The template language function 'base64ToBinary' was invoked with a parameter that is not valid. The value cannot be decoded from base64 representation.'.) thanks

Is it possible to pass additional information to the PowerApp Workflow so that the signature could be identified with a record in a SharePoint list?

Thanks! Created a pdf generator app with embedded image by following through your video. Just a question, is there any way to resize the image after JSON function?

When trying to save to a Sharepoint Library, I get "InvalidTemplate" and "The value cannot be decoded from base64 representation". I've watched the video very carefully a few times. Pretty sure I have everything setup correctly.

How can you have the file name change for each time you save it to the sharepoint folder?

i followed your advise at concat(utcNow(),'.jpg) and also base64ToBinary(triggerBody()['Createfile_FileContent']) but the images still remains with an error. even with restarting powerapps. anyone having the same issues?

Hey, I'm trying to get a signature to be added into a word document template. The word doc has text inputs and an image input and I'm having a hard time trying to pass the signature image from the sharepoint list into the word doc (using a flow). So far I'm using the convert step that says "{ "$content-type": "image/png", "$content": @{base64(triggerOutputs()?['body/Signature'])} }" and then passing it into a Populate Word step. So far it succeeds, but the image in the file created says "image cannot be displayed". Do you know what I have to do in the flow for it to pass?

I already have an image, how can I use that image as a base and use pen input to mark something on that image. If you can please revert if you have any thoughts on it

Thank you for this, Can you please help me with reducing the resolution (height/width) property of the peninput to PDF? Does not seem possible to adjust the size of the Base64 content transfered to Sharepoint.

Cool, thx

Shane, Big Fan of your videos thanks a lot for publishing them..... How Can I add multiple images from a Collection to a PDF file (obviously via HTML) what would be the identifier of each image?. I'm building an app on which a field meeting is recorded and multiple people sign on the app, I want to be able to send a PDF with the recollection of all the signatures... Thanks in advance

This is a great in-depth video! I did run into an problem, when saving the Pen Drawing to PDF the button code throws an error, not liking the HTML. Do you have an suggestions?

thanks alot for the video, where is your intro? it was cool and i loved the music in it

thanks a lot ! :)

Hello. When creating the file at Sharepoint Document Library through flows, I want to give it a name from the PowerApp label instead of utcnow(). Is there any possibility of that? Thanks!

Shane, this is gold! Thanks heaps for spending your time on putting these together! Your blood is worth bottling... I've got a quick one to ask, please: I'm getting an error: "Invalid number of arguments: received 1, expected 5." Set( varJson, JSON( PenInput1.Image, JSONFormat.IncludeBinaryData ) ); Set( varJson, Mid( varJson, 24, Len(varJson) -24 ) ); PAPenInputToOD.Run(varJson) - this line is highlighted as an error. Where did 5 come from? What is wrong?... save a life, I am literally about to jump off the balcony... Thanks in advance... and thanks again for great tutes

I cannot save to sharepoint not sure what is the problem ? InvalidTemplate. Unable to process template language expressions in action 'Create_file_2' inputs at line '1' and column '2173': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_sharepointonline']['connectionId']' cannot be evaluated because property 'shared_sharepointonline' doesn't exist, available properties are 'shared_onedriveforbusiness'. Please see aka.ms/logicexpressions for usage details.'.

Hmm - after I add a signature to a SharePoint list based form, I would want the signature to appear in the signature box if I had saved one previously.

good one- You kicked demons out of that code When saving how can I "add a text input" to New Columns please which helps to filter images in to a galley? i get empty value