Export to excel records from a gallery

[wilsoncastro]

I have this gallery with a button to export the records to excel.

This is the code in the button

In the button I call this flow

The result I get is this file

How can I improve the presentation of the file. I want it to look like this

[Anonymous_Hippo]

Hello @wilsoncastro,

There is an easier solution.

Just use the following link (Add your values as mentioned below)

Launch("https://Your Sharepoint Domain name/sites/your sharepoint site name/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={Your sharepoint list ID}&View={your sharepoint view ID}&CacheControl=1") 

In case you do not know what your sharepoint list id and view id are then check out this link

https://www.surfpointtech.com/2013/10/14/sharepoint-list-id-and-view-id-calculator/

and Bam !! simple solution

Hope it helps someone

[wilsoncastro]

@Anonymous_Hippo 

Thank you very much for your help, but how do I download only the gallery logs? Not the complete list.

[Anonymous_Hippo]

Hello @wilsoncastro ,

I would like to know more about your data source :-

1. Are you displaying a document library or a sharepoint list ?
2. Are you filtering your gallery data source ? In case you are filtering the data source then there is no easy way of doing things (Unfortunately)

Incase you are filtering the data source and you want to format the file to make it look pretty. Then i would recommend using Office script. And running the office script to add a table + do cosmetics like you want by embedding it in your old flow 

Also some heads up :-

Using office script may sound difficult since you need to know little bit of Typescript. But actually it is quite easy. Incase you are lost i recommend using the record script option to learn the basics of what you want to do.

Reference document:-

https://docs.microsoft.com/en-us/javascript/api/office-scripts/excelscript/excelscript.table?view=of...

Cheers