PowerApps Pen Input to SharePoint

[@apoorvamohan8988]

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.

[@ShanesCows]

Glad to help. 😀

[@vmarr0y0]

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

[@ShanesCows]

Cool

[@basstubamatt]

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!

[@ShanesCows]

Glad you got it. This video talks about another thought here if it helps you at all. kzbin.info/www/bejne/mHrRlmZ6eZh7d8k

[@derek_shannon]

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!

[@ShanesCows]

Me too. Make sure you leave a new comment to report back. I don’t want to miss it. 😀

[@titopeej_6911]

Awesome tutorial Shane! You're the best!

[@ShanesCows]

Thanks 🙏

[@jwr915]

Thank you, Shane. Saved me days of struggle.

[@michelesarsitis233]

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

[@ShanesCows]

Awesome! 😀

[@practicalpowerapps]

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.

[@ShanesCows]

Thanks for sharing Warren. 😀

[@louismartini6983]

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.

[@ShanesCows]

You are welcome Louis 😻

[@kevinbriz17]

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.

[@ShanesCows]

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. kzbin.info/www/bejne/mKStcnpvma-fmcU 😎

[@kevinbriz17]

@@ShanesCows How did i miss that video! Cheers Shane, you continue to make me look very good at my job. 😎

[@wizardmhc]

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.

[@ShanesCows]

Encantado de ayudar

[@dannielleszuba5699]

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

[@ShanesCows]

It will launch on Monday. I will drop you a link or you can email me. Shane at PowerApps911.com

[@walterwego1396]

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 :-)

[@ShanesCows]

Thanks for sharing Walter 🐶

[@amycarl9165]

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?

[@ShanesCows]

I thinkyou would need to add steps in the flow to move from it from OneDrive to the SharePoint list? I assume as an attachment.

[@mudandmire]

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?

[@ShanesCows]

I did a video on saving files to SharePoint. I think if you move the pen input to an image control it should work.

[@mudandmire]

@@ShanesCows thanks Shane, I'll give that a try and let you know how I get on.

[@akdmkz9926]

@@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

[@mudandmire]

@@akdmkz9926 Not yet sadly, still having some issues. I will be trying some other work arounds for this soon.

[@InnovationUSVolvo]

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.

[@robertgoffard2470]

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

[@ShanesCows]

Glad to help Robert🤓

[@robertgoffard2470]

Question, the SharePoint drops the @base64ToBinary(triggerBody() and reverts back to the regular Binary format. Any suggestions ?

[@hudongwang7550]

Thank you, you save my job.!

[@ShanesCows]

Awesome :)

[@bobbigordon8678]

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?

[@ShanesCows]

I don’t have any guesses too of my head. Sorry

[@galinagolant]

Thank you! Great video! Very helpful!

[@ShanesCows]

Happy to help 😎😎

[@benjaminlahsen6721]

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

[@ShanesCows]

THe HTML control in Power Apps doesn't show images :(

[@benjaminlahsen6721]

@@ShanesCows owww thank you for your answer. You are the best !

[@patricknassar3790]

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!

[@ShanesCows]

Look at my video on repeating tables like infopath for an example of the master and child relationship

[@BeckyGribble]

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?

[@ShanesCows]

I haven’t seen that before. Sorry sounds like a bug with your device

[@ArkysisGaming]

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.

[@leokearns1221]

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.

[@ShanesCows]

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.

[@leokearns1221]

@@ShanesCows cool. Cheers Shane.

[@Addietoons]

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

[@ShanesCows]

Glad to help Laura!

[@timwiles440]

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.

[@ShanesCows]

Yes. kzbin.info/www/bejne/b5WWg2Zpa95goJo

[@FurnBirds]

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

[@juggaberglund]

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

[@ShanesCows]

Thanks 😻

[@kristenpetillon5671]

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.

[@ShanesCows]

Glad to help. 😀 🐶

[@thonhernhor1265]

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

[@ShanesCows]

Yes

[@scottclaxton8714]

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]

Scott this video has you covered. kzbin.info/www/bejne/foW8aXSkgt9oqNk

[@scottclaxton8714]

@@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.

[@FBCUKINTERNALCOMMS]

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.

[@ShanesCows]

I am not sure. I haven't tried that scenario. I would guess yes but nothing I can point you to.

[@wichudatriphatthananun2236]

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?)

[@ShanesCows]

Shared logins are not allowed according to the license

[@markmclean154]

Nice work as always Shane

[@ShanesCows]

Thanks you were my inspiration 😀

[@louismartini6983]

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?

[@ShanesCows]

If you are saving it as an image an image control should work

[@IndyBansal94]

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

[@stanislavshestakov7685]

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

[@ShanesCows]

The Flow can return the file url so yes you would have it.

[@briananderson4911]

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.

[@ShanesCows]

I don’t follow exactly what you are trying but I am pretty sure Yes. You could also have the flow Update Item to save the value.

[@briananderson4911]

