Thank You so much!! I've spent hours looking for this exact feature and attempted to manipulate Microsoft Flows to do this for me, but you explained how to do it in PowerApps simply in less than 15 minutes! Keep up with the awesome and helpful videos!! :)
One more time, one more time ! , Shane u save my life ! It was my very first time i mailed an attached file this afternoon & i was in big trouble until i saw ur solution ! U r the best !
Still Great to refer back to! I added the email template into a model driven app and displayed it on a contact form. All was well until I notice there wasn't an attachment control. I remembered this video helped me before in the past with Canvas. Thanks as always Shane... We appreciate you! Shawn
Thanks Shane. I was looking for this. I originally had a PowerAutomate flow below it. I was not able to do the attachment part there. This solution is way better.
OMG Thank You Thank You Thank You!! This accomplished exactly what I needed. One suggestion to copy the final formula to the video notes to refer too. I had to pause the video at the right spot to get everything.
There is but it is so ugly I never a made a video on it. YOu need a collection with specific columns but I don't remember exactly which. Start by manually adding somethign and look at what table it makes. Now make a collection that looks like that table. It should work.
Hello Shane, thanks for all the inspiration. When I add the data source and the form, I see a few fields but not the attachment field. Any idea why that is?
Thank you for this great video. I'm wondering if I can attach a specific document from a sharepoint folder? I've tried and succeeded to get documents with a sharepoint connector and use the file's metadata, however I can't find a way to extract the content of file. I like to put the content into the ContentBytes field. Can you give me some hints about this?
Thank you Shane, it was a great video. I really appreciate all your effort and hard work, and I'm learning lots. I have a requirement like this, once you click a button it will collect the attachment in the attachment control and stores it in a collection with other details too and reset the attachment control, imagine it is an invoice. So you have fields like invoice number, date and supplier, etc in addition to the attachment. You can submit multiple invoices at once. Once you click another button I want to send a single email with all the collected attachments. Highly appreciate your help. Thanks in advance.
hi Shane, glad to find your channel, but i have question, this is talk to attach file well that was great, but how to make send email but with picture inside the body message ? any idea ? or videos to talk about it ?
Yes.. This doesn't work now. To make it work in RenameColumns it should now be RenameColumns(AttachmentControl.Attachments,Value,ContentBytes) without double quotes in column names. You no longer need odata Add Column stuff. Happy Coding 🙂
This is covered in this video: th-cam.com/video/gyrU7XljKOw/w-d-xo.html TL:DW drop the Quotation Marks around renamed columns should look like this: {Attachments: RenameColumns(AttachField.Attachments,Value,ContentBytes)}
Hello Shane, Thank you very much for your great videos - I'm a fan of yours. I have a question and maybe I'm not the only one and you could help: I' have a canvas app with Dataverse table. I would like to send the file attachments from the Dataverse table selected in a gallery by email. Do you know a simple way, perhaps without Power Automate? Thank you in advance for your help.
Hello, Shane for all your great videos! Learning a lot! I have one question while doing the send email button showing error, when I want to see the table by selecting AttachmentControl.Attachments showing didn't find any data. It would be great if you can help! TIA always!
Radio.Selected.Value in the body I think is what you are looking for. Basically however you get text out of a radio control you can specify that in the email body.
Hi Shane, as always a great video. Is there a way to attach a file from a SharePoint library with the Office365 connector? I have a flow that creates a CSV file from a gallery and I want this file to be sent through the App as an email attachment, so it would be from the user's mailbox.
@@ShanesCowsAttaching files from a SharePoint library and sending an Email using flow works great. In my case the files to be attached are identified by the record being processed by the Power App and don't require any user action. But now our IT department blocked Power Automate from sending Emails to an external address. This broke my Flow 😞. I discovered that our IT has not blocked the Office365 connector. I am trying to recode my app to send the Email from the App. I can't work out an easy way in Power Apps to convert the SharePoint files to an array that can be attached to the Email. The array of file attachments is being created in the Flow. If I could return that array to Power Apps I could attach it to the Email. However, I don't know how to return an array from Flow to Power Apps. Any suggestions would be appreciated.
Hi Shane, once again Great video as always , but i was looking for something sending multiple (example 2 pdf files) files from SharePoint library, can you suggestion?
Awesome Help Shane. Quick question on this. How could I use the above to also send the fields to a SharePoint list. So end-user fills in power app and adds attachments and clicks send and it emails them but also sends the data and attachments to a list library. I have my app working but the flaw is its flow(power automate) based and the get attachments function fails if nothing attached so might use this method instead. any ideas? Cheers & a great channel. Leo
Great video Shane, I wanted to is it possible like I have a document in gallary and I want to send that document ( pdf, word, ppt etc) as an attachment in the mail
Shane in attachment I used gallery.selected it is showing the file but it is not making the blob file in the table due to which it is showing error so is there a way to do that
Hello Shane, I managed to create a record in a SharePoint list with its attachment with a classic input form. Now I want to send an email for each record in the list with its corresponding body content from the Sharepoint List fields and with its record attachment, I bet this is a very good idea for a new video :), the big question is....how to manipulate files that are added as attachments in a SharePoint list record (files that appear in the attachments column of a sharePoint list record)?
@@ShanesCows I am applying the ForAll function and within it I use Microsoft365Outlook.SendEmailV2, the part where I need to retrieve the attachment----> "{Attachments: First(My_SP_List.Attachments)}" ---> it shows red squiggly underline. I am a bit lost not sure how to fill out the SendEmailV2 function properly 😱
Loved this tip - works great, thanks Shane! I was wondering if you know how to reset the Attachment control to clear it? I've only found how to do it when it is part of a Form, and setting "Reset" to true seems to have no effect. Thanks in advance!
I've been combing through your videos and this seems to be the closest one to the feature I'm attempting. Do you have a video of doing this same thing but the attachments are from a SharePoint document library instead? And as an additional challenge I need to send it with a variable amount of attachments, but always at least 1. I've got a gallery of documents filtered down to exactly what the user will want to attach to the email. If the datasource for the attachments can be DocGallery.AllItems, great; if I need to use the whole filter statement from that galleries items property, also great. I just don't understand how to get the file content out of the SharePoint library connection. There is no Value column to turn into the ContentBytes column that it wants.
Hi Shane, Thanks for all these great videos. I was trying to do it same as you did but when tried to send the email got an error messge: Office365Outlook.SendEmail failed: The managed blob uri is not owned by the current app's BlobManager. Do you have any idea what it could be? Help will be appreciated. Thank you so much.
Thanks, this helped a lot! Question though Shane, now that I have an attachment control (With only 1 max attachment)...I want a check box to tick ✔ if the file attached is .PDF, is this possible?
@@ShanesCows I did try this condition: If(Mid(First(DataCardValue.Attachments.Name, Find(".",First(DataCardValue.Attachments).Name+1,3) = "pdf") && (TextInput.Text = "Yes"), true, false) - no red lines but doesn't seem to work when combined. Do you have a tutorial on this?
This is very informative. Can you explain/make a video to send mail with the attachments that are saved in the common data service table (Dataverse table)? From a power Automate flow
do you do consulting? I am trying to get users to 1. fill out a form or excel document 2. have it automatically take a snip of the excel form send an email each morning to users
Hi Shane, this is awesome and I've been able to build my first PowerApps to help with a paperless dispatch process. I've been searching through your videos (and the internet) and I can't find a way to disable the "Send Email" button until after there is an attachment? I can't work out how to "see" if there is an attachment in the collection. Can you help me?
@@ShanesCows thanks for the quick reply. I was trying th eIsEmpty function without it working. Once you told me i was using the correct method I have now have worked out that I had an action to Reset(AttachementControl) on exit after sending email but it wasn't actually clearing my Collection1. I've changed that to Clear(Collection1) and now the visibility function is working. Thanks for your help!
Do you have a suggestion on how to clear the Collection when using the delete cross that appears after an attachment is complete or alter the display formula to be able to handle that the collection may still have something but it is not visible in the App?
Thanks for you videos - always interesting and useful. Got one question - is there any way to create text file in the app from few text fields and attached it to the email (rather that upload it from PC)?
Thanks for this Shane. You have been the biggest help over the years. One question. I am trying to provide the names of the attachments in my form after it is submitted so when we go back and look in the detail screen it will show each attachment associated with each submission. Currently, it will show what attachments were submitted last on every submission. Is there any way to make the attachment control exclusive to each submission or somehow reset it and to where the data that was submitted becomes static unless edited in the edit screen? Thanks again!
Brilliant again. Thanks Shane. One note when creating the collection could we add the third column then? EG: ClearCollect(CollectAttachments,AttachmentControl.Attachements,{'@odata.type':""})
Hi Shane, i need your help, how can i attached a table with the send function?, i cant find how to attached a collection that i have already in PowerApps
Nice one Shane....could you make the attachments work with other sources? Following your instructions, it worked perfectly with outlook, but tried to send attachment content as bytes to flow and I can only get a string with blob path
Hmm. Maybe but not something I have done. Maybe use a gallery to show them the files and attach the ones they don’t delete from the gallery. Gallery.AllItems is a table. 😎
Really great video, Shane! Will the attachment remain on the control until it is eventually reset? Trying to determine if this method can be used to attach a job aide every time a user sends an email.
Shane this is great!, I build an app for email report and I also have a collection with pictures that I must to attach, for attach these I was using on the argument {Attachments: pictures } but now that I add this Attachment Control I need to use the code for attachments on the argument attachments on the email button {Attachments:AddColumns(RenameColumns(botonadjuntos.Attachments,"Value","ContentBytes"),"@odata.type","") How can I tell to the email button that I have these 2 codes on the attachment argument? Thank you!!
Hi Shane, Great videos, I really appreciate all your effort and hard work, and I'm learning lots. One query I have, at 8mins 35secs you copy and past into a label what the attachment control is expecting. Where did you copy that from as I cannot seem to replicate it? Many thanks.
I had it pre written if I remember right. You can pause the video to get it or a lot of my apps and code is included in the training.powerapps911.com curated library subscription
Thank you for the demo, everything seems to be working with the attachment but it is not sending the current file?? Everytime i click the button, it sends the last record and not the current one that i wish to send. Do you know why this could be?
Hey Shane, I'm Brazilian, thanks for your videos, they've been helping me a lot. I have a doubt. After filling out the form and sending it, configuring the attachment to accept only 1 file, how can I edit this data later, deleting the old attached file with a new one? My powerapps, incredibly, let me delete the old file when I'm going to edit it, but it doesn't allow me to attach another one. How can I solve this?
Hi Shane, I want to do exactly the same thing but the mails need to go from a shared mailbox. And the flow I have created accepts Content Bytes in edm.binary format and not blob. Any suggestions?
Hi Shane. I am very new at all of this. I am following step by step but my form does not have an attachment control. Would you be so kind as to provide some assistance? Thank you!
@share young I need a functionality where i not only be able to attach files , but also able to insert pictures in the email body ? How can i achieve it?
Yes, the way of doing it is the same. I did make an updated email video that might help but this video should work th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
Hey Shane - Do you think Microsoft will eventually close this loophole to get the attachments control? It seems like their intent is to prevent people from using it. Just trying to decide if this is a reliable approach or if I should pursue a more sustainable method.
Can this be done without needing a data source? All I need to do is to be able to send attachments via an email form. I already created the form using two input elements (for Subject and Body), and the SendMailv2 function.
Hi Shane, Just wanted to know that is it possible to send attachments via email from gallery I'm trying to show user a gallery and when user clicks on the arrow in the gallery one should get attachment. is it possible?
I'm trying to follow this but when I try connecting my form to a Sharepoint area, it doesn't come up with the attachment control. It just comes up with other fields and dropdowns related to that particular area. Any help on this?
Awesome! thanks Shane!! I tried to add the logic in Send button: OnSelect- If(IsEmpty(AttachmentControl), DisplayModeDisable, false) ....didn't work though :( what is a better logic which prevents the email from being sent without an attachment?
I'm trying to create a text attachment using the following "ContentBytes" value: { Attachments: Table( { Name: "test.txt", ContentBytes: "data:text/plain;charset=utf-8,This is a test document.", '@odata.type': "" } ) } Unfortunately, I get an "invalid data uri format" error. In theory, this should work. Any thoughts on what the data URI should be for plain text? I have tried multiple variations with no luck. I know this is different than your attachment control option, but I am trying to get PowerApps to create the text content rather than an uploaded file, and I would prefer to skip Flow/Power Automate.
@@ShanesCows Okay, thanks for the reply! If you think of anything or have any ideas on where I could go to find out, I'd love to hear it. I have searched everywhere I can think to look and I am at a loss. And thanks for the great videos!
![[New in PowerApps] The new PDF() function is a gamechanger](/img/n.gif)
Thank You so much!! I've spent hours looking for this exact feature and attempted to manipulate Microsoft Flows to do this for me, but you explained how to do it in PowerApps simply in less than 15 minutes! Keep up with the awesome and helpful videos!! :)
Glad to help. 😀
I was searching all over the web before I find out Shane Young did it way back. You are life savior. Love you Shane!
Thanks 😊
One more time, one more time ! , Shane u save my life ! It was my very first time i mailed an attached file this afternoon & i was in big trouble until i saw ur solution !
U r the best !
Awesome :) Glad to help.
Still Great to refer back to! I added the email template into a model driven app and displayed it on a contact form. All was well until I notice there wasn't an attachment control. I remembered this video helped me before in the past with Canvas. Thanks as always Shane... We appreciate you! Shawn
Nice work! I love when you peole figure out how to combine concepts. Kudos to you!
fantastic! Just getting into sending emails from powerapps and this was simple to understand.
Glad it helped! This video is EVERYTHING email if it will help th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
Wow... didn't know we could do that with the attachment control. Thought it was stuck in forms. Thank you Shane once again!!
Yup. More to come on this trick. 😁
Thanks Shane. I was looking for this. I originally had a PowerAutomate flow below it. I was not able to do the attachment part there. This solution is way better.
As usually, your video is so simple but goes straight to the problem..... Thank you for your work :-)
You are welcome 🙏
You keep saving my bacon with this videos. Thank you much for all you do.
Glad to help. 😀 #BaconLover
This is great! Answered all of my questions. Couldn't find this information anywhere else. Thanks!
As Always a very helpful video, Thanks Shane!
My pleasure!
OMG Thank You Thank You Thank You!! This accomplished exactly what I needed. One suggestion to copy the final formula to the video notes to refer too. I had to pause the video at the right spot to get everything.
Glad it help Tim. On training.powerapps911.com there is a curated library option that lets you watch ad free and download apps and code snippets. 😀
Sir, thanks for the great instructional video. finally learned how to insert an attachment! !
Awesome 👏
Thank you so much Shane! For every prob I find the answer in your awesome videos.
Happy to help. Have a great day. 🐶
Fantastic! I didn’t know we could borrow the attachment control like that. I will use this in the future for sure! Thanks Shane!
Yup. And I have another video in the hopper showing another trick with it. 😉
@@ShanesCows looking forward to it.
@@ShanesCows have you ever considered streaming a live q&a session?
Very interesting videos, helped me a lot, keep on with the good work Shane!
Glad to help. 😀
Very nice video... Love your out of the box thinking. Thank you so much.
Glad to help. 😀
Thank you Shane. Please keep it doing this.
As long as people like you keep watching I will keep making them.
thank you, Shane your videos always helped me, I have a question - is there a way to add default attachments to attachment control?
There is but it is so ugly I never a made a video on it. YOu need a collection with specific columns but I don't remember exactly which. Start by manually adding somethign and look at what table it makes. Now make a collection that looks like that table. It should work.
This is really great! Love your videos, so helpful!!!
Glad to help. 😀
Loved your video!!! So great. Congrats and Thank you very much!
Hi there, it is not giving me the option for "AttachmentControl" Any ideas?
jump to 12:08 shane's happy dance. thank you so much. this is exactly what i need for our app!!!
Hello Shane, thanks for all the inspiration. When I add the data source and the form, I see a few fields but not the attachment field. Any idea why that is?
Are you adding a SharePoint list as the data source. Other data source may or may not have an attachment field. SharePoint list always does. 😊
Excellent Video - Easy to follow and very informative - Thank you
Thank you for this great video. I'm wondering if I can attach a specific document from a sharepoint folder? I've tried and succeeded to get documents with a sharepoint connector and use the file's metadata, however I can't find a way to extract the content of file. I like to put the content into the ContentBytes field. Can you give me some hints about this?
Perfect Video! Thank you for your help. Best regards from Hamburg (Germany).
Danke (hope I did that correctly)
Thank you Shane, it was a great video. I really appreciate all your effort and hard work, and I'm learning lots. I have a requirement like this, once you click a button it will collect the attachment in the attachment control and stores it in a collection with other details too and reset the attachment control, imagine it is an invoice. So you have fields like invoice number, date and supplier, etc in addition to the attachment. You can submit multiple invoices at once. Once you click another button I want to send a single email with all the collected attachments. Highly appreciate your help. Thanks in advance.
Thanks for sharing, you just save me a lot of time!
Glad to help. 😀
Thank you! This is exactly what I needed!
Hi Shane. Great video (again). 👍👍👍👍
Hey, thanks!
You Just shown me what exactly I'm looking for. Thanks mate. you r a genius. :)
No worries
hi Shane, glad to find your channel, but i have question, this is talk to attach file well that was great, but how to make send email but with picture inside the body message ? any idea ? or videos to talk about it ?
this method does not work anymore @shane. Did powerapps change something, I used the exact same formula but there is an error
Yes.. This doesn't work now. To make it work in RenameColumns it should now be RenameColumns(AttachmentControl.Attachments,Value,ContentBytes) without double quotes in column names. You no longer need odata Add Column stuff. Happy Coding 🙂
This is covered in this video: th-cam.com/video/gyrU7XljKOw/w-d-xo.html
TL:DW drop the Quotation Marks around renamed columns should look like this: {Attachments: RenameColumns(AttachField.Attachments,Value,ContentBytes)}
Thank you again @shane you are the best sir!
Hi Shane,
Another great video.
Is there anyway to select pictures which are sitting in a SharePoint doc library to add as attachment?
Not really unless maybe Explorer was mapped already to the library
Hello Shane,
Thank you very much for your great videos - I'm a fan of yours.
I have a question and maybe I'm not the only one and you could help:
I' have a canvas app with Dataverse table.
I would like to send the file attachments from the Dataverse table selected in a gallery by email.
Do you know a simple way, perhaps without Power Automate?
Thank you in advance for your help.
Hi I have the same question. It would be great if Shane teaches us that :)
Hello, Shane for all your great videos! Learning a lot! I have one question while doing the send email button showing error, when I want to see the table by selecting AttachmentControl.Attachments showing didn't find any data.
It would be great if you can help!
TIA always!
Not sure. Did you not attach anything?
Dude, you're my hero.
Happy to help
*you're - but I agree, thanks a lot!
You are amazing! One question, how do I email the Item values of a radio button? Thank you!
Radio.Selected.Value in the body I think is what you are looking for. Basically however you get text out of a radio control you can specify that in the email body.
Hi Shane, as always a great video.
Is there a way to attach a file from a SharePoint library with the Office365 connector? I have a flow that creates a CSV file from a gallery and I want this file to be sent through the App as an email attachment, so it would be from the user's mailbox.
Probably easiest to do in a flow triggered by the Power App. Get File in flow then add that as an attachment.
@@ShanesCowsAttaching files from a SharePoint library and sending an Email using flow works great. In my case the files to be attached are identified by the record being processed by the Power App and don't require any user action. But now our IT department blocked Power Automate from sending Emails to an external address. This broke my Flow 😞.
I discovered that our IT has not blocked the Office365 connector. I am trying to recode my app to send the Email from the App. I can't work out an easy way in Power Apps to convert the SharePoint files to an array that can be attached to the Email.
The array of file attachments is being created in the Flow. If I could return that array to Power Apps I could attach it to the Email. However, I don't know how to return an array from Flow to Power Apps.
Any suggestions would be appreciated.
Thanks for your video, very helpful ,
How do you include form content as part of the attachment please
Hi Shane, once again Great video as always , but i was looking for something sending multiple (example 2 pdf files) files from SharePoint library, can you suggestion?
This video talks about sending multiple attachments th-cam.com/video/V3feURQfY3M/w-d-xo.html
@@ShanesCows but im trying to send the files from sharepoint library :(
Could the attachment control be placed into components for access in the future? Awesome stuff again Shane....I would be lost in Infopath without you!
Haven’t tried that one. Interesting
Awesome Help Shane. Quick question on this. How could I use the above to also send the fields to a SharePoint list. So end-user fills in power app and adds attachments and clicks send and it emails them but also sends the data and attachments to a list library. I have my app working but the flaw is its flow(power automate) based and the get attachments function fails if nothing attached so might use this method instead. any ideas?
Cheers & a great channel.
Leo
You could Patch the SharePoint list and then ; and then send the email.
@@ShanesCows Cheers Shane. That I shall do.
Great video Shane, I wanted to is it possible like I have a document in gallary and I want to send that document ( pdf, word, ppt etc) as an attachment in the mail
Yes. You will need to recreate the same table structure but use your Gallery.Selected record to get the file.
@@ShanesCows Actually I did that but when I'm applying that in the attachment it is showing error
Shane in attachment I used gallery.selected it is showing the file but it is not making the blob file in the table due to which it is showing error so is there a way to do that
What I have did like there is a share button on every item and when I click on it that file will be put in the attachment part
Hello Shane, I managed to create a record in a SharePoint list with its attachment with a classic input form. Now I want to send an email for each record in the list with its corresponding body content from the Sharepoint List fields and with its record attachment, I bet this is a very good idea for a new video :), the big question is....how to manipulate files that are added as attachments in a SharePoint list record (files that appear in the attachments column of a sharePoint list record)?
The attachments column in SharePoint is a table. First(Attachments). Will show you the columns and let you explore. Knowing it is a table is key. 😁
@@ShanesCows Thks Shane for answering!
@@ShanesCows I am applying the ForAll function and within it I use Microsoft365Outlook.SendEmailV2, the part where I need to retrieve the attachment----> "{Attachments: First(My_SP_List.Attachments)}" ---> it shows red squiggly underline. I am a bit lost not sure how to fill out the SendEmailV2 function properly 😱
Loved this tip - works great, thanks Shane!
I was wondering if you know how to reset the Attachment control to clear it?
I've only found how to do it when it is part of a Form, and setting "Reset" to true seems to have no effect.
Thanks in advance!
Reset(attachmentcontrol) should work
@@ShanesCows and it did! Thanks very much Shane!
I've been combing through your videos and this seems to be the closest one to the feature I'm attempting. Do you have a video of doing this same thing but the attachments are from a SharePoint document library instead? And as an additional challenge I need to send it with a variable amount of attachments, but always at least 1.
I've got a gallery of documents filtered down to exactly what the user will want to attach to the email. If the datasource for the attachments can be DocGallery.AllItems, great; if I need to use the whole filter statement from that galleries items property, also great. I just don't understand how to get the file content out of the SharePoint library connection. There is no Value column to turn into the ContentBytes column that it wants.
Shane.... Dankjewel.... (Thank you in Dutch) Netherlands.... My next challenge is to get the outlook signature underneath.... Stay Safe!
Thanks and good luck 😎
Hi Shane, Thanks for all these great videos.
I was trying to do it same as you did but when tried to send the email got an error messge: Office365Outlook.SendEmail failed: The managed blob uri is not owned by the current app's BlobManager. Do you have any idea what it could be? Help will be appreciated. Thank you so much.
Not sure. Haven’t seen that error.
Hey there, I'm getting a similar error. You haven't happened to figure out a solution yet, have you?
I'm getting the same error. Any solutions yet?
Same for me...any solution yet?
Thanks, this helped a lot! Question though Shane, now that I have an attachment control (With only 1 max attachment)...I want a check box to tick ✔ if the file attached is .PDF, is this possible?
Yes. You add the control and then you need to write logic to react to the checkbox values that you want.
@@ShanesCows I did try this condition: If(Mid(First(DataCardValue.Attachments.Name, Find(".",First(DataCardValue.Attachments).Name+1,3) = "pdf") && (TextInput.Text = "Yes"), true, false) - no red lines but doesn't seem to work when combined. Do you have a tutorial on this?
This is very informative.
Can you explain/make a video to send mail with the attachments that are saved in the common data service table (Dataverse table)?
From a power Automate flow
Shane, first thanks for the workaround. One question: Do you know what is the maximum size capacity of the files?
The power apps doc mentions a 10 MB file size limit. per file
Thank Chris. I was also going to guess 10
The maximum size capacity of files is 10MB.
Hello Shane,
Can we attach a file from sharepoint document library?
Not from the windows explorer...
Maybe but I have never tried.
You are awesome.👍👍
Thanks. You rock!
Amazing as always!
Thank you! Cheers!
Is it recommended to Patent a Power Apps program I created?
Not that I know of but I am far from an expert on IP law. :)
wow your amazing
thank you so much!!
Glad to help. 😀
do you do consulting? I am trying to get users to 1. fill out a form or excel document 2. have it automatically take a snip of the excel form send an email each morning to users
Yes. 🐶 www.PowerApps911.com and fill out the contact form. Thanks
Hi Shane, this is awesome and I've been able to build my first PowerApps to help with a paperless dispatch process. I've been searching through your videos (and the internet) and I can't find a way to disable the "Send Email" button until after there is an attachment? I can't work out how to "see" if there is an attachment in the collection. Can you help me?
You need to check if the attachment collect IsEmpty and then set the buttons display mode accordingly
@@ShanesCows thanks for the quick reply. I was trying th eIsEmpty function without it working. Once you told me i was using the correct method I have now have worked out that I had an action to Reset(AttachementControl) on exit after sending email but it wasn't actually clearing my Collection1. I've changed that to Clear(Collection1) and now the visibility function is working. Thanks for your help!
Do you have a suggestion on how to clear the Collection when using the delete cross that appears after an attachment is complete or alter the display formula to be able to handle that the collection may still have something but it is not visible in the App?
Thanks for you videos - always interesting and useful.
Got one question - is there any way to create text file in the app from few text fields and attached it to the email (rather that upload it from PC)?
Not that I know of but maybe you could get creative by using Flow to make a file. Not sure
Thanks for this Shane. You have been the biggest help over the years. One question. I am trying to provide the names of the attachments in my form after it is submitted so when we go back and look in the detail screen it will show each attachment associated with each submission. Currently, it will show what attachments were submitted last on every submission. Is there any way to make the attachment control exclusive to each submission or somehow reset it and to where the data that was submitted becomes static unless edited in the edit screen? Thanks again!
Brilliant again. Thanks Shane. One note when creating the collection could we add the third column then? EG: ClearCollect(CollectAttachments,AttachmentControl.Attachements,{'@odata.type':""})
You can but I don’t think it was required? I can’t remember now.
Hi Shane, i need your help, how can i attached a table with the send function?, i cant find how to attached a collection that i have already in PowerApps
I think you need this video th-cam.com/video/V3feURQfY3M/w-d-xo.html
Nice one Shane....could you make the attachments work with other sources? Following your instructions, it worked perfectly with outlook, but tried to send attachment content as bytes to flow and I can only get a string with blob path
Interesting. I will have to think about that one.
By the way, the behaviour happens with SharePoint library
Is there a way to set a default list of files in the control that a user would just delete the items they didn't want?
Hmm. Maybe but not something I have done. Maybe use a gallery to show them the files and attach the ones they don’t delete from the gallery. Gallery.AllItems is a table. 😎
@@ShanesCows I'll try it and report back! Thanks.
Really great video, Shane! Will the attachment remain on the control until it is eventually reset? Trying to determine if this method can be used to attach a job aide every time a user sends an email.
Shane this is great!, I build an app for email report and I also have a collection with pictures that I must to attach, for attach these I was using on the argument {Attachments: pictures } but now that I add this Attachment Control I need to use the code for attachments on the argument attachments on the email button {Attachments:AddColumns(RenameColumns(botonadjuntos.Attachments,"Value","ContentBytes"),"@odata.type","")
How can I tell to the email button that I have these 2 codes on the attachment argument?
Thank you!!
Sorry Felipe I haven’t tried that scenario yet. Boo me
@@ShanesCows is all good!! I have sorted it out finally 😁👍
Hi Shane, Great videos, I really appreciate all your effort and hard work, and I'm learning lots. One query I have, at 8mins 35secs you copy and past into a label what the attachment control is expecting. Where did you copy that from as I cannot seem to replicate it? Many thanks.
I had it pre written if I remember right. You can pause the video to get it or a lot of my apps and code is included in the training.powerapps911.com curated library subscription
Thank you for the demo, everything seems to be working with the attachment but it is not sending the current file?? Everytime i click the button, it sends the last record and not the current one that i wish to send. Do you know why this could be?
Hey Shane, I'm Brazilian, thanks for your videos, they've been helping me a lot. I have a doubt. After filling out the form and sending it, configuring the attachment to accept only 1 file, how can I edit this data later, deleting the old attached file with a new one? My powerapps, incredibly, let me delete the old file when I'm going to edit it, but it doesn't allow me to attach another one. How can I solve this?
Not sure how to help you unravel that. I would try to troubleshoot the not being to add a new one first b
Hi Shane, I want to do exactly the same thing but the mails need to go from a shared mailbox. And the flow I have created accepts Content Bytes in edm.binary format and not blob. Any suggestions?
This video has one idea for using a shared mailbox. th-cam.com/video/l8NJkauGJ7U/w-d-xo.html
You are the man.
Thank you! 🐶
Can you do a video on how to create asana project from a power app from and fill certain columns in Asana. Thanks a lot your videos are so good
I will add it to my list of topics. I haven't done much with Asana though so not sure.
Hi Shane, is there a way to send attachments that are sitting in a document library?
Flow could get and send them for you.
@@ShanesCows ok cool - thanks! any chance you might do a video on this?? :)
Hi Shane. I am very new at all of this. I am following step by step but my form does not have an attachment control. Would you be so kind as to provide some assistance? Thank you!
Attachment control would only come if you have a SharePoint list as the datasource
Wicked !!!
Thanks for sharing, Shane ;)
Happy to
thank you for this work !
Glad to help. 😀
Is there a way to send items in a collection thru an email?
Use Concat to turn them collection into an HTML table and make that the body of hte email.
Thank you !
You are welcome 🙏
Great job, that is really cool!
Glad to help. 😀
Thanks alot Shane!
You are welcome
Hi Shane, i need your help, how can i attached a camera with the EditForm to sharepoint
Not sure you can connect a camera control to a form. Learn more here th-cam.com/video/ovLIwnj6QjU/w-d-xo.html
My attachments are not coming through on the email when I add them via a form instead of a button. Any ideas?
I would look at your Attachments syntax. It should be possible.
Thanks !
You bet!
How to find the size of the attachment ? My scenario is if any blank document is attached ,throw an error message.
Not possible that I know of... hmm
@share young I need a functionality where i not only be able to attach files , but also able to insert pictures in the email body ? How can i achieve it?
th-cam.com/video/RFZfvTuDmP0/w-d-xo.html use this. But where I show pen input change to image. 😀
Does this work anymore? I just tried it, there were no errors, the email sent correctly, but there was no attachment.
Yes, the way of doing it is the same. I did make an updated email video that might help but this video should work th-cam.com/video/vpYkOccwn4Y/w-d-xo.html
Hey Shane - Do you think Microsoft will eventually close this loophole to get the attachments control? It seems like their intent is to prevent people from using it. Just trying to decide if this is a reliable approach or if I should pursue a more sustainable method.
Can this be done without needing a data source? All I need to do is to be able to send attachments via an email form. I already created the form using two input elements (for Subject and Body), and the SendMailv2 function.
If you let the user attach a file it should work. Watch this video just to get the data to the control. th-cam.com/video/Pa-pYEkLH-U/w-d-xo.html
Hi Shane, Just wanted to know that is it possible to send attachments via email from gallery I'm trying to show user a gallery and when user clicks on the arrow in the gallery one should get attachment. is it possible?
Probably but I haven’t tried. Try to grab the file contents from the gallery and see what happens
Quite Insightful!
Thanks 😊
Thank you Shane
Muito bom! Parabéns!
I'm trying to follow this but when I try connecting my form to a Sharepoint area, it doesn't come up with the attachment control. It just comes up with other fields and dropdowns related to that particular area. Any help on this?
Make sure you attach it to a custom list that has attachments? It should be there
Does the AttachmentControl work for empty Attachmentlist? I have this problem, getting an error stating: "Attachments content cannot be NULL"
Probably not. Do an If to see if IsEmpty in your logic
@@ShanesCows Thanks, so basic...yet so powerful
Awesome! thanks Shane!! I tried to add the logic in Send button: OnSelect- If(IsEmpty(AttachmentControl), DisplayModeDisable, false) ....didn't work though :( what is a better logic which prevents the email from being sent without an attachment?
Hi Shane! Hope doing well, how I sent gallery data with image in body of email in tabular format with image resize ( not more then 250 px)?
I'm trying to create a text attachment using the following "ContentBytes" value:
{
Attachments: Table(
{
Name: "test.txt",
ContentBytes: "data:text/plain;charset=utf-8,This is a test document.",
'@odata.type': ""
}
)
}
Unfortunately, I get an "invalid data uri format" error. In theory, this should work. Any thoughts on what the data URI should be for plain text? I have tried multiple variations with no luck.
I know this is different than your attachment control option, but I am trying to get PowerApps to create the text content rather than an uploaded file, and I would prefer to skip Flow/Power Automate.
Kyle I am not sure. I get what you are trying but I have never tried that. I am sure it is an encoding issue but not sure what to tell you. 😑🤔
@@ShanesCows Okay, thanks for the reply! If you think of anything or have any ideas on where I could go to find out, I'd love to hear it. I have searched everywhere I can think to look and I am at a loss. And thanks for the great videos!
How can I do the same function if I would like to run a Flow?
Friggin' GENIUS!!!
Thanks
Excellent !
Thanks 😊