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!! :)
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
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 !
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.
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?
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?
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 ?
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.
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
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!
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?
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.
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.
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?
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!
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.
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.
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!
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
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.
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, 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?
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 😱
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: ua-cam.com/video/gyrU7XljKOw/v-deo.html TL:DW drop the Quotation Marks around renamed columns should look like this: {Attachments: RenameColumns(AttachField.Attachments,Value,ContentBytes)}
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
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)?
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
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
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
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, 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?
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
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?
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. 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!
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!!
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!
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. 😎
Hi Can you guide how I can send email with attachment from sharedmailbox? not only me but any user should also be able to get report when clicked on button 'Export to Excel'
@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?
Brilliant again. Thanks Shane. One note when creating the collection could we add the third column then? EG: ClearCollect(CollectAttachments,AttachmentControl.Attachements,{'@odata.type':""})
Yes, the way of doing it is the same. I did make an updated email video that might help but this video should work ua-cam.com/video/vpYkOccwn4Y/v-deo.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.
This is really great!! In my scenario Power apps forms attachments send to MS Flow and then MS Flow will add attachments to the SharePoint list item. Can you please help to me how to achieve this. Thanks In advance !!!!
related to attachments, I've managed to re-create the outlook web client (in a way) but with a button to save the selected email to a sharepoint list (whoohoo) but I can't seem to get email attachments to save as list attachments. I can get the email attachments to appear as defaults in the form attachment but I get the error "Field 'id' is required" and if I try to download from the form attachment box it downloads an empty file. I think I need to use the Office365Outlook.GetAttachmentsV2 function but I don't understand how. Anyone have any pointers?
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 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?
Hi Shane! I know this is an older video, but I'm just now trying to attach a file from a Power App form to an email. The data source is a SharePoint list. In a New Item form, there is an attachment control. I can't make the formulas shown in this video work. How do I get it to capture the file name? In your test label, you hard-coded the filename "peninput.jpg". The files that will be attached are usually Excel files. So, how would ContentBytes be written, e.g., "filename".WHAT ? The filenames will always have spaces, so should the filename be surrounded by quotation marks?
This video show the concept. Not exactly what you are asking but if you learn this you can do what you want to do. ua-cam.com/video/RFZfvTuDmP0/v-deo.html
I have attachments coming from SP list and populating in DCV575.Attachments control. It doesn't pull the DOCX created by flow into the control even if I wait 3 minutes and have verified it is in the list item attachments and received the email from Power Automate. Any idea how I can refresh/update/reset the attachment control so I can email the attachments from the signed in user?
Hi Shane. I got this working, but find once I am over 3MB in attachments, it stops working and i get the following error message (even though i have the max attachments size set to 10 Office365.SendEmailV2 failed: { "status": 413, "message": "Request entity is larger than limits defined by the external server. clientRequestId: 30e33ddc-ed26-4614-97ff-5e8d0f0b646b serviceRequestId: a6c6d02a-962d-4969-933e-3aa6f8c8d4e0", "source": "office365-cc.azconn-cc.p.azurewebsites.net" } Any Tips?
This works fine from within PowerApps (create) but when I run it within the Powerapps App it fails (with an error about a blob) every time I add more than 1 image and try to submit them, strange!...any help would be much appreciated
Hi Shane Young, I am using the same as you mentioned. but i am getting error like ""managed blob uri not managed by current app's blog manager" Please suggest me on that
Wondering how to do similar, but instead of sending an email, take those attachments and add them to a document library in sharepoint? (not a list item with attachments) . or as attachments on a MS Planner task?
I've been trying to figure out the same thing...this would be huge for me. Please let me know if you were able to find a connector that would allow you to run from powerapps to a file system folder or sharepoint folder.
Can you make a video shows Monitor application, process or network using powershell, If fail play wave sound or popup a messege plus auto restart the application till problem resolve ? it will help client pc auto reconnect server when server got reboot.
Hi Shane, Awesome Video and viable content which is a life saver for those who are into Powerapps. One question from my side.. I have one requirement where we need to send a Microsoft teams invite with a file attached to it. I have searched the solution in web but could find only one solution where we need to send 2 emails one with teams meeting invite and another with file attached. Is there any other work around for this?... Thanks & Regards Nikhil Jose
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 😊
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!
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.
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 ua-cam.com/video/vpYkOccwn4Y/v-deo.html
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.
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. 😁
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?
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. 😀
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 great! Answered all of my questions. Couldn't find this information anywhere else. Thanks!
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. 😊
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 ?
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,
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
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
Very interesting videos, helped me a lot, keep on with the good work Shane!
Glad to help. 😀
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
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?
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?
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?
Thank you so much Shane! For every prob I find the answer in your awesome videos.
Happy to help. Have a great day. 🐶
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.
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.
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?
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!
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 :)
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.
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!
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 ua-cam.com/video/V3feURQfY3M/v-deo.html
@@ShanesCows but im trying to send the files from sharepoint library :(
Thanks for your video, very helpful ,
How do you include form content as part of the attachment please
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.
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?
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, 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. ua-cam.com/video/l8NJkauGJ7U/v-deo.html
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 😱
Hello Shane,
Can we attach a file from sharepoint document library?
Not from the windows explorer...
Maybe but I have never tried.
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.
Sir, thanks for the great instructional video. finally learned how to insert an attachment! !
Awesome 👏
Thank you Shane. Please keep it doing this.
As long as people like you keep watching I will keep making them.
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: ua-cam.com/video/gyrU7XljKOw/v-deo.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, 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 ua-cam.com/video/V3feURQfY3M/v-deo.html
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
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
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
As Always a very helpful video, Thanks Shane!
My pleasure!
Hi there, it is not giving me the option for "AttachmentControl" Any ideas?
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
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
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
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?
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
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)?
This is really great! Love your videos, so helpful!!!
Glad to help. 😀
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
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. ua-cam.com/video/Pa-pYEkLH-U/v-deo.html
Can I control upload image dimensions limit Prevent to upload more then 300 pixel. Picture or not allowed to upload more then 3 mb
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. 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
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 😁👍
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?
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.
How to send an email and attach a document from the document library? I am having trouble finding the attachment in document library.
jump to 12:08 shane's happy dance. thank you so much. this is exactly what i need for our app!!!
Hi Can you guide how I can send email with attachment from sharedmailbox? not only me but any user should also be able to get report when clicked on button 'Export to Excel'
Very nice video... Love your out of the box thinking. Thank you so much.
Glad to help. 😀
@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?
ua-cam.com/video/RFZfvTuDmP0/v-deo.html use this. But where I show pen input change to image. 😀
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.
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 ua-cam.com/video/vpYkOccwn4Y/v-deo.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.
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 ua-cam.com/video/ovLIwnj6QjU/v-deo.html
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. :)
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?? :)
Loved your video!!! So great. Congrats and Thank you very much!
This is really great!!
In my scenario Power apps forms attachments send to MS Flow and then MS Flow will add attachments to the SharePoint list item. Can you please help to me how to achieve this. Thanks In advance !!!!
related to attachments, I've managed to re-create the outlook web client (in a way) but with a button to save the selected email to a sharepoint list (whoohoo) but I can't seem to get email attachments to save as list attachments. I can get the email attachments to appear as defaults in the form attachment but I get the error "Field 'id' is required" and if I try to download from the form attachment box it downloads an empty file. I think I need to use the Office365Outlook.GetAttachmentsV2 function but I don't understand how. Anyone have any pointers?
Yikes. I love it but I haven’t tried it so I don’t have any ideas. 😑
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.
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?
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
Hi Shane! I know this is an older video, but I'm just now trying to attach a file from a Power App form to an email. The data source is a SharePoint list. In a New Item form, there is an attachment control. I can't make the formulas shown in this video work. How do I get it to capture the file name? In your test label, you hard-coded the filename "peninput.jpg". The files that will be attached are usually Excel files. So, how would ContentBytes be written, e.g., "filename".WHAT ? The filenames will always have spaces, so should the filename be surrounded by quotation marks?
I'm having the same issue.
Thank you! This is exactly what I needed!
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
Hi Shane, how to add my outlook signature in the email body or generic signature using image????
This video show the concept. Not exactly what you are asking but if you learn this you can do what you want to do. ua-cam.com/video/RFZfvTuDmP0/v-deo.html
Shane Young i got it.... thank you so much for the idea
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.
I have attachments coming from SP list and populating in DCV575.Attachments control. It doesn't pull the DOCX created by flow into the control even if I wait 3 minutes and have verified it is in the list item attachments and received the email from Power Automate. Any idea how I can refresh/update/reset the attachment control so I can email the attachments from the signed in user?
How are you populating the control from SharePoint?
Dude, you're my hero.
Happy to help
*you're - but I agree, thanks a lot!
Hi Shane. I got this working, but find once I am over 3MB in attachments, it stops working and i get the following error message (even though i have the max attachments size set to 10
Office365.SendEmailV2 failed: { "status": 413, "message": "Request entity is larger than limits defined by the external server.
clientRequestId: 30e33ddc-ed26-4614-97ff-5e8d0f0b646b
serviceRequestId: a6c6d02a-962d-4969-933e-3aa6f8c8d4e0", "source": "office365-cc.azconn-cc.p.azurewebsites.net" }
Any Tips?
I haven’t had that. Sorry. 😔
This works fine from within PowerApps (create) but when I run it within the Powerapps App it fails (with an error about a blob) every time I add more than 1 image and try to submit them, strange!...any help would be much appreciated
I haven’t ran into that. Maybe post a new comment with your formula and I can try to give ideas
Shane.... Dankjewel.... (Thank you in Dutch) Netherlands.... My next challenge is to get the outlook signature underneath.... Stay Safe!
Thanks and good luck 😎
Amazing as always!
Thank you! Cheers!
Hi Shane. Great video (again). 👍👍👍👍
Hey, thanks!
Hi Shane Young,
I am using the same as you mentioned. but i am getting error like ""managed blob uri not managed by current app's blog manager" Please suggest me on that
I have never seen that error. Sorry.
@@ShanesCows Thanks! I fixed that issue thanks again for amazing working.
@@hiddenfeelings3861 I've just experienced this issue! Can you help?
@@luke-ljv4854 I have created share point list collection from there I get attachment control. by this way you can avoid this issue
@@hiddenfeelings3861 This is something I have tried but failed. The frustrating thing is that it was working previously
Wondering how to do similar, but instead of sending an email, take those attachments and add them to a document library in sharepoint? (not a list item with attachments) . or as attachments on a MS Planner task?
Need Flow to move the files for you.
I've been trying to figure out the same thing...this would be huge for me. Please let me know if you were able to find a connector that would allow you to run from powerapps to a file system folder or sharepoint folder.
Thanks for sharing, you just save me a lot of time!
Glad to help. 😀
Can you make a video shows Monitor application, process or network using powershell, If fail play wave sound or popup a messege plus auto restart the application till problem resolve ? it will help client pc auto reconnect server when server got reboot.
Sorry never did that
@@ShanesCows can you make one? thanks
Hi Shane, Awesome Video and viable content which is a life saver for those who are into Powerapps.
One question from my side.. I have one requirement where we need to send a Microsoft teams invite with a file attached to it.
I have searched the solution in web but could find only one solution where we need to send 2 emails one with teams meeting invite and another with file attached.
Is there any other work around for this?...
Thanks & Regards
Nikhil Jose
Not that I know of. 😑
Perfect Video! Thank you for your help. Best regards from Hamburg (Germany).
Danke (hope I did that correctly)
Excellent Video - Easy to follow and very informative - Thank you
You Just shown me what exactly I'm looking for. Thanks mate. you r a genius. :)
No worries