Hi @Anonymous ,
Do you want to export data from canvas app into a Excel file or a PDF file using Export button?
If you want to export data from canvas app into a Excel file or PDF file using Export button, I afraid that there is no way to achieve your needs.
The Export control button in canvas app is used to export a collection data into a compressed file. And this compressed file could only be loaded using the Import control button.
As an alternative solution, you could consider export your data from your canvas app into a CSV file with the help of Power Automate flow. Please check and see if the following video resource could help in your scenario:
https://www.youtube.com/watch?v=QTbVMu6DIfQ
In addition, I agree with the alternative solution that you mentioned almost. You could consider patch the filtered records back to a SP List using the ForAll function and Patch function as below:
ForAll(
RenameColumns(
Filter('Main List', 'Created By'.Email = User().Email),
"Title", "Title_1",
"Column2", "Column2_1",
"Column3", "Column3_1",
...
...
),
Patch(
'Target SP List',
Defaults('Target SP List'),
{
Title: Title_1,
Column2: Column2_1,
Column3: Column3_1,
...
...
}
)
)
Please consider take a try with above solution, then check if the issue is solved.
Best regards,
