Build a consent form with PowerApps using the Pen Input and send it as an email attachment 

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

Awe shucks. :) Thanks

Awe shucks. You are welcome.

Glad to help. :)

Thanks

This one has what you are looking for ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_NCLeRpot3k.html 😎

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 😀

Love the puppy.

You are very kind. Thanks 😀

This should help ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RFZfvTuDmP0.html

Is Age the name of the control. You may need to do Age.Value

Awesome!

Slider1.Value is the output of a slider. So you could Patch or Collect that into a collection. Try this video for ideas. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html

Not possible. YOu can't use an Excel file hosted in SharePoint as a data source.

Try this video for the concept. PowerApps Email Multiple Attachments ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-V3feURQfY3M.html

That is tough. There isn’t an order per say. 😑 Some build off of old concepts though. I will try to think about this.

I would love to. Wish I had a barcode scanner.

Tooltip I think is what you need.

Not easily. Might be easier to send it as an email and then have Flow move it.

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.

Cool. Love the idea.

Not that I know of. 😑

@@ShanesCows thank you! Shane, for your feedback.

Glad it was helpful!

This video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RFZfvTuDmP0.html

@@ShanesCows thank you, i had already found the video and implemented,

Try this ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RFZfvTuDmP0.html

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.

Muchas gracias, me alegra que te haya sido útil. ¡Un saludo! -ChatGPT helped me write that :)

Glad you like them!

You would use Filter(DataSource, Status.Value = "In Progress") This vidoe may help ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nlhWQg03TL0.html

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

It is just a value that PowerApps expects from you. Not really sure I have ever thought about what it really is. Sorry. :(

All possible. 😀 Look for video on conditional formatting

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

Thanks Cow. My twitter is shanescows so I enjoy a good cow comment. 🐮

Thank you. I use Camtasia from TechSmith www.techsmith.com/video-editor.html for all of my recordings and producing.

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

Maybe this video will help. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vpYkOccwn4Y.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

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

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?

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.

The form yes. The pen input to SharePoint isn’t as easy. 😐

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.

Right click on the control and chose bring to front

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.

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

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.

Launch(“mailto:shane @powerapps911.com”) would open an email to me. From there you just need the syntax for adding subject and body.

I replied to your other comment. 😀

Two videos on making PDF. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2rfAQe1kK8M.html and ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bfXV_GXc_JM.html Watch them in that order.

Thank you. Let me know if you have suggestions for other topics.

Sure. Specific examples? Thanks

Thank you! Cheers!

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.

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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5vVFgaEBYuM.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 video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RFZfvTuDmP0.html

Thanks again!

Glad to help. 😀

I made this just for you ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bIne3DD3HAg.html 😉

@@ShanesCows thank you so much!

Appreciate it 🐶

Maybe something like this will help ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2rfAQe1kK8M.html where you can make the PDF dynamically?

Thanks 🙏

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)

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

I covered this in my latest video where I answer comments and yours was one of them. 😀 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-8eoaSsXnh6Q.html

Thanks 😊

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.

Thanks !

Not sure. 😑

@shanescows

Try out this video for sending emails with PowerApps ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bF7WkqtxKB0.html You would reference the controls the same way you would in the label. "This is my dropdown: " & Dropdown1.Selected.Value for example.

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.

Slider.Value maybe?

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

Thank you. 😎

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.

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

I haven't tried but I am guessing no. :(

Not sure why it didn’t work

Yes. Send the image base64 to power automate. kind of like this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BUUCATSKNK0.html

I think so. I did do another video on this topic that might help ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RFZfvTuDmP0.html and also this one ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bIne3DD3HAg.html about Base64 covers the Pen Input.

@@ShanesCows You are the best Shane .... Thanks

Not sure. Blank files usually means typo in the formula. 😑

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

Yes. Separate the emails with a comma. There is also an option for CC type { and you should see it.

Ok, it seems to only work with my phone ^^ sorry

Glad you got it.

You have them so yes you can save them. Maybe use Patch.

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

Mail has changed a bit. Try this video to get the new overview ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vpYkOccwn4Y.html

Here is a whole video on just sending emails. Maybe it will help. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bF7WkqtxKB0.html

Welcome

You are welcome. 😁

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

There is a gmail connector for Power Apps

😎

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