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

Question

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

Answer 1

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.

Answer 2

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.