Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Can you create multiple tabs using the ExportToExcel PCF?

(0) ShareShare
ReportReport
Posted on by 43

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.

 

Categories:
  • sjd889 Profile Picture
    43 on at
    Re: Can you create multiple tabs using the ExportToExcel PCF?

    Thank you, but I'm looking to accomplish this in PowerApps.

  • Bartelli Profile Picture
    75 on at
    Re: Can you create multiple tabs using the ExportToExcel PCF?

    I believe this can be accomplished using Power Query (in Excel). PQ lets you manipulate an excel workbook to meet your needs.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,618 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,962 Most Valuable Professional

Leaderboard