Project Management Support

I need you to Develop an automated system that dynamically reports on each release cycle of cloud products project, and provide bi-weekly reports to stakeholders of my company. This system should streamline the current manual process of release tracking and reporting within our Cloud Products project team.
 Key Deliverables:
 Automated Data Collection: Configure a system to automatically pull release data from our existing SharePoint li. Data should include release version, status, assigned personnel, due date, and key features/bug fixes as currently my company uses Sharepoint for everything .
 Report Generation: I need you to Design or implement a template for release reports that can be automatically populated with the collected [login to view URL] report should be clear, professional, and includes a summary of progress, key milestones reached, and any risks or issues

Automation:
I was thinking maybe a bi-weekly schedule in Microsoft Power Automate to trigger the report generation. Configure automated emails to deliver the report to stakeholders every second week