​@@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?

[@AdiCristea]

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!

[@ShanesCows]

Glad you enjoyed it. 😀

[@jaysenprocter]

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.

[@ShanesCows]

No real way to save it as an attachment. You could have flow move it after the fact possibly.

[@jaysenprocter]

@@ShanesCows Many thanks for the reply, I will keep on searching for solutions. Again many thanks for providing these videos to the community.

[@seantambling]

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.

[@seantambling]

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]

Glad you got it.

[@deryckgaffney3294]

@@seantambling Hi. Excelent Vidioe Shane. Just what I was looking for, I couldn't get that to work

[@deryckgaffney3294]

@@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")

[@rishiparikh4156]

@@deryckgaffney3294 Hi Deryck. It didn't work for me too. Any update?

[@anthonyanyoti]

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.

[@ShanesCows]

Probably but I haven’t tried. Sorry

[@VANDIK01]

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

[@mtamitolanga]

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

[@ShanesCows]

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 kzbin.info/www/bejne/mHrRlmZ6eZh7d8k

[@HansMorano]

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

[@ShanesCows]

I don't, I haven't done that before but there is an Image column type so hopefully it isn't too hard.

[@HansMorano]

@@ShanesCows Thank you for your swift response. I’ll give it a go. Also, thanks for the great content.

[@silvinhalalin]

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

[@ShanesCows]

Yes, if you saved the Base64 encoding of the file. I show it here kzbin.info/www/bejne/foW8aXSkgt9oqNk

[@silvinhalalin]

@@ShanesCows thanks!!

[@myatix1]

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?

[@ShanesCows]

I have done this before. I send all of the info to Flow and let it do the file and the update the data

[@nepe1024]

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

[@ShanesCows]

PowerApps has 260+ connector to talk to robust back ends like SQL or CDS

[@luisaugustomeyer2038]

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

[@rebeccaj138]

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]

Yes. I thought the email button did just that? If not leave a new comment and I will try to find another example.

[@rebeccaj138]

@@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.

[@ShanesCows]

Ugh. I thought I did that. Boo me. So the same html you send to Flow will work as the body of the email. No changes required.

[@rebeccaj138]

@@ShanesCows thank you will try that out.

[@milesb7243]

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

[@ShanesCows]

As long as you don’t reset the variable you should be able to use it as much as you want

[@walterwego1396]

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.

[@zxyong83]

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?

[@ShanesCows]

Html img tag you can set height and width

[@Gabriellipe77]

@@ShanesCows it doesn't work to me :( any ideia? My tag: where varsize: Set(varsize;1000) Thank you in advance!

[@miprofetic]

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?

[@ShanesCows]

You have an issue with your base64 or img tag. Look at the html file and see if you can spot the issie

[@Dattics]

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.

[@ShanesCows]

Interesting I haven’t ran into that. Thanks for sharing

[@ChekwubeRemigiusOnyekaba]

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.

[@ShanesCows]

This video should help kzbin.info/www/bejne/gWiXhnmPnNd-eJY

[@isabelescarlette2021]

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

[@ShanesCows]

Creat multiple inputs and the duplicate this process

[@isabelescarlette2021]

@@ShanesCows Thank you very much!

[@kevinhardy8179]

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 :/

[@ShanesCows]

I would think so but I haven’t tried. Maybe set the add media xo trip through an image control?

[@Twyfie1]

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?

[@ShanesCows]

Yep. Just like you said it would work that way exactly. We do it in a few customer apps. 😀

[@geauxvols]

@@ShanesCows Would you store the JSON data with the Base64 prefix stripped off, or leave it as it is? Or does it even matter?

[@DijonLR]

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]

Not sure if the html control can show it or not. I would try referencing the signature directly from the output of the control. Might be easier.

[@stamatismalissovas713]

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

[@Patrick-iu1qj]

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

[@ShanesCows]

Yes, you would need the base64 from the Pen Input inside of an IMG tag. This video might help? kzbin.info/www/bejne/mHrRlmZ6eZh7d8k

[@alhussanschools4874]

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 ?

[@ShanesCows]

I have never done that. Sorry

[@woz8855]

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

[@pcowburn2409]

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?

