Good afternoon,
We are working on an automation process in Microsoft 365 to manage invoice retention and email cleanup.
Our goal is to:
1. Retrieve invoice attachments from Outlook emails dating back up to 7 years.
2. Store those invoice attachments in a SharePoint site for retention purposes.
3. Run a Power Automate flow that deletes emails older than 1 year after the attachments have been successfully collected and stored.
I have created a Power Automate flow to begin this process; however, I am encountering an issue when attempting to retrieve emails across the full 7-year timeframe. The flow either fails to return all emails or appears to time out during execution.
We are looking for guidance on the best approach to:
* Extract invoice attachments from Outlook emails covering a 7-year retention period.
* Avoid timeouts or limitations when processing such a large volume of email.
* Ensure all attachments are successfully stored in SharePoint before deleting emails older than 1 year.
Could you please advise on any recommended Microsoft 365, Outlook, Exchange Online, or Power Automate best practices for handling this type of large-scale email and attachment retention process?
Thank you for your assistance.
