To me it may be possible to achieve this goal with Power Automate and Outlook.
Would you please share some more information about the report email?
For example, if you can receive the emails in your mailbox in Outlook, you can follow these steps:
1.create a folder named reports and an Outlook inbox rule to put the report emails into this folder
The rule would be like:
2.create a flow in Power Automate to store the emails in Sharepoint site
I tested the steps above and it seemed to work fine for me.
(While please kindly note that since this issue is more related to Power Automate, which is not supported by Microsoft Q&A forum, we can only provide limited help)
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.