How to Send SharePoint List Attachments 📎 via Email with Power Automate
Vložit
- čas přidán 31. 07. 2024
- SUBSCRIBE FOR NEW VIDEOS EVERY WEEK-ISH
👉 bit.ly/SubACreativeOpinion 👈
In this Microsoft Power Automate tutorial, I’ll cover how to create a Power Automate flow to send SharePoint list attachments in an email. This flow will check the SharePoint list to see if an item is marked as Ready to Send and has attachments. I will also cover how to combine multiple attachments to send in a single email.
IN THIS VIDEO:
✅ How to attach a single SharePoint list attachment to an email
✅ How to use the Filter Query to Filter SharePoint List Items by a Single Choice Column
✅ How to use the Filter Array action to Filter SharePoint List Items that have an Attachment
✅ How to use turn on Pagination and Set a Threshold in the Get Items action
✅ How to us the Top Count field in the Get Items action
✅ How to use the Get Attachments Action
✅ How to avoid the Apply to Each Action
✅ How to use the Get File Content Action
✅ How to Edit an Expression
✅ How to use the Compose Action
✅ How to Get Multiple SharePoint Attachments
✅ How to use the Append to Array Variable Action
---
SKIP AHEAD:
00:00 | Intro
00:34 | Prep Your SharePoint List
00:55 | Build the Flow
02:59 | Set a Top Count
03:23 | Check for Attachments
04:04 | Filter Array
5:25 | Get a Single Attachment
8:47 | Send an Email
9:36 | Editing an Expression
12:29 | Get Multiple Attachments
16:02 | Replace the Recipient
17:18 | Replace the Trigger
18:07 | For a Selected Item Trigger
---
#microsoft365 #powerautomate #powerplatform #productivityhacks #productivitytips #techtips #techtipsandtricks #microsoftpowerautomate #sharepoint #sharepointonline
Teaching you how to make your workflows SUCK LESS.
Subscribe if you want to learn how to streamline your workflow, boost your productivity, and build innovative processes for yourself and your business! I wanna help you get more time in back your day.
Join me on my journey on learning new tools, levelling up my skills and creating more time to do the things that matter. I hope that I can inspire you to do the same and share all the things you learn from me with others.
Get curious. Be creative. Do better.
---
FOLLOW ME:
/ acreativeopinion
/ acreativeopinion
/ acreativeop
Nice
Thank you for your helpfull content. Please note that for multiple attachments when append data to varAttachment you should remove the brackets from ContentBytes value which is the body of get file content, otherwise will return "blank pages" for files, eg. PDFs.
Nicely explaind! thanks for your great content.
Very helpful and simple- thank you
Very Useful, thanks a lot
Thank you for watching!
Just wondering, whether this method can be applied to Send an Email Notification (V3). Thank you
Is there a Limit to the Size of the Attachment or Attachments witch could abort the email? Sice there is a 25mB limit to the email size or does this not apply here?
Fantastic. I really like the explanation. I think towards the end even a little more explanation would have been helpful, with a bit more discussion about running it for single item, where I got a bit lost. I plan to work my way through a number of the scenarios. Presumably to be able to run both on a schedule and for a single item would require two separate flows?
Thanks for watching. If you want to trigger the flow from a selected item, then yes, you would require a separate flow.
Hope this helps!
I have a query. Like there if a form is submitted with a single/multiple attachment. This work fine
Now assume if after submitting user is editing and adding one more file, then how to attach the only last uploaded file into mail not the all files. I need to attach only the last uploaded file into mail attachment
Love your content, thank you - automate that sh!t!
Thank you for watching! Automate it all! 😂
Hi, is it possible to insert several attachments in a Word template?
How to reduce size of the picture when attach to email ?