How to save emails with ALL attachments into a SharePoint List using power automate (flow)

How to save emails with ALL attachments into a SharePoint List.
In this video you can learn how to create a flow to fetch all the outlook emails along with email and metadata like subject, body, sender email, mail received date etc. into a SharePoint list.
A great use case for this flow is when you've a group email (or a distribution list) where all the internal / external parties would send email, and you don't want the information to get lost in some inbox where lots of emails would come through and make it look messy.
once you start capturing the information into a SharePoint list then we have endless automation possibilities, we can run some business process workflows if the mail is from some specific customer / user, we can get some alerts or can use that information as a trigger point for various reasons. This approach can also be used as a Knowledge management system.

Пікірлер: 24

  • @MitchTorres
    @MitchTorres2 жыл бұрын

    This is very nice! :) keep it coming

  • @rogermount5798
    @rogermount5798 Жыл бұрын

    Very helpful! Thanks a lot

  • @renzovelezthe2
    @renzovelezthe211 ай бұрын

    Thank you very straight forward

  • @cloudbaud7794
    @cloudbaud77947 сағат бұрын

    Emails have responses in threads, and attachments can be in any of these responses

  • @williannagarces7509
    @williannagarces75097 ай бұрын

    Great. But how can I see and download the attachment? I can not get them

  • @gangisettysunil
    @gangisettysunil2 ай бұрын

    Very helpful, thank you. But, how to save new files/attachments in same list item.

  • @pjosifovic
    @pjosifovic Жыл бұрын

    got so far but now how to you open these attachments? attachments are saved but 'failed to load' the content. any solutions?

  • @laxmikantbhukmaria9215
    @laxmikantbhukmaria92152 жыл бұрын

    Hi!! Thanks a lot for wonderful guide. Implemented this successfully. However, if mail has three attachment, it list three items in sharepoint list. Kindly advice

  • @rsb8653
    @rsb8653 Жыл бұрын

    Thanks. Do you know how I can run a flow across existing emails rather than new ones coming in . I want to do a clear up of some old email attachments but I can't get it to run across existing emails

  • @jodeeeh
    @jodeeeh2 жыл бұрын

    Thanks for this! Just want to ask, is it possible to save the files in a subfolder inside the root location (list name requirement)? Thanks!

  • @spanishin5min967

    @spanishin5min967

    7 ай бұрын

    Yes, you can

  • @miguelhuaman31
    @miguelhuaman312 жыл бұрын

    Nice video, I have a problem when I try to send attachments of diferents types. For example, an excel and one txt, don't save their attachments in the sharepoint. Could you help me? Thanks

  • @saschaleonmucenieks
    @saschaleonmucenieks Жыл бұрын

    Hello, thank you for the Video! I did exactly what you did and its supposed to work, but there is always a single encrypted attachment in the .p7m format added. Do you have an Idea why it is like that and what I could do against it.

  • @Hannah-qf4mi
    @Hannah-qf4mi2 жыл бұрын

    How do you get the emails to be added to a lists that isn't published on a SharePoint site? E.g. just a template being used in Microsoft lists?

  • @BrianHalcrow
    @BrianHalcrow2 жыл бұрын

    Hi, nice video. I am trying to do something similar but using Document Library instead of List. I have a flow to save each attachment individually but having trouble getting the email sender populated in the library against each attachment. I can't figure out after watching hours of you tube videos if this is possible? any info much appreciated!

  • @sharepointist

    @sharepointist

    2 жыл бұрын

    its not readily available however you can create another flow to retrieve the items from a list and put that into a doc lib, hope that helps?

  • @TheIndestructibl3
    @TheIndestructibl32 жыл бұрын

    Hey, thanks the vid! Can you help me awith a problem? I would like to attach every email with the same subject to the same list item, in this way it will update the content. Im not really found solution for that. (Im newbie in automate) Thanks if you have some idea. :)

  • @tigerlilymh
    @tigerlilymh Жыл бұрын

    Thanks. I have got a flow that takes an email attachment from Outlook to the Sharepoint intranet. I have got the attachment part working, but I can't add our metadata. I tried using 'update file properties'; however, I keep getting an error on the ID, so I must be missing a step. Can you help?

  • @amberschiffer3844
    @amberschiffer3844 Жыл бұрын

    I'm having this problem. The flow works and I get an attachment link in my List. But the links show nothing.

  • @vedbulland5033
    @vedbulland5033 Жыл бұрын

    I am getting an error, saying as Test connection failed. The tenant for tenant guide does not exist. Only work or school accounts are supported. Please guide me on this

  • @dvspriest
    @dvspriest10 ай бұрын

    I followed this flow. However, when the files are saved they get corrupted and are saved as 1 kb files. The name and extensions come properly

  • @user-ip8us2qq1o
    @user-ip8us2qq1o4 ай бұрын

    Attachment part is not working. The attachments are showing up in SharePoint list, but when you open them, it is giving errors. Advice?

  • @sebastiendebosscher
    @sebastiendebosscher2 жыл бұрын

    Hi, your example is not realistic. Real corporate e-mails almost always contain signatures with company logo (unwanted attachment) for the last and all previous e-mails in conversation. If you actually want a useful automation, you should be able to distinguish between real and unwanted attachments. How would you solve this ?

  • @xkeepersvk

    @xkeepersvk

    2 жыл бұрын

    maybe add a loop for each attachment check name *.pdf and then save