In this video, you will learn how to save PowerApps Pen Input to SharePoint, OneDrive, PDF, and Email. Using a combination of the JSON Function and Microsoft Flow. Link to PowerApps Training www.PowerApps9...
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!
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?
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.
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.
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 :-)
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?
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.
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?
@@mudandmire wanna ask if you solved penInput to sharepoint list as an attachment? im also trying to do this, i just dont know how to do this on power automate :D
Any updates on this need? I am doing the same and having the same issue. I want to have the pen input inline as a datacard in my form so that the user can fill out the form and sign it and the form saves to SharePoint List with the attachment of the signature.
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.
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.
Evidently there is a difference in how a picture control and the pen control send info from powerapps to flow. I changed my flow to ask for the name of the file to come from powerapps, then in powerapps i changed the order of how the content of the pen input image and then the name of the file. This was the fix. This was what worked in the end for me: Set(varSignature, JSON(SignatureInputPen.Image, JSONFormat.IgnoreBinaryData)); Set(varSignature, Mid(varSignature, 24, Len(varSignature) - 24)); PenInputToHODSharepoint.Run(varSignature, SigNameInput.Text & ".png") Wish i had thought to change the order sooner. But i will say your advice on "peeking" at the code helped me decide to try it. Thanks for all of your helpful videos and advice Shane.
@@ShanesCows Tried that Method and just got an error pn the Last Line. Any advise? Set( varJson, JSON( PenInput1.Image, JSONFormat.IncludeBinaryData ) ); Set( varJson, Mid( varJson, 24, Len(varJson)-24 ) ); PIToOneDrive.Run(varJson, Job_No.Text &".JPG")
Yes it is Kevin. I was about to say I didn't remember where I showed it but I think I did it in this video. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bsJAG9dJlcc.html 😎
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.
@@ShanesCows in your example it sends everything as an attachment. Was trying have it sent in the body of the email using Power Apps. I can get it to send just using Power Apps but it sends as an attachment. Want it in the body instead.
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?
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.
What were you expecting different? The pen input creates an image output and we saved that image to SharePoint. If you want it somewhere else then you could use Flow to move it.
@@ShanesCows This is a great video and I learned so much and have learned so much from all your videos. I'm just saying that you stated that you would show us how to actually save the binary data to an actual SharePoint list. You showed us how to save the image file to a folder. That's all. I will say this, using several of your videos I have the signature process working fully and you are my go to for any issues I have. Thanks
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.
Try storing the signature as base64 in multi line text field. Can’t use it in SharePoint but you can in Power Apps. I have a video on the works that shows this.
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?
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.
Yes, you would need the base64 from the Pen Input inside of an IMG tag. This video might help? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bIne3DD3HAg.html
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.
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?
@@ShanesCows I want to add other information to the row with the signature. Like a text input or a label. I know how to Patch text to a Sharepoint List but the signatures are in a Document Library. Does this require a flow of just a different Patch format?
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, 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
@@ShanesCows Thankyou for your advice, however this video didn't quiet answer my query unfortunately, I see that your video is a way of displaying the signature back in the app, what I want to do is display multiple signatures into the same SharePoint list, I.E Technician and customer signature, so we have accountability. I've successfully managed to get one signature onto SharePoint using MS Flow, to store into a library then do a hyperlink to said library but this only links one and doesn't link the rest of the information even if i do a collection and patch, thats because i have two differnt services patching the information to the sharepoint list, first been powerapps itself and the second been Flow, is there a way to patch all the information aswell as two signature boxes to a sharepoint list that we can refer back to later.
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 had trouble with this. It wouldn't run if I was trying to send more than one Pen Input to the HTML to PDF. I found though that by adding an Image control (which I later set the visible property to false) to the same screen as the pen input, I could then view the pen input in the image control and reference the image in my HTML instead of the second pen input. for some reason it really didn't like more than one pen input but this was an easy work around.
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
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
Yes. Save the base64 encoding as a string. The concept is in this video Power Apps Convert Image to Base64 for Emails, PDFs and Components ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bIne3DD3HAg.html
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, 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?
Use the v2 connector and then add a Text Input. Then it will behave the same. I will get a video out next week explaining this. Sorry they changed things :(
@@ShanesCows hi, thanks for the reply. How does the text field option work? Sorry, still a bit of a newbie to this. Would the first box be the name of the Sharepoint list column or can I just leave it default? Thanks again in advance. Paul
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
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
@@ShanesCows Hello good Morning Thank you for your quick answer but yes i have one ("Ask in Power Apps" for CreateFile_FileContent.) when i just put the ask power apps file and created, but broken. and when I use the code taught I get this message that you saw above
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.
Randy you can create a new comment with your formula and I can spot check it for you. This technique still works as shown so you must have something out of sort. Or if you sign up here (there is a cost) you can download the working app. 😀 training.powerapps911.com/courses/video-library
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.
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
@@ShanesCows Can this be done from a collection or does it need to from an external source (i.e. SharePoint)? I am having the same issue making training records.
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?
After extensive testing, I figured out what the problem was. I was copying and pasting the whole formula and PowerApps didn't like that, I had to manually type the formula you had in order for PowerApps to recognize everything.
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
The 5 means you did Ask in PowerApps 5 times inside of your flow. So Power Apps has to send 5 things. If you didn't mean to do that then might be easiest to rebuild the flow.
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