I am investigating the most appropriate way to create reports from my canvas app. Any help would be greatly appreciated with the following:
Requirement -
A PDF report created by the click of a button in the canvas app, this will pull data from two filtered galleries on the screen
The PDF needs to have 2 tables (One for each gallery) and will require pagination as the second gallery has many rows.
Possible Options -
Power BI Report Builder - This seems like the obvious choice however I am unsure how I would setup the filtering from the button and linking with Power BI?
Populate a Word Document - I do not have access to premium connectors so unsure if this is achievable any other way?
Export CSV from Power Apps - Exporting into a CSV is relatively straightforward, however I need pagination a formatted tables in the final report. Would it be possible to create a flow to Export to CSV and then Import CSV to a Word Document table?
As always open to different options/approach's
Thanks!
