You’re offline. This is a read only version of the page.
Announcements
664
I am trying to create a spreadsheet or CSV file hosted in a library based on data in a SharePoint list. I noticed the Create worksheet action which seemed like a good place to start but I am confused about the File parameter. By its name I would expect to be able to give the action a location, library, and name and be able to generate an .xlsx file. I have to choose an existing file though and I'm not sure what that's doing. I created a sample file, referenced that in the File parameter, and ran but nothing seems to happen. There is no copy of the file generated nor is there any change to the exiting file.
Can someone please explain what's supposed to happen or refer me to any documentation? Thank you
It creates a new tab in the existing spreadsheet. Guess I didn't notice the difference between worksheet and spreadsheet. It looks like the Create file action might be closer to what I'm looking for although when testing this and trying to open the spreadsheet, I get an error about the workbook possibly being corrupt and that I need to open in desktop app. Opening in desktop app doesn't work either
Share
Report
All responses (
Answers (
