Copy Excel file in onedrive and update rows

Questions
1

Hello. I have an excel template on onedrive. I want to copy the file to a new file. That works with onedrive copy a file. Then I want to add rows to the newly created excel file. That is where the work stream fails.

  • What is the spreadsheet ID of the newly created file?
  • I want to update multiple rows. that amount of rows updated will be updated every time

Of note, this works great in Google Sheets on a Google Drive. It seems the microsoft applications are not very good.

3

Hey David,

doesn’t the copy module provide the ID as an output? And for the second one - that depends on the incoming data, usually with an iterator and adding them row by row.

6

Can you show a screenshot of the module configuration and what its receiving as input?

8

Welcome to the Make community!

I noticed your posts above have been deleted. Is your question resolved yet?

9

Hi. Thanks for checking in. I did not have success. I was able to add one row into Excel, but I need to add multiple rows. The number of rows I need to add is going to change with each run. I do not know what to do.

10

Hey @dg2 , Seems like you found a solution finding out the Spreadsheet ID, that’s already nice. Can you post a scenario screenshot and a screenshot of the module you’re using for ‘Add rows’ with variables ?