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
Hello @wilsoncastro ,
I would like to know more about your data source :-
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=office-scripts
Cheers
@Anonymous_Hippo
Thank you very much for your help, but how do I download only the gallery logs? Not the complete list.
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
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Telen Wang as our August 2025 Community…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 637 Most Valuable Professional
stampcoin 570 Super User 2025 Season 2
Power Apps 1919 473
