I have a repeating table in a gallery. I need to export this data to an excel file.
Please help.
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.
I will surely check if this is working and respond back to you here.
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.
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
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473