SharePoint List Item Multiple Attachment in Email Notification using Power Automate
HTML-код
- Опубликовано: 14 май 2024
- This video is about how to send SharePoint List Item Multiple Attachment in Email Notification using Power Automate. if you include multiple attachment it will send one single email with list item attachment. watch full video to learn in detail.
ERRORS!!! - if you're getting errors pay attention at the 6 minute mark! Thank you so much. All the other videos go through a similar example but you're the only one that talks about the potential error. THANK YOU!!!! I really appreciate your video.
Thank you man! As mentioned by others in the comment section, really like your clear no-nonsense explanation!
Thank you!!! I was struggling with the same error for a long time. Many many thanks :)
This is a great, and much needed, video. Appreciate your work!!
Thanks, it helped to solve the email error message with my flow...
Thank you so much! I have been trying to attach files to an email for two days. I have seen many tutorials, but yours is the one that makes sense and works. Thank you again, I appreciate you sharing your knowledge and wisdom!
Glad it helped you.
This channel is gold!
If these tutorials are usefull to you, please let run the adds at the end as small thank you.😀
Thanks for that!
You saved me!! It took me 5 hours to find solutions this morning. Try every word including Content, ContentBytes, content-type, with/without double quote, and so on, still can't get mail with attachments, until this video! Thank you!
Glad it helped!
Thanks for this example. I need to attach multiple files to an approval triggered manually on a file in the document library. The attachments are selected at run time and can have any file extension. I am using the "Add input -> File" option to select files at run time. Thank you.
Thank you so much! Struggled with it for days and finally got it thanks to you :)
Glad it helped!
Great video. Thank you so much.
Brilliant! Thank you so much for this.
Thank you so much once again for another precious help!
You are so welcome!
This is great! As all of your videos, the content is clear, concise, and well-crafted. Thanks.
One little hiccup for future consideration. This all works perfectly unless the attachment added is a text file (.txt). In that instance, there is no '$content' for the array to append and the flow fails. I suspect it may not just be text files, but rather any file that doesn't get an 'application-type' line, which then generates the $content line also.
In any event, excellent video! Keep up the great work.
Thanks Much!
@@LernenTech would that be why I keep getting this error? InvalidTemplate. Unable to process template language expressions in action 'Append_Attachment' inputs at line '1' and column '25293': 'The template language expression 'body('Get_attachment_content').$content' cannot be evaluated because property '$content' cannot be selected. Array elements can only be selected using an integer index. Please see aka.ms/logicexpressions for usage details.'.
Is there a workaround?
@@mikefreeland6995 By any chance did you find out a workaround for this error message? Thanks.
did anyone find any workaround for this?
Many Thanks for this video so help much. :) More Power :)
thank you so much this was driving me mad! works great! subbed
Thanks for the sub!
Thank you so much for sharing the fix for the known issue. I have gone through many videos and could not understand why mine wasn't working. Thank you
glad it helped you :)
I've been searching endlessly for simple explanations of sending emails with multiple attachments but I've always gotten stuck with the Apply to Each error message and when u debugged that issue with a function, I literally almost cried. Thank you so much for this VIDEO!!!
Glad it helped you!
Thank you so much for the Tutorial, pls pls make a video on getting attachments only which are added during modification of an item. Thanks in advance.
Sure I will
Great suggestion! I'm interested too. :D
Thanks for example
Thanks for the video. Is it attachment linked to Sharepoint? sometimes the approval need to update the document for instance with his signature in the document
Thank you SO much! Subscribing now!
Thanks for subbing!
Wonderful, Thanks a lot !!!
Glad you liked it!
thank you for the video it worked perfectly :)
Glad it helped
I am looking to add one drive specific attachments using file name in excel table and send email. Could u please assist on this flow.
Great video❤
BY THE WAY, Is it possible to automatically send an attachment based on users selection from a dropdown option in a sharepoint list?
Thank you this was a great help. If I also want to add another attachment that I have created in the flow, as well as the attachments from the sharepoint list, is there a way to do so?
For further questions and queries mail us to lernentech@gmail.com or drop a message to our facebook page - facebook.com/Lernentech/
Hi, how about image? Can we send 2 png file through email using power automate?
I used your steps, and I uploaded 3 images in List Item, the flow ran successfully but I get the images but they cant be opened and the size is small too.
any help?
Great video. Can you make a video explaining how to create a flow using Power Automate that sends an Outlook 365 email with multiple attachments when multiple files are submitted on MS Forms please?
Sure
How to attached in same email the converted pdf file of sharepoint list together with sharepoint list attachment?
Hello! Great Video! Congratulations! Can i ask you something please? How you can change the rules so to run in an existing entry of a list? I mean, i create a list entry and i want to update this line with a file after couple of days. Can this work?
For further queries do WhatsApp message on --> +91 9557196693 or mail us to
Hi Thank you above video. In my flow there 2 Array, I want to send in one email with attachment of 2 array,
How can I attach 2 array in send email action?
why you need to create two array?
Actually I created a flow to create pdf and send an email. Now I added this attachment array also. so In send email action it is not sending an email both (The created PDF file and Attachment array). Could you please advise me on what to do to get both The created PDF file and Attachment array in one email.
Hy @@punitharajan.
Could you do it?
I have this same problem...
Preferably using power automate email has to go to each supervisor based on their list items only.
Thank you very much for the step wise explanation. IT was very easy to follow. I've followed your steps but end up getting multiple emails? If i have 4 attachments, i get 1st an email with 1 attachment, then another email with 2, followed by a 3rd email with 3 attachments and then a 4th email with 4. Do you know what could have gone wrong? Thank you
please follow step properly everything explained in detailed with result.
Your e-mail step is likely inside the Apply to Each loop. Delete that E-mail step and “collapse” the Apply to Each loop. Then add the e-mail step under that with +New Step button.
@@sdfromsd8175 Thank you sooooooooooooooooooo Much for this suggestion, it worked & eased my all stress. Greetings!
Thanks for the video, I would say the first step quite succeed which I am able to receive the multiple attachment with one email.
But when I open the attachment, it seems like the attachment corrupted and unable to open. Even pdf and xls also same
May I know what is the main issues?
Hey Lernen Tech, faced the same issue. Do you know how to solve it? Thanks!
Hi, Thank you was great explanation everything is working except that i'm receiving multiple email as i add the attachments (so i attache 4 attachment i receive 4 emails any idea, one attachment in the first email two in the second and so on) Thank you.
you might be doing something or is there multiple flows running for same list check that.
Your e-mail step is likely inside the Apply to Each loop. Delete that E-mail step and “collapse” the Apply to Each loop. Then add the e-mail step under that with +New Step button.
@@sdfromsd8175 i have one more issue, Where the email attachment is not opening. Any idea how it can be resolved?
Thanks this was helpful, but now i have to add the attachment in approval flow. I can not use ContentBytes and i tried this {
"name": @{items('Apply_to_each')?['DisplayName']},
"content": @{body('Get_attachment_content')?['$content']}
}
But I can not open the attached files. Please can you help me ....
Yes I have same problem
Can you do a video that shows how to add multiple documents from a library that is connected to a list via lookups... Or do you know where I can get information to help me do this?
will try
Hi , My flow run fail the reason is ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Update_item')' is of type 'Object'. The result must be a valid array.
On the step Append to array variable and fill up body('Get_attachment_content').$centent from my side it is not show $centent and I fill up by myself.
Could you please kindly advise ?
lernentech@gmail.com for additional query
@@LernenTech I had the same problem.
Hi, rather than sending email, can i start approval process after multiple attachments??
When i am trying to do this i am getting an error "Invalid Request Content" - Pls help!!
This is a very easy to follow video!! Thank you so much!! :)
tell what exactly you want to achieve?
For any additional query and concern message us on our fb page - facebook.com/Lernentech/ or drop a message at lernentech@gmail.com
@@LernenTech Hii, i want to send multiple attachment for approval - my trigger is when an item is added to the share-point list.
I followed your steps to create multiple attachment array (which works fabulously :D) and then, rather than using a send email option, i used start and wait for approval step.
I am not able to achieve my expected outcome (send approval email with multiple attachments) by doing so.
i tried as you said -- "ContentBytes" : body('Get_attachment_content').$content, when i do that i cannot open the attached file. used send email, not approval.
I get the following error when trying to append the attachment content--- InvalidTemplate. Unable to process template language expressions in action 'Append_Attachment' inputs at line '1' and column '25293': 'The template language expression 'body('Get_attachment_content').$content' cannot be evaluated because property '$content' cannot be selected. Array elements can only be selected using an integer index. Please see aka.ms/logicexpressions for usage details.'.
@@mikefreeland6995 Hi, did you find a solution to this? I am having the same problem.
@@minurapunchihewa4592 How about you? did you find a solution for the error? Thanks.
Great work. Working for send mail (V2) but not for Send mail (V4)
I have tried same in azure logic app, getting multiple blob file content and append to array varible and attach to email.
I am able to send multiple attachments from Send an email (V2)
But not working for send mail (V4)
Can you please check and help me here.
Let me check
@@LernenTech I have achieved it by defining 3 fields( Content, Contenttype,name) in an array Object
Hi can you share how to send SharePoint list items passing due dates to respective supervisors. Example 5 list items for supervisor 1 are due and 4 list items for supervisor 2 and like wise 3 items for supervisor 3 but no items for supervisor 5 to 10. So email has to go to supervisor with their list items only.
For further questions and queries mail us to lernentech@gmail.com or drop a message to our Facebook page - facebook.com/Lernentech/ or do a Whatsapp message on - +91 9557196693
hi how about if an item is modified, will it be the same??
yes run your flow on update item.
So I feel like I've checked everything meticulously but cannot get the attachments to even show up on the email. The flow runs successfully, the email gets sent, but the attachments aren't there. Any ideas?
or further queries do Whatsapp message on --> +91 9557196693
I am following the same steps with Onedrive/Google Drive, but once I set up the append variable that the array doesn't appear under the attachment, can you provide the solution?
or further queries do Whatsapp message on --> +91 9557196693
I am having an issue with this that it is now triggering one email for every single attachment, meaning that if i have three attachments i get three emails.
Somebody told me to check that I have not placed send email action under Apply to each block.
Where did I have to change it?
please follow step properly everything explained in detailed with result.
Delete that E-mail step and “collapse” the Apply to Each loop. Then add the e-mail step under that with +New Step button.
For .pdf files, this is not working.
I am able to send all attachments in one email however , the files dont open in the email , shows corrupted as someone found the solution .
Will look for this.
Thank you so much, this was amazing. However it's giving me this error:
Parameter 'Attachment Content' cannot be null or empty.
clientRequestId: 08338920-1888-4adc-beb8-924ca3acbe83
Nevermind, had made a typo in the array
You're the man!!
glad it helped!
For me the flow works and I get the email with attachments. But when I try to open the attachments I get the following error message (these are for word.docx file attachments):
"Word found unreadable content in "test.docx". Do you want to recover the contents of this document? if you trust the source of this document, click yes."