PowerApps Pen Input to SharePoint

  Рет қаралды 61,069

Shane Young

Shane Young

4 жыл бұрын

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
@apoorvamohan8988
@apoorvamohan8988 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Glad to help. 😀
@basstubamatt
@basstubamatt 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
Glad you got it. This video talks about another thought here if it helps you at all. kzfaq.info/get/bejne/mK-emJZ1qZmscZs.html
@vmarr0y0
@vmarr0y0 4 жыл бұрын
I haven’t watched it in full yet, but am bookmarking and liking in advance. Thanks!!!!
@ShanesCows
@ShanesCows 4 жыл бұрын
Cool
@derek_shannon
@derek_shannon 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Me too. Make sure you leave a new comment to report back. I don’t want to miss it. 😀
@louismartini6983
@louismartini6983 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
You are welcome Louis 😻
@michelesarsitis233
@michelesarsitis233 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
Awesome! 😀
@dannielleszuba5699
@dannielleszuba5699 4 жыл бұрын
Awesome Shane, you are a life saver. I would be interested in the 4 hour class l.
@ShanesCows
@ShanesCows 4 жыл бұрын
It will launch on Monday. I will drop you a link or you can email me. Shane at PowerApps911.com
@titopeej_6911
@titopeej_6911 4 жыл бұрын
Awesome tutorial Shane! You're the best!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 🙏
@robertgoffard2470
@robertgoffard2470 4 жыл бұрын
GREAT Video!! Thank you for taking the time to figure this out and put together the training video.
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad to help Robert🤓
@robertgoffard2470
@robertgoffard2470 4 жыл бұрын
Question, the SharePoint drops the @base64ToBinary(triggerBody() and reverts back to the regular Binary format. Any suggestions ?
@practicalpowerapps
@practicalpowerapps 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Thanks for sharing Warren. 😀
@juggaberglund
@juggaberglund 4 жыл бұрын
Brilliant tutorial as always Shane 😃👏🏻 Really good stuff 👍🏻
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 😻
@jwr915
@jwr915 2 жыл бұрын
Thank you, Shane. Saved me days of struggle.
@ArkysisGaming
@ArkysisGaming 2 жыл бұрын
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.
@kristenpetillon5671
@kristenpetillon5671 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
Glad to help. 😀 🐶
@FurnBirds
@FurnBirds 2 жыл бұрын
Excellent tutorial!!! Thank you Thank you and THANK YOU!
@woz8855
@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
@krazykalebhawkins895
@krazykalebhawkins895 3 жыл бұрын
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
@Addietoons
@Addietoons 3 жыл бұрын
Thank you so much for this video. Just what I needed!!
@ShanesCows
@ShanesCows 3 жыл бұрын
Glad to help Laura!
@jean-philippedelaune2607
@jean-philippedelaune2607 4 жыл бұрын
Thank you ! Or as they say in my country : merci beaucoup Shane !
@ShanesCows
@ShanesCows 4 жыл бұрын
😎👍
@IndyBansal94
@IndyBansal94 6 ай бұрын
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
@galinagolant Жыл бұрын
Thank you! Great video! Very helpful!
@ShanesCows
@ShanesCows Жыл бұрын
Happy to help 😎😎
@wizardmhc
@wizardmhc 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
Encantado de ayudar
@kevinhardy8179
@kevinhardy8179 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
I would think so but I haven’t tried. Maybe set the add media xo trip through an image control?
@anthonyanyoti
@anthonyanyoti 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Probably but I haven’t tried. Sorry
@amycarl9165
@amycarl9165 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
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.
@imranpearl
@imranpearl 4 жыл бұрын
This indeed was very helpful. Thank you so much
@ShanesCows
@ShanesCows 4 жыл бұрын
You are welcome
@timwiles440
@timwiles440 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Yes. kzfaq.info/get/bejne/b8pjhZZkm9-Rmmw.html
@hudongwang7550
@hudongwang7550 2 жыл бұрын
Thank you, you save my job.!
@ShanesCows
@ShanesCows 2 жыл бұрын
Awesome :)
@burtonsbiscuits4574
@burtonsbiscuits4574 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
I am not sure. I haven't tried that scenario. I would guess yes but nothing I can point you to.
@danielherrera3973
@danielherrera3973 4 жыл бұрын
Amazing, thank you so much for this one
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad to help. 😀
@seantambling
@seantambling 4 жыл бұрын
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
@seantambling 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Glad you got it.
@deryckgaffney3294
@deryckgaffney3294 4 жыл бұрын
@@seantambling Hi. Excelent Vidioe Shane. Just what I was looking for, I couldn't get that to work
@deryckgaffney3294
@deryckgaffney3294 4 жыл бұрын
@@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
@rishiparikh4156 4 жыл бұрын
@@deryckgaffney3294 Hi Deryck. It didn't work for me too. Any update?
@myatix1
@myatix1 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
I have done this before. I send all of the info to Flow and let it do the file and the update the data
@jaysenprocter
@jaysenprocter 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
No real way to save it as an attachment. You could have flow move it after the fact possibly.
@jaysenprocter
@jaysenprocter 4 жыл бұрын
@@ShanesCows Many thanks for the reply, I will keep on searching for solutions. Again many thanks for providing these videos to the community.
@tenisviejos
@tenisviejos 4 жыл бұрын
Brilliant, thanks a lot, great video as usual 👌🏻
@ShanesCows
@ShanesCows 4 жыл бұрын
Happy to help
@Dattics
@Dattics 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Interesting I haven’t ran into that. Thanks for sharing
@tuffley2175
@tuffley2175 4 жыл бұрын
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
@AdiCristea
@AdiCristea 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Glad you enjoyed it. 😀
@stanislavshestakov7685
@stanislavshestakov7685 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
The Flow can return the file url so yes you would have it.
@kevinbriz17
@kevinbriz17 2 жыл бұрын
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
@ShanesCows 2 жыл бұрын
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 😎
@kevinbriz17
@kevinbriz17 2 жыл бұрын
@@ShanesCows How did i miss that video! Cheers Shane, you continue to make me look very good at my job. 😎
@miprofetic
@miprofetic 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
You have an issue with your base64 or img tag. Look at the html file and see if you can spot the issie
@patricknassar3790
@patricknassar3790 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Look at my video on repeating tables like infopath for an example of the master and child relationship
@nepe1024
@nepe1024 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
PowerApps has 260+ connector to talk to robust back ends like SQL or CDS
@Twyfie1
@Twyfie1 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
Yep. Just like you said it would work that way exactly. We do it in a few customer apps. 😀
@geauxvols
@geauxvols 3 жыл бұрын
@@ShanesCows Would you store the JSON data with the Base64 prefix stripped off, or leave it as it is? Or does it even matter?
@mudandmire
@mudandmire 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
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
@mudandmire 4 жыл бұрын
@@ShanesCows thanks Shane, I'll give that a try and let you know how I get on.
@akdmkz9926
@akdmkz9926 4 жыл бұрын
@@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
@mudandmire 4 жыл бұрын
@@akdmkz9926 Not yet sadly, still having some issues. I will be trying some other work arounds for this soon.
@InnovationUSVolvo
@InnovationUSVolvo 4 жыл бұрын
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.
@elieabidaher35
@elieabidaher35 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Do they have OneDrive? It creates the file in the users OneDrive
@leokearns1221
@leokearns1221 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
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
@leokearns1221 3 жыл бұрын
@@ShanesCows cool. Cheers Shane.
@flightmode7655
@flightmode7655 2 жыл бұрын
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?
@louismartini6983
@louismartini6983 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
If you are saving it as an image an image control should work
@imranpearl
@imranpearl 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
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.
@VANDIK01
@VANDIK01 2 жыл бұрын
Hi Shane, amazing video, can you help me how to collect multiple signatures into document? many thanks
@bobbigordon8678
@bobbigordon8678 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
I don’t have any guesses too of my head. Sorry
@zxyong83
@zxyong83 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Html img tag you can set height and width
@Gabriellipe77
@Gabriellipe77 3 жыл бұрын
@@ShanesCows it doesn't work to me :( any ideia? My tag: where varsize: Set(varsize;1000) Thank you in advance!
@alhussanschools4874
@alhussanschools4874 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
I have never done that. Sorry
@markylon
@markylon 2 жыл бұрын
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?
@markmclean154
@markmclean154 4 жыл бұрын
Nice work as always Shane
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks you were my inspiration 😀
@lyndonmalan764
@lyndonmalan764 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
What if you set the height width of the img tag In the html?
@lyndonmalan764
@lyndonmalan764 4 жыл бұрын
@@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!
@wichudatriphatthananun2236
@wichudatriphatthananun2236 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Shared logins are not allowed according to the license
@stamatismalissovas713
@stamatismalissovas713 2 жыл бұрын
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
@luisaugustomeyer2038 Жыл бұрын
Hi Shane, excellent video. How can I use a variable name for the file? Ex. The user logged in the powerapps.
@user-hf5jr3lp5f
@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
@user-hf5jr3lp5f Жыл бұрын
Compose step, not convert!
@DijonLR
@DijonLR 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
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.
@milesb7243
@milesb7243 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
As long as you don’t reset the variable you should be able to use it as much as you want
@walterwego1396
@walterwego1396 3 жыл бұрын
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.
@lankeastor512
@lankeastor512 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
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.
@thonhernhor1265
@thonhernhor1265 4 жыл бұрын
Hi Shane, must the users have the access to the Sharepoint list in order for this method to work?
@ShanesCows
@ShanesCows 4 жыл бұрын
Yes
@briananderson4911
@briananderson4911 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
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
@briananderson4911 3 жыл бұрын
​@@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
@benjaminlahsen6721 Жыл бұрын
Can I use that new JSON format to print the image in an HTML control directly without using flow?
@ShanesCows
@ShanesCows Жыл бұрын
THe HTML control in Power Apps doesn't show images :(
@benjaminlahsen6721
@benjaminlahsen6721 Жыл бұрын
@@ShanesCows owww thank you for your answer. You are the best !
@Warbots983
@Warbots983 4 жыл бұрын
thanks alot for the video, where is your intro? it was cool and i loved the music in it
@ShanesCows
@ShanesCows 4 жыл бұрын
Did I forget the intro? Ugh me.
@MsRameshbhati
@MsRameshbhati 4 жыл бұрын
Thanks for sharing shane. :)
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad to help. 😀
@bavajidoriginti2016
@bavajidoriginti2016 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
Sorry I don't follow
@KenWarthen
@KenWarthen 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Sure. Send the ID or link to the item
@KenWarthen
@KenWarthen 4 жыл бұрын
@@ShanesCows How do you capture the ID or Link in the Flow?
@ChekwubeRemigiusOnyekaba
@ChekwubeRemigiusOnyekaba 7 ай бұрын
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
@ShanesCows 7 ай бұрын
This video should help kzfaq.info/get/bejne/gZ1kiKmKzNivcmg.html
@walterwego1396
@walterwego1396 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
Thanks for sharing Walter 🐶
@rishiparikh4156
@rishiparikh4156 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Ask in Power Apps for the filename
@HansMorano
@HansMorano 2 жыл бұрын
Hi Shane, great video. Do you have a guide for saving signatures to Dataverse?
@ShanesCows
@ShanesCows 2 жыл бұрын
I don't, I haven't done that before but there is an Image column type so hopefully it isn't too hard.
@HansMorano
@HansMorano 2 жыл бұрын
@@ShanesCows Thank you for your swift response. I’ll give it a go. Also, thanks for the great content.
@mtamitolanga
@mtamitolanga 3 жыл бұрын
Hi Shane is it possible to save pen input to a sharepoint list field. Thank you.
@ShanesCows
@ShanesCows 3 жыл бұрын
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
@newpost656
@newpost656 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Post a new comment with the formula that is causing the error and I can try to help.
@newpost656
@newpost656 4 жыл бұрын
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.
@cholopa
@cholopa 4 жыл бұрын
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
@cholopa 4 жыл бұрын
Ok, the issue was that I was tring to see the image in a html control inside powerapps...
@ShanesCows
@ShanesCows 4 жыл бұрын
Yup. 😀 Glad you got it.
@Patrick-iu1qj
@Patrick-iu1qj 4 ай бұрын
How do you embed the signature into an existing PDF (append to the end)?
@ShanesCows
@ShanesCows 4 ай бұрын
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
@pcowburn2409
@pcowburn2409 9 ай бұрын
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
@ShanesCows 9 ай бұрын
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
@pcowburn2409 9 ай бұрын
@@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
@lindsayconstructionentlimi8666
@lindsayconstructionentlimi8666 4 жыл бұрын
How can you have the file name change for each time you save it to the sharepoint folder?
@ShanesCows
@ShanesCows 4 жыл бұрын
You could use the GUID() or Now() function to get unique string and then add it to the file name?
@silvinhalalin
@silvinhalalin 2 жыл бұрын
Would it be possible to save in a sharepoint list, with the other fields of the form?
@ShanesCows
@ShanesCows 2 жыл бұрын
Yes, if you saved the Base64 encoding of the file. I show it here kzfaq.info/get/bejne/frqJa6SfsuCZoqs.html
@silvinhalalin
@silvinhalalin 2 жыл бұрын
@@ShanesCows thanks!!
@apctools4460
@apctools4460 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
That tells me you don't have an "Ask in Power Apps" for CreateFile_FileContent.
@apctools4460
@apctools4460 3 жыл бұрын
@@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
@InnovationUSVolvo
@InnovationUSVolvo 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Check your flow. You dont have an ask in PowerApps dynamic content.
@isabelescarlette2021
@isabelescarlette2021 3 жыл бұрын
Hi Shane, how can you save multiple signatures from one form to a Sharepoint list?
@ShanesCows
@ShanesCows 3 жыл бұрын
Creat multiple inputs and the duplicate this process
@isabelescarlette2021
@isabelescarlette2021 3 жыл бұрын
@@ShanesCows Thank you very much!
@rebeccaj138
@rebeccaj138 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
Yes. I thought the email button did just that? If not leave a new comment and I will try to find another example.
@rebeccaj138
@rebeccaj138 4 жыл бұрын
@@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
@ShanesCows 4 жыл бұрын
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
@rebeccaj138 4 жыл бұрын
@@ShanesCows thank you will try that out.
@davidakridge2831
@davidakridge2831 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
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
@davidakridge2831 4 жыл бұрын
@@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
@luchoacecas
@luchoacecas 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
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
@deannalegare7857 2 жыл бұрын
@@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.
@CINsyg
@CINsyg 2 жыл бұрын
Gread Video(know its old), wish you could show how to merge a peninput on top of an image to one image
@solageormeich
@solageormeich 3 жыл бұрын
How to add the image as a column in a sharepoint list
@inside-best161
@inside-best161 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
You skipped the step of passing it through an image control
@inside-best161
@inside-best161 4 жыл бұрын
@@ShanesCows thanks Shane, u r right, i missed this step...
@blutkraehe_official
@blutkraehe_official 4 жыл бұрын
hi, how do i store a signature in a share point list in the attachment column ?
@ShanesCows
@ShanesCows 4 жыл бұрын
You cannot directly. Have to use Flow to move it there.
@blutkraehe_official
@blutkraehe_official 4 жыл бұрын
@@ShanesCows and how?.
@Daviirose3
@Daviirose3 4 жыл бұрын
is there a way to instert that image into a pdf file with an image field?
@ShanesCows
@ShanesCows 4 жыл бұрын
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.
@Daviirose3
@Daviirose3 4 жыл бұрын
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
@adeoneliberiofilho7427
@adeoneliberiofilho7427 3 жыл бұрын
Very Good !!!
@ShanesCows
@ShanesCows 3 жыл бұрын
Thank you! Cheers!
@AnkitShah55
@AnkitShah55 4 жыл бұрын
Excellent
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 🙏
@WillCooper1
@WillCooper1 4 жыл бұрын
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.
@ShanesCows
@ShanesCows 4 жыл бұрын
You have to write the logic to look it up. Then place it in an image control.
@DB-CustomRide
@DB-CustomRide 4 жыл бұрын
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-CustomRide
@DB-CustomRide 4 жыл бұрын
@C S Tried this, it doestn't work... well, it work, but only triggered by writing manually in textinput.
@DB-CustomRide
@DB-CustomRide 4 жыл бұрын
@C S refresh didn't work, it refresh only a data source, I will try restart :)
@rch24231
@rch24231 3 жыл бұрын
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
@ShanesCows 3 жыл бұрын
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
@rch24231 3 жыл бұрын
@@ShanesCows Thank you Shane. I just signed up.
@ramisolipe7001
@ramisolipe7001 3 жыл бұрын
Awesome,
@ShanesCows
@ShanesCows 3 жыл бұрын
Thank you! Cheers!
@Warbots983
@Warbots983 4 жыл бұрын
can you please make another video how to show signature as image in sharepoint (list)? and not as random text?
@ShanesCows
@ShanesCows 4 жыл бұрын
Not sure but I will look.
@sarahtrossman1172
@sarahtrossman1172 4 жыл бұрын
@@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)
@lagenteestaloca5875
@lagenteestaloca5875 3 жыл бұрын
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
@ShanesCows
@ShanesCows 3 жыл бұрын
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.
@lagenteestaloca5875
@lagenteestaloca5875 3 жыл бұрын
@@ShanesCows exactly my plan after I recover from a night shift today... a few people tried to die, none succeeded... thanks again!
THEY made a RAINBOW M&M 🤩😳 LeoNata family #shorts
00:49
LeoNata Family
Рет қаралды 43 МЛН
Gym belt !! 😂😂  @kauermtt
00:10
Tibo InShape
Рет қаралды 13 МЛН
WHAT’S THAT?
00:27
Natan por Aí
Рет қаралды 13 МЛН
Clown takes blame for missing candy 🍬🤣 #shorts
00:49
Yoeslan
Рет қаралды 39 МЛН
SharePoint Fundamentals: The SharePoint Document Library
14:52
Daniel Anderson
Рет қаралды 8 М.
Power Apps Pen Input save to SharePoint & PDF (Signature)
22:11
Reza Dorrani
Рет қаралды 81 М.
PowerApps Flow Intro Upload an image to SharePoint using Flow
38:37
PowerApps Filter Gallery by the Current User
22:16
Shane Young
Рет қаралды 115 М.
PowerApps PDF Generator using Microsoft Flow PDF Converter
25:50
Shane Young
Рет қаралды 198 М.
PowerApps Patch Function
26:45
Shane Young
Рет қаралды 212 М.
Intro to PowerApps Variables
19:23
Shane Young
Рет қаралды 203 М.
PowerApps Tabbed Form
25:52
Shane Young
Рет қаралды 78 М.
Use the Power Automate v2 Trigger for Power Apps
19:09
Shane Young
Рет қаралды 36 М.
SharePoint Document Library Tutorial
20:22
Kevin Stratvert
Рет қаралды 649 М.
iPhone, Galaxy или Pixel? 😎
0:16
serg1us
Рет қаралды 1,1 МЛН
Это - iPhone 16 и вот что надо знать...
17:20
Overtake lab
Рет қаралды 121 М.
НОВЫЕ ФЕЙК iPHONE 🤯 #iphone
0:37
ALSER kz
Рет қаралды 42 М.
Копия iPhone с WildBerries
1:00
Wylsacom
Рет қаралды 5 МЛН