Our group is trying to automate PowerPoint generation (status report) in SharePoint which will be populated from a SharePoint Excel file (with original formatting). I've tried to automate the process by generating Microsoft Lists from Excel using Flow, which runs every day at a particular time. But then I got stuck. How do I generate the PowerPoint from Lists?
The idea is, users in the group (who use both windows and mac) would be updating only one Excel sheet in SharePoint that has multiple tabs. Then by using either Flow/Power BI/Power App a PowerPoint presentation would be automatically generated every day.
What is the best approach to achieve this? Any pointer to a concrete example would be much appreciated.