how to move more than 100 existing email attachments from outlook to SharePoint folder.

Ruvimbo Ndoro 0 Reputation points
2024-09-27T13:10:11.8033333+00:00

Im trying to move existing emails from outlook to sharepoint,L can do that but the problem is that the top parameter to get all existing emails with attachments only accomodates 25 and mine are more than 25

Outlook
Outlook
A family of Microsoft email and calendar products.
4,060 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,867 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,833 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Ling Zhou_MSFT 18,250 Reputation points Microsoft Vendor
    2024-09-30T05:18:46.5733333+00:00

    Hi @Ruvimbo Ndoro,

    Thank you for posting in this community.

    To move more than 100 existing email attachments from Outlook to a SharePoint folder, you can use Power Automate. I found some related articles here for your reference.

    Power Automate: Save Email Attachments To SharePoint Library

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 

    Power Automate save email attachment to SharePoint

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 

    But you can modify the first step in these articles to use Get emails (V3) to get attachments for all your existing emails.

    Note that the "Get emails (V3)" action can retrieve up to 25 emails at a time. To retrieve more than 25 emails, you can use the "Skip count" parameter to skip the first 25 emails and retrieve the next 25 emails, and so on.

    As this forum is focused on SharePoint related issues, we lack more information on Power Automate. Therefore, if you have more questions regarding this issue, you can go to this Power Apps and Power Automate in SharePoint community for more specialized help and answers.

    Please accept my sincerely apologize for any in convenience this may cause. Thank you for your kind understanding.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Ling Zhou_MSFT 18,250 Reputation points Microsoft Vendor
    2024-10-08T08:47:39.5866667+00:00

    Hi @Ruvimbo Ndoro,

    Thank you for posting in this community.

    I consulted with my colleagues in Outlook and since Power Automate can only get 25 messages at a time, we might as well use VBA to download the attachments of all the messages and then upload them into SharePoint.

    There are two methods to download attachments using VBA: https://www.extendoffice.com/documents/outlook/...

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link. 


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.