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.PowerApps911.com/training
Пікірлер: 279
@apoorvamohan89884 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Glad to help. 😀
@basstubamatt3 жыл бұрын
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!
@ShanesCows3 жыл бұрын
Glad you got it. This video talks about another thought here if it helps you at all. kzfaq.info/get/bejne/mK-emJZ1qZmscZs.html
@vmarr0y04 жыл бұрын
I haven’t watched it in full yet, but am bookmarking and liking in advance. Thanks!!!!
@ShanesCows4 жыл бұрын
Cool
@derek_shannon4 жыл бұрын
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!
@ShanesCows4 жыл бұрын
Me too. Make sure you leave a new comment to report back. I don’t want to miss it. 😀
@louismartini69834 жыл бұрын
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.
@ShanesCows4 жыл бұрын
You are welcome Louis 😻
@michelesarsitis2333 жыл бұрын
Thanks again Shane! Exactly what I was looking for!!! Love that I can have the signature show up in the body of the email!
@ShanesCows3 жыл бұрын
Awesome! 😀
@dannielleszuba56994 жыл бұрын
Awesome Shane, you are a life saver. I would be interested in the 4 hour class l.
@ShanesCows4 жыл бұрын
It will launch on Monday. I will drop you a link or you can email me. Shane at PowerApps911.com
@titopeej_69114 жыл бұрын
Awesome tutorial Shane! You're the best!
@ShanesCows4 жыл бұрын
Thanks 🙏
@robertgoffard24704 жыл бұрын
GREAT Video!! Thank you for taking the time to figure this out and put together the training video.
@ShanesCows4 жыл бұрын
Glad to help Robert🤓
@robertgoffard24704 жыл бұрын
Question, the SharePoint drops the @base64ToBinary(triggerBody() and reverts back to the regular Binary format. Any suggestions ?
@practicalpowerapps4 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Thanks for sharing Warren. 😀
@juggaberglund4 жыл бұрын
Brilliant tutorial as always Shane 😃👏🏻 Really good stuff 👍🏻
@ShanesCows4 жыл бұрын
Thanks 😻
@jwr9152 жыл бұрын
Thank you, Shane. Saved me days of struggle.
@ArkysisGaming2 жыл бұрын
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.
@kristenpetillon56713 жыл бұрын
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.
@ShanesCows3 жыл бұрын
Glad to help. 😀 🐶
@FurnBirds2 жыл бұрын
Excellent tutorial!!! Thank you Thank you and THANK YOU!
@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
@krazykalebhawkins8953 жыл бұрын
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
@Addietoons3 жыл бұрын
Thank you so much for this video. Just what I needed!!
@ShanesCows3 жыл бұрын
Glad to help Laura!
@jean-philippedelaune26074 жыл бұрын
Thank you ! Or as they say in my country : merci beaucoup Shane !
@ShanesCows4 жыл бұрын
😎👍
@IndyBansal946 ай бұрын
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
@galinagolant Жыл бұрын
Thank you! Great video! Very helpful!
@ShanesCows Жыл бұрын
Happy to help 😎😎
@wizardmhc3 жыл бұрын
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.
@ShanesCows3 жыл бұрын
Encantado de ayudar
@kevinhardy81794 жыл бұрын
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 :/
@ShanesCows4 жыл бұрын
I would think so but I haven’t tried. Maybe set the add media xo trip through an image control?
@anthonyanyoti4 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Probably but I haven’t tried. Sorry
@amycarl91653 жыл бұрын
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?
@ShanesCows3 жыл бұрын
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.
@imranpearl4 жыл бұрын
This indeed was very helpful. Thank you so much
@ShanesCows4 жыл бұрын
You are welcome
@timwiles4404 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Yes. kzfaq.info/get/bejne/b8pjhZZkm9-Rmmw.html
@hudongwang75502 жыл бұрын
Thank you, you save my job.!
@ShanesCows2 жыл бұрын
Awesome :)
@burtonsbiscuits45743 жыл бұрын
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.
@ShanesCows3 жыл бұрын
I am not sure. I haven't tried that scenario. I would guess yes but nothing I can point you to.
@danielherrera39734 жыл бұрын
Amazing, thank you so much for this one
@ShanesCows4 жыл бұрын
Glad to help. 😀
@seantambling4 жыл бұрын
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.
@seantambling4 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Glad you got it.
@deryckgaffney32944 жыл бұрын
@@seantambling Hi. Excelent Vidioe Shane. Just what I was looking for, I couldn't get that to work
@deryckgaffney32944 жыл бұрын
@@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")
@rishiparikh41564 жыл бұрын
@@deryckgaffney3294 Hi Deryck. It didn't work for me too. Any update?
@myatix14 жыл бұрын
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?
@ShanesCows4 жыл бұрын
I have done this before. I send all of the info to Flow and let it do the file and the update the data
@jaysenprocter4 жыл бұрын
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.
@ShanesCows4 жыл бұрын
No real way to save it as an attachment. You could have flow move it after the fact possibly.
@jaysenprocter4 жыл бұрын
@@ShanesCows Many thanks for the reply, I will keep on searching for solutions. Again many thanks for providing these videos to the community.
@tenisviejos4 жыл бұрын
Brilliant, thanks a lot, great video as usual 👌🏻
@ShanesCows4 жыл бұрын
Happy to help
@Dattics4 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Interesting I haven’t ran into that. Thanks for sharing
@tuffley21754 жыл бұрын
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
@AdiCristea4 жыл бұрын
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!
@ShanesCows4 жыл бұрын
Glad you enjoyed it. 😀
@stanislavshestakov76854 жыл бұрын
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
@ShanesCows4 жыл бұрын
The Flow can return the file url so yes you would have it.
@kevinbriz172 жыл бұрын
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.
@ShanesCows2 жыл бұрын
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. kzfaq.info/get/bejne/mNl6dKpqybDQk5c.html 😎
@kevinbriz172 жыл бұрын
@@ShanesCows How did i miss that video! Cheers Shane, you continue to make me look very good at my job. 😎
@miprofetic3 жыл бұрын
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?
@ShanesCows3 жыл бұрын
You have an issue with your base64 or img tag. Look at the html file and see if you can spot the issie
@patricknassar37904 жыл бұрын
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!
@ShanesCows4 жыл бұрын
Look at my video on repeating tables like infopath for an example of the master and child relationship
@nepe10244 жыл бұрын
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
@ShanesCows4 жыл бұрын
PowerApps has 260+ connector to talk to robust back ends like SQL or CDS
@Twyfie13 жыл бұрын
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?
@ShanesCows3 жыл бұрын
Yep. Just like you said it would work that way exactly. We do it in a few customer apps. 😀
@geauxvols3 жыл бұрын
@@ShanesCows Would you store the JSON data with the Base64 prefix stripped off, or leave it as it is? Or does it even matter?
@mudandmire4 жыл бұрын
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?
@ShanesCows4 жыл бұрын
I did a video on saving files to SharePoint. I think if you move the pen input to an image control it should work.
@mudandmire4 жыл бұрын
@@ShanesCows thanks Shane, I'll give that a try and let you know how I get on.
@akdmkz99264 жыл бұрын
@@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
@mudandmire4 жыл бұрын
@@akdmkz9926 Not yet sadly, still having some issues. I will be trying some other work arounds for this soon.
@InnovationUSVolvo4 жыл бұрын
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.
@elieabidaher354 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Do they have OneDrive? It creates the file in the users OneDrive
@leokearns12213 жыл бұрын
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.
@ShanesCows3 жыл бұрын
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.
@leokearns12213 жыл бұрын
@@ShanesCows cool. Cheers Shane.
@flightmode76552 жыл бұрын
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?
@louismartini69834 жыл бұрын
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?
@ShanesCows4 жыл бұрын
If you are saving it as an image an image control should work
@imranpearl4 жыл бұрын
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
@ShanesCows4 жыл бұрын
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.
@VANDIK012 жыл бұрын
Hi Shane, amazing video, can you help me how to collect multiple signatures into document? many thanks
@bobbigordon86783 жыл бұрын
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?
@ShanesCows3 жыл бұрын
I don’t have any guesses too of my head. Sorry
@zxyong834 жыл бұрын
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?
@ShanesCows4 жыл бұрын
Html img tag you can set height and width
@Gabriellipe773 жыл бұрын
@@ShanesCows it doesn't work to me :( any ideia? My tag: where varsize: Set(varsize;1000) Thank you in advance!
@alhussanschools48744 жыл бұрын
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 ?
@ShanesCows4 жыл бұрын
I have never done that. Sorry
@markylon2 жыл бұрын
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?
@markmclean1544 жыл бұрын
Nice work as always Shane
@ShanesCows4 жыл бұрын
Thanks you were my inspiration 😀
@lyndonmalan7644 жыл бұрын
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.
@ShanesCows4 жыл бұрын
What if you set the height width of the img tag In the html?
@lyndonmalan7644 жыл бұрын
@@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!
@wichudatriphatthananun22364 жыл бұрын
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?)
@ShanesCows4 жыл бұрын
Shared logins are not allowed according to the license
@stamatismalissovas7132 жыл бұрын
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
@luisaugustomeyer2038 Жыл бұрын
Hi Shane, excellent video. How can I use a variable name for the file? Ex. The user logged in the powerapps.
@user-hf5jr3lp5f Жыл бұрын
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?
@user-hf5jr3lp5f Жыл бұрын
Compose step, not convert!
@DijonLR4 жыл бұрын
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?
@ShanesCows4 жыл бұрын
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.
@milesb72434 жыл бұрын
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
@ShanesCows4 жыл бұрын
As long as you don’t reset the variable you should be able to use it as much as you want
@walterwego13963 жыл бұрын
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.
@lankeastor5123 жыл бұрын
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?
@ShanesCows3 жыл бұрын
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.
@thonhernhor12654 жыл бұрын
Hi Shane, must the users have the access to the Sharepoint list in order for this method to work?
@ShanesCows4 жыл бұрын
Yes
@briananderson49113 жыл бұрын
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.
@ShanesCows3 жыл бұрын
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.
@briananderson49113 жыл бұрын
@@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?
@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 !
@Warbots9834 жыл бұрын
thanks alot for the video, where is your intro? it was cool and i loved the music in it
@ShanesCows4 жыл бұрын
Did I forget the intro? Ugh me.
@MsRameshbhati4 жыл бұрын
Thanks for sharing shane. :)
@ShanesCows4 жыл бұрын
Glad to help. 😀
@bavajidoriginti20163 жыл бұрын
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
@ShanesCows3 жыл бұрын
Sorry I don't follow
@KenWarthen4 жыл бұрын
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?
@ShanesCows4 жыл бұрын
Sure. Send the ID or link to the item
@KenWarthen4 жыл бұрын
@@ShanesCows How do you capture the ID or Link in the Flow?
@ChekwubeRemigiusOnyekaba7 ай бұрын
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.
@ShanesCows7 ай бұрын
This video should help kzfaq.info/get/bejne/gZ1kiKmKzNivcmg.html
@walterwego13963 жыл бұрын
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 :-)
@ShanesCows3 жыл бұрын
Thanks for sharing Walter 🐶
@rishiparikh41564 жыл бұрын
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!
@ShanesCows4 жыл бұрын
Ask in Power Apps for the filename
@HansMorano2 жыл бұрын
Hi Shane, great video. Do you have a guide for saving signatures to Dataverse?
@ShanesCows2 жыл бұрын
I don't, I haven't done that before but there is an Image column type so hopefully it isn't too hard.
@HansMorano2 жыл бұрын
@@ShanesCows Thank you for your swift response. I’ll give it a go. Also, thanks for the great content.
@mtamitolanga3 жыл бұрын
Hi Shane is it possible to save pen input to a sharepoint list field. Thank you.
@ShanesCows3 жыл бұрын
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 kzfaq.info/get/bejne/mK-emJZ1qZmscZs.html
@newpost6564 жыл бұрын
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?
@ShanesCows4 жыл бұрын
Post a new comment with the formula that is causing the error and I can try to help.
@newpost6564 жыл бұрын
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.
@cholopa4 жыл бұрын
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.
@cholopa4 жыл бұрын
Ok, the issue was that I was tring to see the image in a html control inside powerapps...
@ShanesCows4 жыл бұрын
Yup. 😀 Glad you got it.
@Patrick-iu1qj4 ай бұрын
How do you embed the signature into an existing PDF (append to the end)?
@ShanesCows4 ай бұрын
Yes, you would need the base64 from the Pen Input inside of an IMG tag. This video might help? kzfaq.info/get/bejne/mK-emJZ1qZmscZs.html
@pcowburn24099 ай бұрын
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?
@ShanesCows9 ай бұрын
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 :(
@pcowburn24099 ай бұрын
@@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
@lindsayconstructionentlimi86664 жыл бұрын
How can you have the file name change for each time you save it to the sharepoint folder?
@ShanesCows4 жыл бұрын
You could use the GUID() or Now() function to get unique string and then add it to the file name?
@silvinhalalin2 жыл бұрын
Would it be possible to save in a sharepoint list, with the other fields of the form?
@ShanesCows2 жыл бұрын
Yes, if you saved the Base64 encoding of the file. I show it here kzfaq.info/get/bejne/frqJa6SfsuCZoqs.html
@silvinhalalin2 жыл бұрын
@@ShanesCows thanks!!
@apctools44603 жыл бұрын
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
@ShanesCows3 жыл бұрын
That tells me you don't have an "Ask in Power Apps" for CreateFile_FileContent.
@apctools44603 жыл бұрын
@@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
@InnovationUSVolvo4 жыл бұрын
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
@ShanesCows4 жыл бұрын
Check your flow. You dont have an ask in PowerApps dynamic content.
@isabelescarlette20213 жыл бұрын
Hi Shane, how can you save multiple signatures from one form to a Sharepoint list?
@ShanesCows3 жыл бұрын
Creat multiple inputs and the duplicate this process
@isabelescarlette20213 жыл бұрын
@@ShanesCows Thank you very much!
@rebeccaj1384 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Yes. I thought the email button did just that? If not leave a new comment and I will try to find another example.
@rebeccaj1384 жыл бұрын
@@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.
@ShanesCows4 жыл бұрын
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.
@rebeccaj1384 жыл бұрын
@@ShanesCows thank you will try that out.
@davidakridge28314 жыл бұрын
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.
@ShanesCows4 жыл бұрын
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.
@davidakridge28314 жыл бұрын
@@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
@luchoacecas4 жыл бұрын
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
@ShanesCows4 жыл бұрын
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
@deannalegare78572 жыл бұрын
@@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.
@CINsyg2 жыл бұрын
Gread Video(know its old), wish you could show how to merge a peninput on top of an image to one image
@solageormeich3 жыл бұрын
How to add the image as a column in a sharepoint list
@inside-best1614 жыл бұрын
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.
@ShanesCows4 жыл бұрын
You skipped the step of passing it through an image control
@inside-best1614 жыл бұрын
@@ShanesCows thanks Shane, u r right, i missed this step...
@blutkraehe_official4 жыл бұрын
hi, how do i store a signature in a share point list in the attachment column ?
@ShanesCows4 жыл бұрын
You cannot directly. Have to use Flow to move it there.
@blutkraehe_official4 жыл бұрын
@@ShanesCows and how?.
@Daviirose34 жыл бұрын
is there a way to instert that image into a pdf file with an image field?
@ShanesCows4 жыл бұрын
Yes. YOu need the base64 of the image. In this video I show how to get it from a OneDrive file kzfaq.info/get/bejne/aNiWdLSWltGvaIE.html or this video kzfaq.info/get/bejne/abeRnLBpuMu7loE.html shows how to get it for a file you attach.
@Daviirose34 жыл бұрын
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
@adeoneliberiofilho74273 жыл бұрын
Very Good !!!
@ShanesCows3 жыл бұрын
Thank you! Cheers!
@AnkitShah554 жыл бұрын
Excellent
@ShanesCows4 жыл бұрын
Thanks 🙏
@WillCooper14 жыл бұрын
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.
@ShanesCows4 жыл бұрын
You have to write the logic to look it up. Then place it in an image control.
@DB-CustomRide4 жыл бұрын
Good evening (at least in Poland) I have an Issue that I can't find any answer to. It's not related to PenInput, but I'm despret as I want to public an app tomorow morning, and have a grand opening. I have a barcode scaner, it's value is displayed as a text in TextInput box. Gallery is filtered by value from that TextInput. When the value is written manualy, it works fine, but when I'm using scanner, it change the TexTinput Value, but don't filter the gallery. Only changing the TexTInput manualy, even by one number, can trigger the filtering. Is there any trick to fix this? Thank you very much in advance, and thanks for all the content added on this channel, it helped me a lot.
@DB-CustomRide4 жыл бұрын
@C S Tried this, it doestn't work... well, it work, but only triggered by writing manually in textinput.
@DB-CustomRide4 жыл бұрын
@C S refresh didn't work, it refresh only a data source, I will try restart :)
@rch242313 жыл бұрын
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.
@ShanesCows3 жыл бұрын
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
@rch242313 жыл бұрын
@@ShanesCows Thank you Shane. I just signed up.
@ramisolipe70013 жыл бұрын
Awesome,
@ShanesCows3 жыл бұрын
Thank you! Cheers!
@Warbots9834 жыл бұрын
can you please make another video how to show signature as image in sharepoint (list)? and not as random text?
@ShanesCows4 жыл бұрын
Not sure but I will look.
@sarahtrossman11724 жыл бұрын
@@ShanesCows Had a similar issue and found the following -sergeluca.wordpress.com/2018/08/02/update-sharepoint-hyperlink-pictures-with-flow-and-the-send-an-http-request-to-sharepoint/ Struggled for a bit due to incorrect column name (Open Sharepoint Column in list settings and grab the end of the link to ensure it is correct)
@lagenteestaloca58753 жыл бұрын
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
@ShanesCows3 жыл бұрын
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.
@lagenteestaloca58753 жыл бұрын
@@ShanesCows exactly my plan after I recover from a night shift today... a few people tried to die, none succeeded... thanks again!