Write Multiple Attachment with airSlate SignNow

Write multiple attachment

and today show you one about power apps email attachments that's right attachments with an S I realize we've covered emails before we've covered attachments before but we've never covered sending multiple so we're gonna take several pictures of our camera and we're going to bundle those up and send out one email with multiple attachments sort of those a little trickier than it sounded like it should be but the good news is is once you see how it works it opens up the dorsum other possibilities but first here's our intro hi my name is Shane young with power ups 9 1 1 those guys in today's show we're going to talk about power apps and emailing attachments so it turns out that when you send attachments via email you have a table and normally we just kind of make that table on the fly but in this example that was brought to us thanks to some questions by Anna we were able to actually make that table ahead of time and then just send that out so giving us a little more flexibility around how we might send out attachments so we're gonna look at how to send you know a photo how does have incremental names ha delete stuff out of that before we send it so just a couple of good new little tip to know you might not need to apply today but I think it's several different little concepts bundle up into a nice solution and good things for you to have going forward so let's just get started so jump over here my desktop will go to apps and then we will say create an app and so after a couple seconds here I'm going to choose the tablet layout because that's what I always like to demo from so there you go hit load W we'll skip out of that and so what's though a camera controlling screen so insert media camera control boom there it is it's trying to figure out what your camera can use and it should be that one it is good deal I say I have two cameras right so you're watching that camera it's using a camera weird alright so anyway you get to double watch me the whole video - I apologize nothing I do about that alright so what we want to do is we want to have a picture right we want to be able to email that so typically what I would do is I come in here first and my camera control and we would say on select right so when you click on the camera what do you want to do we want to collect so grab the picture we're gonna call it camera picks and what we're going to do we're going to just say the picture so we'll do like so picture equals camera one that's their camera control dot photo and we'll close their curly brackets close our parentheses so just like that every time you click on the camera control it will save the camera to the collection or the picture to the collection now you know you could do this with a button right a lot of times if I was actually making that for customer and have a camera you know take picture button I think it's weird you have to press on the camera but we're not worried about that today okay so when we do that so then we want to have a button to send the emails from grab a button here we're gonna say send email and so to send an email we need to add a connector rights for gonna say view data sources add a data source and for me I always use my good friend the outlook data source now if sending an email right we're gonna get into too much of the mechanics of it there's a couple of different videos linked down below that cover how to send an email I've done in great detail so we won't overdo that today but so now we have the data source boom just like that we'll go to send email and we're gonna type in office 365 dot send email and so if that doesn't show up for you right are getting squigglies when you follow that because you didn't know the outlook data source and you could use a different data source but this is the one I know all right so just gonna send this email to me so Shane power I came just put my own email address power apps 9-1-1 calm do a comma what's gonna be the subject sending you pictures it seems like a reasonable subject to me body will say did it work okay right so very simple email there and you can definitely expand upon that you know big thing a lot of people in asking me lately it's like making the body HTML so they want to kind of send a formatted email you can absolutely do that you can also use flow to send emails if you don't depending on what your need is don't worry about that so did another comma here's all right and so this collar everything from this comic afterwards is optional so you do from and CCBC but what we're looking for is attachments so what you're gonna do is you can type in attachments so just like that and so then um we're gonna cut and paste from over here because you do not want watch me tab this next part but I will explain it as soon as I do it so copy that paste that end like this a little bit bigger okay so it says attachments table what do you want to name your attachment one name pick JPEG it seems fair content by byte or content bytes obviously content by bytes messed up and what we're gonna do is really look into camera and we're going to quit helping me and we're going to do the pic right so we're gonna look at the camera picks collection and we're gonna get the first camera picture out of there and then we're going to write we're get the pic for that so that's the stream that's the actual bits and bytes that make up the image so that's going to come out of our collection where we put it in there and the oh data type is nothing okay so if we do that so we hit play we're gonna click on this once what would do it better it won't matter because I didn't actually do that the first time and so we'll say send email you'll see the little ants mark across screen right little dots that looks good I will switch over to my outlook and so just like that there's our pic did it work yay so we sent a single image okay so that worked and but when I was working with Anna she's like hey I don't want to send one image I want to send you know two or three maybe it just kinda depends on how many pictures they want to take for me like oh alright how would I do that so the first thing I thought about was I could do like a for all right so for every image in the collection I could group through and so I would send if there was three pictures I would send three emails that didn't seem like a great idea but it worked my head so that was one option so I thought wait a minute this whole attachment thing is a table a collection as a table right well because that's where we had to pull the first one out of there earlier we couldn't give it all I'm given a specific record because content bytes only wants a single piece of information but it's pulling out a table so what if we can I combine forces and so that was a crazy idea I had that kind of came up with and so what I'm gonna do is someone say all right so right now I'm making a table and making a table look like this I'm gonna grab all that I'm gonna copy that look at Mike over our camera I'm sorry on select I need to make what the email wants so I grab this or just delete there we go over top that and so we're gonna do we got name we're name the file picker JPEG okay and so put contents by bytes well we don't want all this now what we want is we want what's in camera 1 dot photo so look at that so now when we do the collects when you take the picture we're not only capturing the photo like we did before we're all certain capture the name and the OData which is it white white but we still need to capture it because now what we're gonna do I'm kind of like what I'm thinking here and we're gonna take that camera picks collection and pass that to attachments so what we can do here to go over this it's an email and so now instead of this whole make a table on the fly because that's what the table function did for us earlier delete all that out and we're just gonna say attachments equals camera picks oh good I like it so the other thing I do is let's insert a gallery on the screen so vertical gallery it's right on top of everything as always and so then we're going to say there's camera picks got it and so image want to be content by bytes you know title Naima that was reasonable so let's go over here this brought her out now so if I click on my picture yeah look at that we've made some pics now that looks good and so if I click on send email and so then we'll wait a second I'll jump over here and double click on email and so did it work there's my cute little pictures made I'm adorable and you can see though the downside is they all have the same name so that didn't work for Ana either man she's kind of a stickler for things so let's make it better so let's go over here and so where we collect the name so you know there's different options so like if you look at my video like cell autoincrement I talked about how just always one two three four five and so that worked in that case but for hers this was that wasn't me exactly right so we play this into Friday's I might think about five different ways to accomplish this but the one that I her and I said were on that worked the best is we're just gonna make a variable called count count encounter my I'm variable called counter and then every time that we reference the variable we're going to add one to it oh but I got to put curly braces around it or this doesn't work like so anyway so that's to me : there right so what is this gonna do so when you click on the camera button we're gonna create a variable called counter or if it's already there we're going to increment it by 1 so the first time that we 1 2 3 4 you kind of get the idea and so then then what do I collect once I collect camera picks and so for name now we're going to just gonna say you're gonna be pick and then we'll use our concatenate function right to and and counter and so so then now the name will be pick one Jay Penick pay to jpg etc etc so let's try that out let's weigh it play we take some pictures pick one pick to pick 3 very cool so then she said but I wanted to delete those also of course you do I'd only makes sense let users maintain it so I'm gonna get rid of this little icon I don't need it but I'm gonna insert a trash can icon grab this Oh grabbing and so look I made the common mistake what did I do I put it outside my gallery so it doesn't show up for all the items I do this all the time you do this all time ask me why it doesn't work that's why so delete it make sure you're in the gallery now insert your trash can whoop nope I missed again let's try again icons trash oh my goodness power apps you and me are about to fight so it's getting our data card icons fourth times a charm yeah see now it's on all the carts we know we put in the right place happens though so I want you to see me struggle without because it happens to you all the time too and so when you select this I wanted to meet the picture that's there no problem so we're gonna do is we're gonna say remove from on camera picks collection and we're gonna take advantage of galleries are awesome with this item property so just like that vamo whammo so now we hit play I can delete pic - if I say take click another picture that's before then we get pick for right so then we can delete this one and so now we just have picked three or four if we hit send email we're gonna cross our fingers that this works and like two minutes later I know why all the other emails came like instantly and so I tried to hold the air that one that we didn't anyway pick three and four show up so BAM Oh whammo we have now created an app that lets us send multiple images and the real key was that realizing that when we did the collect we wanted to make the table for the attachments right so instead of calling us camera picks we should have called his camera attachments and we just had the correct column names that the attachment functionality wanted and we didn't have to mess with anything over there we don't have to format it or worry about any of that we did all the work here we captured the data so sending the email right this little guy was just as simple as pie so hopefully that helps you guys out right a couple little tricks along the way to make for a better experience so I thought Spri neat thought I'd cheer leave me comments below what do you think of this type of stuff you know is this okay where it's not really this big complicated solution with a bunch of little things that just nuggets to add to the memory banks for a later day in time so alright and as always if you want to work together like in and I did hit me up on power ups nine-one-one right and I hit me up you know an hour later we had her problems all fixed and she was back to building instead of being frustrated so pretty great little option working together and you get to hang out with me who does want to hang out with me so thanks and have a great day hey it's me again if you got a second click the subscribe button that always keeps me making more videos or if you want to work together need some help getting your power apps going hit me up with power apps 9-1-1 always happy to work together or finally if you're always looking for more videos that's probably what it is check out the power ops playlist over here and you know enjoy that alright thanks and have a great day