Help understanding Create worksheet action?

(0) Share

Report

Posted on by Cooper01

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

All responses (1)

Answers (1)

Verified answer

Cooper01 664 on at

Like (0)

Report

Re: Help understanding Create worksheet action?

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