The work of performing the OData query from SharePoint List to fetch the data will be performed by flow. The data query will be passed dynamically from Power Apps as a query parameter to flow. Flow will get the Tabular data, generate HTML, send data in Email, Export data to CSV & export data to PDF. User will leverage the Power App to request dynamic export of data to Email, CSV or PDF.
Video covers the following:
Power Automate OData Filter Query flow for SharePoint list
POWER AUTOMATE HTML TABLE STYLING
Understand delegation in a canvas app