Announcements
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,
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
@Anonymous_Hippo
Thank you very much for your help, but how do I download only the gallery logs? Not the complete list.
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
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 409 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 252 Most Valuable Professional
