Any help would be much appreciated! Been working on this for like a week.
What is the best way to take an Excel file hosted on a Sharepoint Site -> Copy and Rename it.
Copying it is fine, but I really would love to be able to rename it and there doesn't seem to be an intuitive way to do that.
Bonus points if anyone can help me know how to run Get Rows off of the newly copied Excel file. (problem is I don't know how to get the Table linked). I need to use an output from the Outlook Form to filter the rows on the table.
hmm. not sure why you would copy a file though. can you not open an existing file, write the answers into the excel file?
You can replace the compose with a select statement, name each of the answers from the survey into the select statement.
Then write those out into the table column headers.
The easiest way to do this would be to make a template excel file with a table in it, then from your select statement take the answers and write them into that file.
Not really answering your question here, i can do all of what you are asking but the process doesnt really make sense.
Are you starting a new file each time? or updating a file (why the rename?)
Was this reply helpful?YesNo
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.
3
Share
Report
All responses (
Answers (
