cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cyberco01
Post Prodigy
Post Prodigy

Export gallery data with columns to excel file

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

cyberco01_0-1635343283720.png

Please help.

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User II
Dual Super User II

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

View solution in original post

3 REPLIES 3
RezaDorrani
Dual Super User II
Dual Super User II

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

View solution in original post

v-qiaqi-msft
Community Support
Community Support

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.

Best Regards,
Qi
cyberco01
Post Prodigy
Post Prodigy

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,140)