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.
Thank you, but I'm looking to accomplish this in PowerApps.
I believe this can be accomplished using Power Query (in Excel). PQ lets you manipulate an excel workbook to meet your needs.
WarrenBelz
146,618
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,962
Most Valuable Professional