Thank you Shane. Wonderful tutorial. I think you have another tutorial on how to generate PDF from within PowerApps. I will watch that one again and combine that with this tutorial so that the email attachment is a PDF copy of the consent form with the signature field.
Your video in the Flows video services and this one got me thinking how easy it would be to make a day care login app like they have on ipads there, the business I work for just took over a day care.
I helped Jeff on Twitter but in case anyone else is wondering: Quasi-Technical explanation. You always use " " around strings. You usually use ' ' around some functions and data sources with spaces or special characters in the name. There are some exceptions but hope that helps. Flow is opposite to help confuse you.
Slider1.Value is the output of a slider. So you could Patch or Collect that into a collection. Try this video for ideas. th-cam.com/video/MclJ_O9HvJQ/w-d-xo.html
Thanks for your tutorial very easy to understand. Could you please recommend me what video to view for learning on how to order the display, eg order the name by alphabetic order. Thanks
Thank You so much Shane you have helped me greatly. I built the app just as you did however I get an error on the Slider Handle Fill. It says the Name isn't valid even though it turns "Age" purple and everything seems to work even with error. Here is the formula: If(Age >= 18, White,Red) Any suggestions?
Fantastic video. Do you have any more videos on creating a PDF file that includes the signature from the PenInput control and emailing that as an attachment?
Shane, You Rock Man! i have learned so much watching your Videos. I also was present in the App in a Day workshop at the App Summit. Any chance you can build a video on how to store the Pen Input Image to SharePoint? This is an ask that is all over the PAC. Not to mention it would help about 5k Technicians at my company
Hey Matt. I need to figure it out better. The easy answer? Email it to you with a subject like Chewy is awesome. Then have a Flow that runs when an email with that subject comes in to move the attached dog to SharePoint 😀
Thanks Again Shane. Is there a way to send multiple images as shown as the attachments. Scenario is I build a collection of attendees who all sign their name. I can create a html out put to list the attendees and when I see the collection it shows all signatures but this will not show in the email so I assume I need to do what you have done as an attachment. I cannot seem to get that to work
Your point about having added the submission with signature to a DB, Excel, or even better a SharePoint List would have been a bonus. Can you make a quick tutorial on saving the consent to a list as well? Consent is auditable.
Hi Tom. Yeah, the saving to somewhere else can be a pain. What data source would you like to see? Maybe I will see if I can quickly put together a walk through.
Love the videos! Any chance you could organize the playlist better? I went from #1 to #2 and it talked about things being covered in previous videos that I don't know the right order. Thanks!
Hi Shane, great stuff in the video, and maybe I missed something, but I have a form where the employee signs it, and I would like to use pen input, then I need to write the fact it has been signed to my sharepoint list. Also when they go back into the form at a later date, it needs to recall the signature and display it. Have you covered this please?
Hi Shane, love this video. I would have a question: How to reset Checkbox field type? If i use Reset(CheckboxLeaveSignature) it doesnt reset - stays checked. I am trying to show TextInput only if checkbox is checked.
@@ShanesCows yes, it was false. But about week ago I found everything is working properly! I did not changed anything. I still have those: Reset(PenInput1_1);;Reset(CheckboxOrderedPaid)). I wonder if resetting of the device helped this time because of caching issues of PowerApps app? Or there was an update or fix? I don't know what helped here. For those who are still looking for help- maybe this article would be valuable: powerusers.microsoft.com/t5/General-Discussion/Reset-Checkboxes-in-Gallery/m-p/101559#M37545
Thank you, Shane! Excellent information. Is there any out of the box solution or method to store the Pen Input directly to SharePoint List as an attachment or as a picture?
Hello Jane - many thanks for this usefull video. Would you please explain me for those cases where you have different view pages how you send the signature input into another page? I would like to know if possible to show what was signed into one page in display mode only. Warm regards
Congratulations have been the best videos to learn PowerApps. Please I have a question, how can I save the signature as an image column in Sharepoint List?
Shane, really great video for the PowerApps beginner, one question of the tutorial, after the user choose "yes" in the toggle button, how could I also send a copy to the user, as I tired, if you put the action in oncheck in the toggle button, it will send the blank jpg to the user. And also the Office365.sendemail function can only send to one receiver? How do I solve this problem. Thank you Shane.
You can send to multiple people. In US version you just need to separate the emails with a ; Also remember the users email is available by user().email
Thank you Shane for creating this very useful video. I got one question in this video. I am not sure what is the meaning of '@odata.type' and why do you need to include this when you try to have an image attachment, you also include this kind of type in another video. Could you please explain? Thank you very much.
Thanks again for an awesome video, how would you go about attaching a picture gallery, peninput and possibly audio capture? In other words multiple attachments.
Hello Shane...awesome video man and kudos to you for all ur efforts in teaching the community...i'm having a peculiar issue with the consent form buddy...iv connected with my Office365 account (DataSource)....iv used the same formula as illustrated by you for sending an email attachment but its giving me an error "Invocation of unknown and unsupported function"...could you plz help with the same buddy?...thnx again for your magnanimity :)
Ok. I got the answer. For me it works with Office365Outlook.SendEmail(...) Instead of Office365.SendEmail(...) They changed apparently the function name.
Hi Shane, nicely done! It'll be really useful if the image can capture the whole form though. Btw do you have a tutorial on multi-level approvals for these forms? For instance, routing this consent form to another level of approval before the whole form is actually approved.
Hi Noel. You are not the first person to ask for the ability to capture the whole form. So i just went and passed the idea to the product team. powerusers.microsoft.com/t5/PowerApps-Ideas/Capture-the-whole-screen/idi-p/93376#M4091 Please go to the site and vote for it and add your information. As for mulit approval. It is very do able but I haven't made a video on it yet. Sorry.
@@ShanesCows Thank you so much for your videos! I would like to know if it is possible to combine screens to make a continuos form to feed a database and the last screen to send the consent form to an email
Hello Shane, your videos are really good, I tried this app and it really gives us the better comprehension of the functions, but the function of sending emails is not working in my app, the message says, “invocation of unknown or unsupported function. How can I fix it? Thank you
Shane Young , thank you I solved the error, actually I don’t know where was the problem but a i fixed, now I’m having problema with sending email with attachments here is the formula Office365Outlook.SendEmailV2("myemail@hotmail.com", "here is the file", "Body goes here",{Attachments: AddColumns(RenameColumns( AttachmentControl.Attachments, "value","ContentBytes", "@odata.type",""))}) Some errors apear: The function ‘send email v2’ has invalid arguments. Invalid argument type. Expecting a table, but of a different schema. Missing column. Your formula is missing a column ‘content bytes’ with a type of ‘blob’. Invalid number of arguments: received 1, expects 3 or more
Hi Shane, you have done great job by doing these videos. It is very informative. Thank you very much. I have one doubt here, at the end you wrote a formula for sending email. I am not clear on that , can you please explain that one in detail
Shane Young I tried to use below formula which was explained in consent form video I am not sure where it could be wrong office365.SendEmail("sss@alwalsss.onmicrosoft.com","My Subject text","Body Text",{attachments:Table("Name:"Peninput.jpg",ContentBytes:Signature.Image,'@odata.type':""}}}) On the other hand I will watch another video which you shared now about sending email using PowerApp
Great tutorial Shane, can you show how to embed (base64 format) pen input signature in HTML email body instead of attachment? Is it possible to make with powerapps and flow.? Thanks
Hi Gerry - Long story short, I don't think it is right now. :( You could maybe make something that emails the input and then have flow grab the attachment and put it HTML. Sorry, I haven't found a lot of great solutions here yet.
First these videos have been so helpful. I am teaching myself PowerApps (and I am not a developer) so it has been extremely helpful! I am trying to create an inspection form that is comprised of about 5 sections with at least 4 questions in each. The answers are Yes/No/NA... I am stumped as to how to design this? I also want to use Conditional Formatting to only see the questions for that section based on a Yes or No response. Also, can I have the results in a PDF or Word file? (Saved in OneDrive or SharePoint)
Could the signature be made to the SharePoint attachment field without the AzureBlobStorage? My IT doesn't want to provide me with the storage name nor the key values needed to establish the AzureBlob connection... 😡 (Currently, I'm sending the user to a form with the attachment control to add files to the sharepoint item, submitting the form, sending them back to the screen with the gallery... something more elegant is what I'm looking for... )
Hi Shane, Your videos are fantastic and are so easy to follow. Thank you so much. Sorry if I have missed a video on this topic but I have a question about being able to Filter a PowerApp BrowseGallery by a Status field. Example: I have a Sharepoint Online task list which assigns all actions to one person. I would like that person on opening Powerapps to only see items in the gallery where the Status Column (drop-down) is equal to In Progress. (i.e. actions that he needs to complete) Any help would be gratefully appreciated.
I have built my app (with the help of many of Shane's videos). But now I'm stuck. It is pretty much a data collection form. I want to send it to someone via email, they complete it and the info populates back into my list. How do I send this form to people? I don't want them to have access to anything - just for them to complete the form.
I know this is an old post but maybe somebdoy can help me. The formula If(IsMatch(Emailadress.......) keep given Parenclose error . I did exactly the same as in the video so no idea whats wrong
Shane, I really appreciate your work, I follow all your videos and you have been a great help. I was wondering if you are able to submit Pen Input ( create pen input as image and send it to a SharePoint path)? rather than email?
Is it also possible to put that signature photo into an email -but- as picture insert into it - instead of attachment. I am trying to do something like this but will need it to generate actual letter (with text like "Dear A I blah blah Sincerely B & Signature )
Hello Shane, awesome video! thanks for all this tips! I want to create a PDF file out of the information on the form and email it with the signature included. Is it possible? Do you have videos that cover something similar to what I would like to do? Thanks!
Shane, I have a student leavers List and i want generate Leavers form based of the list and email to these students with the attached PDF (Leavers Form with data from the excel list) who are leaving, Is this possible to achieve using powerapps?
great tutorial Shane. i followed up all the steps, but i faced the following: i wanted to add a toggle button and a date picker, i got them into the window, but as the screen in my case has many cards so i have to scroll down and up to get to all the card and it's then when things misses up, the toggle button and the date picker stay in the same position and won't scroll with the cards, is there a way to get them into the card so they we will follow the form when scrolling ? one more thing, can i link a button with "send SMS" thank you again.
Dara I cover that exact problem in a different video. I am pretty sure it is this one. PowerApps Custom Forms to look more like InfoPath th-cam.com/video/5vVFgaEBYuM/w-d-xo.html if that doesn’t help let me know.
Thank you Shane, the problem is solved. Moving forwards i got the following issues: 1-) i want to link a card with a datepicker and another card to a toggle, i mean that a card to be filled and to get the results from the datepicker, and the other card to get the value from a toggle, for example (when the toggle is "Yes", so the card will be filled as Yes), i managed to get the results from a datepicker into a card but still the format of the date is not the same, (datepicker is dd/mm/yyyy) but the card is getting (m/d/yyyy), the same with the toggle, i'm getting (false/true) while i'd like it to be filled with (Yes/No) instead. 2-) is there a way to add a button to act like "send SMS" (for example send a card that will tell the customer that the work is done , as an SMS). thank you in advance
This was so helpful! Would a form like this be able to submit the information to a SharePoint List rather than an e-mail? I much prefer creating my forms this way, instead of connecting to a SharePoint data source right off the bat.
When you use if condition for slider, which is control datatype it isn't showing error for u but when I am doing the same it gives out error as this datatype is unsupported for evaluation.
Hello Shane, Love your channel, you are helping me a lot!! Thank you! I have a question for you, did you try to put the image from the PenInput in a pdf? Because, I'm having a concern form that it has to be in a PDF but also need the concern firm, so... I'm trying to out the penintup image in the pdf but it isn't working. Can you help me? I will appreciate! Thanks.
I haven't put a pen input into a PDF but I am certain it is possible, just might not be easy. Concentrate on getting it stored in SharePoint or OneDrive then you can follow my instructions for taking an image from there and putting it in PDF.
Yeah it is working, My problem was only on the TimeZone Date format that was giving the wrong date and another things...but it is working, if you add in some videos in the future, dont forget to talk about the Date format in PowerApps that is differente from excel..i wasnt the only one with this problem :p
Great tutorial! I have a problem with the function "Reset" at the second when I input, after the first Reset that works correcly, when I input semicolon there is a message "unexpected token" the same with comma, so I can only one reset, very strange?? Thanks. Gianni
Thank you very much for you answer. If I input: Reset(Age) or Reset(EmailAddress) or Reset(Name) it works correctly, if I try to input: Reset(Name);Reset(Age) or Reset(Name),Reset(Age) it doesn't work the error message is "Token imprevisto" that means unexpected token. Greatings Gianni
No It doesn't the fields are Age - EmaiAddress - Name , Reset works with every single field but I can't Reset more than one field! After the first Reset if I input semicolon or comma the funcion Reset doen,t appear in the toolbar!!! May I send you a screenshot? Greatings Gianni
This is a popular question. I haven't gone down that road yet. :( I would check out the community forums there are several different ideas out there for sure how to do it. Like this. powerusers.microsoft.com/t5/General-Discussion/Pen-input-save-image-to-SharePoint/m-p/81575#M31657
Try out this video for sending emails with PowerApps th-cam.com/video/bF7WkqtxKB0/w-d-xo.html You would reference the controls the same way you would in the label. "This is my dropdown: " & Dropdown1.Selected.Value for example.
Working my way through these, but gah! Its such a shame he didn't want the data output to azure or excel because outputting barcode data to excel is exactly what I am trying to do at the moment. I am sure I'll see you do it soon enough.
Great Job. Thank you for the great tutorials. Please I want to create a memo template with 3 signatures. the fields are From,To,Cc,Re,Date,and three signatures including their comment and sign date.Creator sign,flow send it to manager to and finally to ceo to sign can you please help me ? Thanks a million.
When creating a form, can you make it where you can share the app outside of your organization? Also, can you create a screen where you are communicating back and forth with someone within the app, and it displays all communication on the app?
Hi Carla - Right now PowerApps apps cannot be shared outside your org or made anonymous. It just isn't how they are built today. Maybe in the future. :) Real-time chat? I haven't tried. Maybe if you did something with a timer and autorefresh you could come up with a solution. Maybe.
Does this way of sending the attachment still work? I did the same and it gives an error, an email comes to my inbox saying that it is not possible to deliver
I think so. I did do another video on this topic that might help th-cam.com/video/RFZfvTuDmP0/w-d-xo.html and also this one th-cam.com/video/bIne3DD3HAg/w-d-xo.html about Base64 covers the Pen Input.
Great Video Shane! but did you miss out how you setup greying out the consent form? as I can't find that bit :( and would be great if you could PDF the consent form and then email it!? :D
Shane, I get error, maybe because this doesn't work on the newest version of powerapps: Office365.SendMail("kmistry@babooks.onmicrosoft.com","My Subject Text", "Body Text", {Attachments:Table({Name:"peninput.jpg", ContentBytes:Signature.Image, '@odata.type':""})}) I get error: Invocation of unknown or unsupported function
hello sir, i have put similar command as you have shown in this video... but it is showing error Office365.SendEmail("xxx.abc.com","My Subject Text", "My Body Text " & txt_userName.Text,{Attachments:Table({Name:"penInput.jpg",ContentBytes:pen_Signature.Image , '@odata.type':""})}) am i doing something wrong?
Shane, Great Tutorial! Really like the jump in *WAIT* that was my exact mistake yesterday. Created whole project and left for the night to see that my session expired this morning. I have utilized all of your steps but would like to add 2 signature lines. It would be great to keep it all within one button command, but everyway I modify it seems to end in unexpected token or expected ParenClose. This is as close as I have come:,Attachments:Table({Name:"peninput1.jpg",ContentBytes:Signature1.Image,'@odata.type':""}),Attachments1:Table({Name:"peninput2.image",ContentBytes:Signature2.Image,'@odata.type':""}) Any Suggestions would be greatly appreciated.
Hey Tony. We had this exact conversation in the forums. Is this you also? If not good news the answer is there. :) powerusers.microsoft.com/t5/General-Discussion/Send-an-image-from-pen-input-via-email/m-p/83740#M32260
That is far as I got in capturing sigs in forms. I haven’t figured out how to capture the form itself with the signature embedded, which I have a requirement for, and as such, I’m still pushing out DoForms instead of PowerApps for quite a few. I hate deploying something I’m trying to kill off. Lol. But business folks got me so busy with PowerBI I don’t have a lot of time to dig in more on PowerApps. Anyone have a duplicator that works on humans?
Took me a while but since someone else also asked for this I went and put in a request. You can go upvote it and add your 2 pennies. powerusers.microsoft.com/t5/PowerApps-Ideas/Capture-the-whole-screen/idi-p/93376 PS it took me 10 minutes to figure out where you had mentioned this. :)
Between you and me I think PowerApps are broken. I am getting a similar error when trying to build an app. :( I need to pick up my kids. Hope it is fixed by the time I get back. powerusers.microsoft.com/t5/General-Discussion/Before-anyone-posts-All-connections-seem-to-be-down-let-s-wait/m-p/97450#M36160
Is the built-in email adress verification editable? i'd like to alter it to be able to detect fake email adresses such as @sharklasers.com / @pokemail.net etc. (all from guerrillamail)
Love this channel honestly. Microsoft need to put his videos on their social. He has done more for PowerApps community than everyone at MS
Thank you. You are too kind. :) I will do my best to be worthy of your words.
Absolutely true. No doubt about it. Best content on PowerApps on the web.
ABSOLUTELY! 100%
ABSOLUTELY! 100%
Plot Twist .He is Microsoft Most Value Professional
Really Shane you are like god to me..
Anything you don’t know Shane. Man your videos are wonderful!! Keep ‘me coming.
Awe shucks. :) Thanks
Best video on PowerApps so far.
Thanks
Fantastic tutorials Shane. Probably the best I've ever seen. I'm grateful for and truly impressed by your work.
Awe shucks. You are welcome.
Thank you for this video. I could not find any documentation for how to do an attachment for an email until I saw this.
Glad to help. :)
My goodness you gem of a person THANK YOU. This helped so much!!!!
You are very kind. Thanks 😀
Excellent, Shane. You really make this fun.
Love the puppy.
Thank you Shane. Wonderful tutorial. I think you have another tutorial on how to generate PDF from within PowerApps. I will watch that one again and combine that with this tutorial so that the email attachment is a PDF copy of the consent form with the signature field.
Awesome!
Your video in the Flows video services and this one got me thinking how easy it would be to make a day care login app like they have on ipads there, the business I work for just took over a day care.
Cool. Love the idea.
Excellent video. Thank you.
At 23:50 mark, email formula with odata has single quotes. Any reason why no double quotes as all other places have?
I helped Jeff on Twitter but in case anyone else is wondering:
Quasi-Technical explanation. You always use " " around strings. You usually use ' ' around some functions and data sources with spaces or special characters in the name. There are some exceptions but hope that helps. Flow is opposite to help confuse you.
Thank you very much for your videos!! Is there a way of saving a slider info into a collection ?
Slider1.Value is the output of a slider. So you could Patch or Collect that into a collection. Try this video for ideas. th-cam.com/video/MclJ_O9HvJQ/w-d-xo.html
Thanks for your tutorial very easy to understand. Could you please recommend me what video to view for learning on how to order the display, eg order the name by alphabetic order. Thanks
This one has what you are looking for th-cam.com/video/_NCLeRpot3k/w-d-xo.html 😎
very helpful and useful information!!!! Thanks Shane
Glad it was helpful!
Thank You so much Shane you have helped me greatly. I built the app just as you did however I get an error on the Slider Handle Fill. It says the Name isn't valid even though it turns "Age" purple and everything seems to work even with error. Here is the formula: If(Age >= 18, White,Red) Any suggestions?
Is Age the name of the control. You may need to do Age.Value
Fantastic video. Do you have any more videos on creating a PDF file that includes the signature from the PenInput control and emailing that as an attachment?
This should help th-cam.com/video/RFZfvTuDmP0/w-d-xo.html
Great series Shane.. can you please create a video with BarCode functionality
I would love to. Wish I had a barcode scanner.
I love your videos !! I can learn a lot !!
Glad you like them!
Best Tutorial I’ve seen to date. Thank you!!!!
Thank you. Let me know if you have suggestions for other topics.
Shane, You Rock Man! i have learned so much watching your Videos. I also was present in the App in a Day workshop at the App Summit. Any chance you can build a video on how to store the Pen Input Image to SharePoint? This is an ask that is all over the PAC. Not to mention it would help about 5k Technicians at my company
Hey Matt. I need to figure it out better. The easy answer? Email it to you with a subject like Chewy is awesome. Then have a Flow that runs when an email with that subject comes in to move the attached dog to SharePoint 😀
Thanks Again Shane. Is there a way to send multiple images as shown as the attachments. Scenario is I build a collection of attendees who all sign their name.
I can create a html out put to list the attendees and when I see the collection it shows all signatures but this will not show in the email so I assume I need to do what you have done as an attachment. I cannot seem to get that to work
Try this video for the concept. PowerApps Email Multiple Attachments th-cam.com/video/V3feURQfY3M/w-d-xo.html
Your point about having added the submission with signature to a DB, Excel, or even better a SharePoint List would have been a bonus. Can you make a quick tutorial on saving the consent to a list as well? Consent is auditable.
Hi Tom. Yeah, the saving to somewhere else can be a pain. What data source would you like to see? Maybe I will see if I can quickly put together a walk through.
Sharepoint list would be very nice, i think you are the first on Tube.
Sharepoint List would be very useful
Any update on this? REALLY need to know. Otherwise i may have to do some kind of email with a flow attached
Devin what do you need to know more?
Great work Shane...
Thanks Cow. My twitter is shanescows so I enjoy a good cow comment. 🐮
Love the videos! Any chance you could organize the playlist better? I went from #1 to #2 and it talked about things being covered in previous videos that I don't know the right order. Thanks!
That is tough. There isn’t an order per say. 😑 Some build off of old concepts though. I will try to think about this.
Hi Shane, great stuff in the video, and maybe I missed something, but I have a form where the employee signs it, and I would like to use pen input, then I need to write the fact it has been signed to my sharepoint list. Also when they go back into the form at a later date, it needs to recall the signature and display it. Have you covered this please?
Try this th-cam.com/video/RFZfvTuDmP0/w-d-xo.html
Great videos Shane.. I dont see HintText in the top left dropdown. is it renamed to something else now?
Tooltip I think is what you need.
I don't know why If(IsMatch(TextInput_Email.Text, Email), Black,Red) doesn't work on mine
They changed it a bit:
If(IsMatch(TextInput1.Text, Match.Email), Color.Black,Color.Red)
@@ShanesCows If(IsMatch(TextInput_Email, Match.Email), Color.Black,Color.Red) Tried this now but shows some problem here "TextInput_Email"
@@Hari-uk8fz Need to put ".text" at the end of your "TextInput_Email" text input.
Hi Shane, love this video. I would have a question: How to reset Checkbox field type? If i use Reset(CheckboxLeaveSignature) it doesnt reset - stays checked. I am trying to show TextInput only if checkbox is checked.
Did you make sure the default for the checkbox was false? I don't use a lot of checkboxes but I did do a test and it does work as I would expect.
@@ShanesCows yes, it was false. But about week ago I found everything is working properly! I did not changed anything. I still have those: Reset(PenInput1_1);;Reset(CheckboxOrderedPaid)). I wonder if resetting of the device helped this time because of caching issues of PowerApps app? Or there was an update or fix? I don't know what helped here. For those who are still looking for help- maybe this article would be valuable: powerusers.microsoft.com/t5/General-Discussion/Reset-Checkboxes-in-Gallery/m-p/101559#M37545
Thank you, Shane! Excellent information. Is there any out of the box solution or method to store the Pen Input directly to SharePoint List as an attachment or as a picture?
Not that I know of. 😑
@@ShanesCows thank you! Shane, for your feedback.
Hello Jane - many thanks for this usefull video. Would you please explain me for those cases where you have different view pages how you send the signature input into another page? I would like to know if possible to show what was signed into one page in display mode only. Warm regards
You could reference the value of the pen input in an image control to show it on another screen.
@@ShanesCows your reply and explanation is much appreciated. Many thanks and will try :)
Great stuff Shane. Can you post the formula used in the submit button? Too many ( and { and it's hard to make out on screen. Thanks.
Like this? :)
UpdateContext({PopUp:
true});Office365.SendEmail("shane.young@boldzebras.com","My
Consent Form" , "Body
Text",{Attachments:Table({Name:"peninput.jpg",ContentBytes:PenInput1.Image
, '@odata.type':""})});
Mucho Glassy-Eyes ;) Perfect.
Congratulations have been the best videos to learn PowerApps.
Please I have a question, how can I save the signature as an image column in Sharepoint List?
This video th-cam.com/video/RFZfvTuDmP0/w-d-xo.html
@@ShanesCows thank you, i had already found the video and implemented,
Shane, really great video for the PowerApps beginner, one question of the tutorial, after the user choose "yes" in the toggle button, how could I also send a copy to the user, as I tired, if you put the action in oncheck in the toggle button, it will send the blank jpg to the user. And also the Office365.sendemail function can only send to one receiver? How do I solve this problem. Thank you Shane.
You can send to multiple people. In US version you just need to separate the emails with a ; Also remember the users email is available by user().email
Thanks Shane.
Muy buena explicacion, gracias por compartir todo tu conocimiento
Muchas gracias, me alegra que te haya sido útil. ¡Un saludo! -ChatGPT helped me write that :)
Good video! Again, very helpful!
Thanks again!
Thank you Shane for creating this very useful video. I got one question in this video. I am not sure what is the meaning of '@odata.type' and why do you need to include this when you try to have an image attachment, you also include this kind of type in another video. Could you please explain? Thank you very much.
It is just a value that PowerApps expects from you. Not really sure I have ever thought about what it really is. Sorry. :(
Thanks again for an awesome video, how would you go about attaching a picture gallery, peninput and possibly audio capture? In other words multiple attachments.
I haven’t done it but you should be able to. Just have to get the table structure right.
@@ShanesCows got it working just does not allow for empty fields or the entire thing fails, nothing that can't be fixed with a loooong if statement
Hello Shane...awesome video man and kudos to you for all ur efforts in teaching the community...i'm having a peculiar issue with the consent form buddy...iv connected with my Office365 account (DataSource)....iv used the same formula as illustrated by you for sending an email attachment but its giving me an error "Invocation of unknown and unsupported function"...could you plz help with the same buddy?...thnx again for your magnanimity :)
Got the same error. Any Solutions?
Ok. I got the answer.
For me it works with
Office365Outlook.SendEmail(...)
Instead of
Office365.SendEmail(...)
They changed apparently the function name.
Yeah. They changed things. :| Thanks for sharing.
Hi Shane!
Awesome video!
I have a question about this form, what should I change to the result be stored on a ExcelFile in Sharepoint?
Not possible. YOu can't use an Excel file hosted in SharePoint as a data source.
Hi Shane, nicely done! It'll be really useful if the image can capture the whole form though. Btw do you have a tutorial on multi-level approvals for these forms? For instance, routing this consent form to another level of approval before the whole form is actually approved.
Hi Noel. You are not the first person to ask for the ability to capture the whole form. So i just went and passed the idea to the product team. powerusers.microsoft.com/t5/PowerApps-Ideas/Capture-the-whole-screen/idi-p/93376#M4091 Please go to the site and vote for it and add your information.
As for mulit approval. It is very do able but I haven't made a video on it yet. Sorry.
@@ShanesCows Thank you so much for your videos! I would like to know if it is possible to combine screens to make a continuos form to feed a database and the last screen to send the consent form to an email
Awesome... Man, you are great...Can we have more form related videos with new features
Sure. Specific examples? Thanks
Hello Shane, your videos are really good, I tried this app and it really gives us the better comprehension of the functions, but the function of sending emails is not working in my app, the message says, “invocation of unknown or unsupported function. How can I fix it? Thank you
Post a new comment with the formula that is causing the error.
Shane Young , thank you I solved the error, actually I don’t know where was the problem but a i fixed, now I’m having problema with sending email with attachments here is the formula
Office365Outlook.SendEmailV2("myemail@hotmail.com", "here is the file", "Body goes here",{Attachments: AddColumns(RenameColumns( AttachmentControl.Attachments, "value","ContentBytes", "@odata.type",""))})
Some errors apear:
The function ‘send email v2’ has invalid arguments.
Invalid argument type. Expecting a table, but of a different schema.
Missing column. Your formula is missing a column ‘content bytes’ with a type of ‘blob’.
Invalid number of arguments: received 1, expects 3 or more
Hi Shane, you have done great job by doing these videos. It is very informative. Thank you very much. I have one doubt here, at the end you wrote a formula for sending email. I am not clear on that , can you please explain that one in detail
Maybe this video will help. th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
Shane Young I tried to use below formula which was explained in consent form video I am not sure where it could be wrong
office365.SendEmail("sss@alwalsss.onmicrosoft.com","My Subject text","Body Text",{attachments:Table("Name:"Peninput.jpg",ContentBytes:Signature.Image,'@odata.type':""}}})
On the other hand I will watch another video which you shared now about sending email using PowerApp
Great tutorial Shane, can you show how to embed (base64 format) pen input signature in HTML email body instead of attachment? Is it possible to make with powerapps and flow.? Thanks
Hi Gerry - Long story short, I don't think it is right now. :( You could maybe make something that emails the input and then have flow grab the attachment and put it HTML. Sorry, I haven't found a lot of great solutions here yet.
I love your tutorials! I have a question. I’m trying to put a pen input on the pop up, but it’s showing under the pop up too. How do I fix that?
Right click on the control and chose bring to front
Hi Shane, is there a way to attach the peninput into email body instead of attachment ?
This video th-cam.com/video/RFZfvTuDmP0/w-d-xo.html
First these videos have been so helpful. I am teaching myself PowerApps (and I am not a developer) so it has been extremely helpful! I am trying to create an inspection form that is comprised of about 5 sections with at least 4 questions in each. The answers are Yes/No/NA... I am stumped as to how to design this? I also want to use Conditional Formatting to only see the questions for that section based on a Yes or No response. Also, can I have the results in a PDF or Word file? (Saved in OneDrive or SharePoint)
All possible. 😀 Look for video on conditional formatting
Could the signature be made to the SharePoint attachment field without the AzureBlobStorage?
My IT doesn't want to provide me with the storage name nor the key values needed to establish the AzureBlob connection... 😡
(Currently, I'm sending the user to a form with the attachment control to add files to the sharepoint item, submitting the form, sending them back to the screen with the gallery... something more elegant is what I'm looking for... )
I covered this in my latest video where I answer comments and yours was one of them. 😀 th-cam.com/video/8eoaSsXnh6Q/w-d-xo.html
Hi Shane, Your videos are fantastic and are so easy to follow. Thank you so much.
Sorry if I have missed a video on this topic but I have a question about being able to Filter a PowerApp BrowseGallery by a Status field. Example: I have a Sharepoint Online task list which assigns all actions to one person. I would like that person on opening Powerapps to only see items in the gallery where the Status Column (drop-down) is equal to In Progress. (i.e. actions that he needs to complete)
Any help would be gratefully appreciated.
You would use Filter(DataSource, Status.Value = "In Progress") This vidoe may help th-cam.com/video/nlhWQg03TL0/w-d-xo.html
I have built my app (with the help of many of Shane's videos). But now I'm stuck. It is pretty much a data collection form. I want to send it to someone via email, they complete it and the info populates back into my list. How do I send this form to people? I don't want them to have access to anything - just for them to complete the form.
I replied to your other comment. 😀
These are awesome and so helpful!
Thanks !
hi shane, do you know how to require to write at the signature before the button is going to enable?
Very very very helpfun man. THANK YOU
Glad to help. 😀
Great video. Do you know how you might create a draft email instead of sending an email, so a user could manually review the email before sending?
Launch(“mailto:shane @powerapps911.com”) would open an email to me. From there you just need the syntax for adding subject and body.
I know this is an old post but maybe somebdoy can help me. The formula If(IsMatch(Emailadress.......) keep given Parenclose error . I did exactly the same as in the video so no idea whats wrong
You can put this in a Label and you will see No. If(IsMatch("shane@powerapps911.c", Email), "Yes", "No")
@@ShanesCows Hi Shane, this doesn't work... Maybe some functions changed since you published this video.
@@mosebiondi I found that this works. If(IsMatch(EmailAddress.Text,Match.Email)=false,Color.Red,Color.Black)
Shane, I really appreciate your work, I follow all your videos and you have been a great help. I was wondering if you are able to submit Pen Input ( create pen input as image and send it to a SharePoint path)? rather than email?
Not easily. Might be easier to send it as an email and then have Flow move it.
Is it also possible to put that signature photo into an email -but- as picture insert into it - instead of attachment. I am trying to do something like this but will need it to generate actual letter (with text like "Dear A I blah blah Sincerely B & Signature )
I made this just for you th-cam.com/video/bIne3DD3HAg/w-d-xo.html 😉
@@ShanesCows thank you so much!
Hello Shane, awesome video! thanks for all this tips! I want to create a PDF file out of the information on the form and email it with the signature included. Is it possible? Do you have videos that cover something similar to what I would like to do? Thanks!
Two videos on making PDF. th-cam.com/video/2rfAQe1kK8M/w-d-xo.html and th-cam.com/video/bfXV_GXc_JM/w-d-xo.html Watch them in that order.
Shane, I have a student leavers List and i want generate Leavers form based of the list and email to these students with the attached PDF (Leavers Form with data from the excel list) who are leaving, Is this possible to achieve using powerapps?
Maybe something like this will help th-cam.com/video/2rfAQe1kK8M/w-d-xo.html where you can make the PDF dynamically?
great tutorial Shane.
i followed up all the steps, but i faced the following:
i wanted to add a toggle button and a date picker, i got them into the window, but as the screen in my case has many cards so i have to scroll down and up to get to all the card and it's then when things misses up, the toggle button and the date picker stay in the same position and won't scroll with the cards, is there a way to get them into the card so they we will follow the form when scrolling ?
one more thing, can i link a button with "send SMS"
thank you again.
Dara I cover that exact problem in a different video. I am pretty sure it is this one. PowerApps Custom Forms to look more like InfoPath th-cam.com/video/5vVFgaEBYuM/w-d-xo.html if that doesn’t help let me know.
Thank you Shane, the problem is solved.
Moving forwards i got the following issues:
1-) i want to link a card with a datepicker and another card to a toggle, i mean that a card to be filled and to get the results from the datepicker, and the other card to get the value from a toggle, for example (when the toggle is "Yes", so the card will be filled as Yes), i managed to get the results from a datepicker into a card but still the format of the date is not the same, (datepicker is dd/mm/yyyy) but the card is getting (m/d/yyyy), the same with the toggle, i'm getting (false/true) while i'd like it to be filled with (Yes/No) instead.
2-) is there a way to add a button to act like "send SMS" (for example send a card that will tell the customer that the work is done , as an SMS).
thank you in advance
This was so helpful! Would a form like this be able to submit the information to a SharePoint List rather than an e-mail? I much prefer creating my forms this way, instead of connecting to a SharePoint data source right off the bat.
The form yes. The pen input to SharePoint isn’t as easy. 😐
When you use if condition for slider, which is control datatype it isn't showing error for u but when I am doing the same it gives out error as this datatype is unsupported for evaluation.
Slider.Value maybe?
Hello Shane, Love your channel, you are helping me a lot!! Thank you!
I have a question for you, did you try to put the image from the PenInput in a pdf? Because, I'm having a concern form that it has to be in a PDF but also need the concern firm, so... I'm trying to out the penintup image in the pdf but it isn't working. Can you help me? I will appreciate!
Thanks.
I haven't put a pen input into a PDF but I am certain it is possible, just might not be easy. Concentrate on getting it stored in SharePoint or OneDrive then you can follow my instructions for taking an image from there and putting it in PDF.
Shane, please teach step-by-step how to filter a Galerry using a DatePicker!
Interesting. Is something not working? I haven't tried before but seems straightforward. I will add it to my list.
Yeah it is working, My problem was only on the TimeZone Date format that was giving the wrong date and another things...but it is working, if you add in some videos in the future, dont forget to talk about the Date format in PowerApps that is differente from excel..i wasnt the only one with this problem :p
2yrs ago video and I'm still benefiting from this. Thanks so much. I need your twitter handle pls.
@shanescows
Very nice video ! Good explanations ! Top ! top ! top ! :-)
Thanks 😊
the handlefill i tried it out with the same formula but mine didn't work, what should I do
Not sure why it didn’t work
Great tutorial! I have a problem with the function "Reset" at the second when I input, after the first Reset that works correcly, when I input semicolon there is a message "unexpected token" the same with comma, so I can only one reset, very strange?? Thanks. Gianni
That doesn’t sound right. Paste I. The exact formula you are using and I will help you figure it out.
Thank you very much for you answer. If I input: Reset(Age) or Reset(EmailAddress) or Reset(Name) it works correctly, if I try to input: Reset(Name);Reset(Age) or Reset(Name),Reset(Age) it doesn't work the error message is "Token imprevisto" that means unexpected token. Greatings Gianni
And Reset is the name of your fields? :(
That just doesn't make sense. :( hmmm
No It doesn't the fields are Age - EmaiAddress - Name , Reset works with every single field but I can't Reset more than one field! After the first Reset if I input semicolon or comma the funcion Reset doen,t appear in the toolbar!!! May I send you a screenshot? Greatings Gianni
Of course. Shane at PowerApps911.com
Hello Shane, Thanks for the tutorial ! I would like to save the form (and the signature) to a SharePoint list, could you help/advice me ?
This is a popular question. I haven't gone down that road yet. :( I would check out the community forums there are several different ideas out there for sure how to do it. Like this. powerusers.microsoft.com/t5/General-Discussion/Pen-input-save-image-to-SharePoint/m-p/81575#M31657
Thank you I'm going to explore that way!
I would love to hear back on what you come up with if anything.
Is possible to save the pen input on the attatch column on SP list?
I haven't tried but I am guessing no. :(
Could Power Automate been used to send the email?
Yes. Send the image base64 to power automate. kind of like this video th-cam.com/video/BUUCATSKNK0/w-d-xo.html
Great Videos, learning a lot, thanks. What did you use for recording these videos?
Thank you. I use Camtasia from TechSmith www.techsmith.com/video-editor.html for all of my recordings and producing.
Can I capture signature through Wacom Signature Pad? Did you integrated SDK with your APP?
Not sure. 😑
Hey Shane, and how do i send in the body of the email the rest of the information on the form?,
Try out this video for sending emails with PowerApps th-cam.com/video/bF7WkqtxKB0/w-d-xo.html
You would reference the controls the same way you would in the label. "This is my dropdown: " & Dropdown1.Selected.Value for example.
Working my way through these, but gah! Its such a shame he didn't want the data output to azure or excel because outputting barcode data to excel is exactly what I am trying to do at the moment. I am sure I'll see you do it soon enough.
simple & brilliant ..
Thank you! Cheers!
love from India..
Appreciate it 🐶
This works perfectly for me except the files that are sent to my email are completely black with no signatures? any idea why the jpg files are blank?
Not sure. Blank files usually means typo in the formula. 😑
Great Job. Thank you for the great tutorials. Please I want to create a memo template with 3 signatures. the fields are From,To,Cc,Re,Date,and three signatures including their comment and sign date.Creator sign,flow send it to manager to and finally to ceo to sign can you please help me ? Thanks a million.
You have the pieces now just try to do each piece in baby steps. You got this. 👍
@@ShanesCows Thank you. You're indeed God sent.
When creating a form, can you make it where you can share the app outside of your organization? Also, can you create a screen where you are communicating back and forth with someone within the app, and it displays all communication on the app?
Hi Carla - Right now PowerApps apps cannot be shared outside your org or made anonymous. It just isn't how they are built today. Maybe in the future. :) Real-time chat? I haven't tried. Maybe if you did something with a timer and autorefresh you could come up with a solution. Maybe.
Does this way of sending the attachment still work?
I did the same and it gives an error, an email comes to my inbox saying that it is not possible to deliver
I think so. I did do another video on this topic that might help th-cam.com/video/RFZfvTuDmP0/w-d-xo.html and also this one th-cam.com/video/bIne3DD3HAg/w-d-xo.html about Base64 covers the Pen Input.
@@ShanesCows You are the best Shane .... Thanks
Great Video Shane! but did you miss out how you setup greying out the consent form? as I can't find that bit :( and would be great if you could PDF the consent form and then email it!? :D
Shane, I get error, maybe because this doesn't work on the newest version of powerapps:
Office365.SendMail("kmistry@babooks.onmicrosoft.com","My Subject Text", "Body Text", {Attachments:Table({Name:"peninput.jpg", ContentBytes:Signature.Image, '@odata.type':""})})
I get error: Invocation of unknown or unsupported function
Mail has changed a bit. Try this video to get the new overview th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
Will this save the name and email address in excel file?
You have them so yes you can save them. Maybe use Patch.
Can you CC someone in the email or send it to multiple users?
Yes. Separate the emails with a comma. There is also an option for CC type { and you should see it.
hello sir, i have put similar command as you have shown in this video... but it is showing error
Office365.SendEmail("xxx.abc.com","My Subject Text", "My Body Text " & txt_userName.Text,{Attachments:Table({Name:"penInput.jpg",ContentBytes:pen_Signature.Image , '@odata.type':""})})
am i doing something wrong?
That looks right. The error should give your more details on what part is wrong hopefully
@@ShanesCows thanks sir... got the error reason... u r awesome
helpful video but you mentioned that this information could be saved to an excel file, how do you do that?! thanks!
Excel isn’t a good data source so I never made that video. Sorry. Check out my content on Azure Blob Storage. That is my recommendation
--- "Alright, there we go, we've got a form yeay!!" haha good one mate
Thanks 🙏
Can we connect to gmail as well?
There is a gmail connector for Power Apps
i cant connect with my sharepoint datasoure .and i want to know write in buttom commend line
Shane, Great Tutorial! Really like the jump in *WAIT* that was my exact mistake yesterday. Created whole project and left for the night to see that my session expired this morning. I have utilized all of your steps but would like to add 2 signature lines. It would be great to keep it all within one button command, but everyway I modify it seems to end in unexpected token or expected ParenClose. This is as close as I have come:,Attachments:Table({Name:"peninput1.jpg",ContentBytes:Signature1.Image,'@odata.type':""}),Attachments1:Table({Name:"peninput2.image",ContentBytes:Signature2.Image,'@odata.type':""})
Any Suggestions would be greatly appreciated.
Hey Tony. We had this exact conversation in the forums. Is this you also? If not good news the answer is there. :) powerusers.microsoft.com/t5/General-Discussion/Send-an-image-from-pen-input-via-email/m-p/83740#M32260
Thank you Shane, ViveKB was a great help. My first power app works perfectly, on to the next one. :)
I am strugling with email send button, Where can I get formula/codes please?
Here is a whole video on just sending emails. Maybe it will help. th-cam.com/video/bF7WkqtxKB0/w-d-xo.html
Seem to have an issue with using ContentBytes comes up as invalid
That is far as I got in capturing sigs in forms.
I haven’t figured out how to capture the form itself with the signature embedded, which I have a requirement for, and as such, I’m still pushing out DoForms instead of PowerApps for quite a few.
I hate deploying something I’m trying to kill off. Lol. But business folks got me so busy with PowerBI I don’t have a lot of time to dig in more on PowerApps. Anyone have a duplicator that works on humans?
I will go digging and see what I can find. I got your back.
Took me a while but since someone else also asked for this I went and put in a request. You can go upvote it and add your 2 pennies. powerusers.microsoft.com/t5/PowerApps-Ideas/Capture-the-whole-screen/idi-p/93376 PS it took me 10 minutes to figure out where you had mentioned this. :)
Hey, thanks for this help ! But it doesn't work for me. I sended an email with an image, but a white jpg. Any ideas? ^^
Thanks for help.
Ok, it seems to only work with my phone ^^ sorry
Glad you got it.
I got an error on the consent button "The server returned an HTTP error with code 0". I didn't get this from the last video on email
Between you and me I think PowerApps are broken. I am getting a similar error when trying to build an app. :( I need to pick up my kids. Hope it is fixed by the time I get back. powerusers.microsoft.com/t5/General-Discussion/Before-anyone-posts-All-connections-seem-to-be-down-let-s-wait/m-p/97450#M36160
perfect lecture.
Thank you. 😎
what if you trying to attach a form?
I haven’t done that before. Sorry
Is the built-in email adress verification editable? i'd like to alter it to be able to detect fake email adresses such as @sharklasers.com / @pokemail.net etc. (all from guerrillamail)
You would have to add logic to do that. Sorry
Thank you so much
Welcome
It's showing error for writing age
Check your data type. If Age is a number then make sure you are passing a number, not text.