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
https://www.youtube.com/watch?v=yeAnuTB85eg&t=0s
POWER AUTOMATE HTML TABLE STYLING
https://ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/
Understand delegation in a canvas app
https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview