Skip to main content
Community site session details

Community site session details

Session Id : Fu6/G8B9W3cGwjAmmGZWKR
Power Apps - Building Power Apps
Answered

Export gallery data with columns to excel file

Like (0) ShareShare
ReportReport
Posted on 27 Oct 2021 14:03:15 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.

  • jleampark Profile Picture
    25 on 30 Aug 2023 at 18:19:58
    Re: Export gallery data with columns to excel file

    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.

  • cyberco01 Profile Picture
    480 on 28 Oct 2021 at 06:17:31
    Re: Export gallery data with columns to excel file

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

  • v-qiaqi@microsoft.com Profile Picture
    on 28 Oct 2021 at 02:55:29
    Re: Export gallery data with columns to excel file

    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.

  • Verified answer
    RezaDorrani Profile Picture
    12,141 on 27 Oct 2021 at 15:51:04
    Re: Export gallery data with columns to excel file

    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

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473