web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Export gallery data wi...
Power Apps
Answered

Export gallery data with columns to excel file

(0) ShareShare
ReportReport
Posted on by 480

I have a repeating table in a gallery. I need to export this data to an excel file.

cyberco01_0-1635343283720.png

Please help.

Categories:
I have the same question (0)
  • Verified answer
    RezaDorrani Profile Picture
    12,145 on at

    Hi @cyberco01 

     

    Check https://youtu.be/tQCBWMR7T64

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @cyberco01,

    Do you want to write the repeating table back to the excel table?

    Could you please share a bit more about your scenario?

     

    Actually, to export Gallery data to excel, you just need to save the gallery items into a collection and write this collection to your excel. To make this happen, you should make sure that you have some existing columns to store the column values from the Gallery.

     

    Add a save button and set the OnSelect property as below:

    ForAll(
     Gallery1.AllItems,
     Patch(
     'ExcelTable',
     Defaults('ExcelTable'),
     {
     Column1: GalleryTitle1.Text,
     Column2: GallerySubtitle1.Text,
      Column3: GalleryBody1.Text,
     ... 
     }
     )
    )

     

    Of course you could check the video from @RezaDorrani to create a CSV table.

    Hope it could help you at some degree.

  • cyberco01 Profile Picture
    480 on at

    I will surely check if this is working and respond back to you here.

  • jleampark Profile Picture
    25 on at

    Reza, that is a great and interesting video.  

     

    I ran into a problem with the JSON on the Export to Excel button.  I got an error: JSON cannot serialize tables/objects with a nested property (Attachments).

     

    What do I do if my table has an attachments column?

     

    Thanks.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 505

#2
WarrenBelz Profile Picture

WarrenBelz 502 Most Valuable Professional

#3
Haque Profile Picture

Haque 324

Last 30 days Overall leaderboard