I have seen this video and it looks great. Power Apps Export to Excel Component - Power Platform Community (microsoft.com)
My solution would require the exported excel to have the dataset in the gallery be divided by a certain field and sorted into tabs by that field, and am wondering if that's possible using the ExportToExcel PCF or if I would need to use Power Automate?
So in this example dataset:
Name Item Ordered Number Ordered
Customer 1 Apples 1
Customer 2 Bananas 2
Customer 3 Oranges 5
Customer 4 Apples 4
The tabs would be Apples, Oranges, and Bananas and the Apples tab would have both Customer 1 and Customer 4's information on it, the Oranges tab would have Customer 3's information, and the Bananas tab would have Customer 2's information.