[@ShanesCows]

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 :(

[@pcowburn2409]

@@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

[@newpost656]

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?

[@ShanesCows]

Post a new comment with the formula that is causing the error and I can try to help.

[@newpost656]

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.

[@elieabidaher35]

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.

[@ShanesCows]

Do they have OneDrive? It creates the file in the users OneDrive

[@KenWarthen]

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?

[@ShanesCows]

Sure. Send the ID or link to the item

[@KenWarthen]

@@ShanesCows How do you capture the ID or Link in the Flow?

[@markylon]

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?

[@bavajidoriginti2016]

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

[@ShanesCows]

Sorry I don't follow

[@jean-philippedelaune2607]

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

[@ShanesCows]

😎👍

[@imranpearl]

This indeed was very helpful. Thank you so much

[@ShanesCows]

You are welcome

[@lyndonmalan764]

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.

[@ShanesCows]

What if you set the height width of the img tag In the html?

[@lyndonmalan764]

@@ShanesCows Thanks Shane, I did exactly that. Used base64 content in the img tag and used height width to adjust. battled with the "quotes" though!

[@tenisviejos]

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

[@ShanesCows]

Happy to help

[@mutang6825]

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~

[@ShanesCows]

Not sure. You will need to look at the flow and see if it gettting no data or the wrong data and then troubleshoot more from there.

[@adeoneliberiofilho7427]

Very Good !!!

[@ShanesCows]

Thank you! Cheers!

[@lankeastor512]

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?

[@ShanesCows]

Click in the File Content field in Flow and then select Ask in Power Apps again to create a new input. You may have to click More to get it to show.

[@rishiparikh4156]

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!

[@ShanesCows]

Ask in Power Apps for the filename

[@AnkitShah55]

Excellent

[@ShanesCows]

Thanks 🙏

[@krazykalebhawkins895]

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

[@HoldenStallsmith]

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?

[@HoldenStallsmith]

Compose step, not convert!

[@imranpearl]

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

[@ShanesCows]

You cannot edit the image with pen input but you can put the pen input over top the image and then just show the two images on top of each other.

[@apctools4460]

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]

That tells me you don't have an "Ask in Power Apps" for CreateFile_FileContent.

[@apctools4460]

@@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

[@lindsayconstructionentlimi8666]

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

[@ShanesCows]

You could use the GUID() or Now() function to get unique string and then add it to the file name?

[@MsRameshbhati]

Thanks for sharing shane. :)

[@ShanesCows]

Glad to help. 😀

[@ramisolipe7001]

Awesome,

[@ShanesCows]

Thank you! Cheers!

[@flightmode7655]

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?

[@TheLecxto]

Great video!!, how can I make the html file named after the motion id? I would really appreciate your help

[@ShanesCows]

In your flow set the file name to Ask in Power Apps and then pass the name you want. 😀

[@TheLecxto]

@@ShanesCows Thanks Shane, if I keep the concatenation, what would the expression be? Remembering that I have to keep the. HTML The expression is for me to put the consecutive ID of the item

[@davidakridge2831]

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.

[@ShanesCows]

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.

[@davidakridge2831]

@@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

[@blutkraehe_official]

hi, how do i store a signature in a share point list in the attachment column ?

[@ShanesCows]

You cannot directly. Have to use Flow to move it there.

[@blutkraehe_official]

@@ShanesCows and how?.

[@solageormeich]

How to add the image as a column in a sharepoint list

[@Daviirose3]

is there a way to instert that image into a pdf file with an image field?

[@ShanesCows]

Yes. YOu need the base64 of the image. In this video I show how to get it from a OneDrive file kzbin.info/www/bejne/aKPJcoSbZtB-bq8 or this video kzbin.info/www/bejne/aYLEmoBuiMqKnK8 shows how to get it for a file you attach.

[@Daviirose3]

Shane Young so I did what you did and spreed the image in sharepoint. My next step was to get that image which I did in the flow and put inside a pdf file using plumsail. When I do it in plumsail I have to put it in as json data which is just the field name typical of its a string but it’s.not really showing it or it just gives me an error

[@InnovationUSVolvo]

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

[@ShanesCows]

Check your flow. You dont have an ask in PowerApps dynamic content.

[@cholopa]

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.

[@cholopa]

Ok, the issue was that I was tring to see the image in a html control inside powerapps...

[@ShanesCows]

Yup. 😀 Glad you got it.

[@danielherrera3973]

Amazing, thank you so much for this one

[@ShanesCows]

Glad to help. 😀

[@luchoacecas]

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]

I do a lot of this. It shouldn’t be any different. You create the html in the app so you can control what image goes where

[@deannalegare7857]

@@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.

[@rch24231]

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.

[@ShanesCows]

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

[@rch24231]

@@ShanesCows Thank you Shane. I just signed up.

[@inside-best161]

I copied the list attachment control and pasted it to my screen to upload document to library but in file content I only get the appres://blobmanager..., also it does not convert to base64 by using the JSON command.

[@ShanesCows]

You skipped the step of passing it through an image control

[@inside-best161]

@@ShanesCows thanks Shane, u r right, i missed this step...

[@ERPCoder]

Cool, thx

[@ShanesCows]

You're welcome!

[@eduardocepeda6051]

What if I have to submit multiple signatures?

[@ShanesCows]

Same concept. You would either want to have multilpe pen inputs or you could save each signatures base64 into a collection and then push the collection up. I have done both for customers.

[@eduardocepeda6051]

@@ShanesCows I have like 8 or 10 pen inputs I've one variable for each But If I want to insert them into a word doc then will be converted later to PDF How could I retrieve this images? To be inserted in the word document

[@CINsyg]

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