Relative Content

Tag Archive for javascripttypescriptpower-automate

Office script: How to insert into empty table of workbook2 using parsed json data from workbook1

Good day. Need help. I am using Power Automate to copy data from Table1 of Workbook1 into Table3 of Workbook2 using 2 Excel office scripts. The first office script copies the first 7 columns of Table1 of Workbook1 into json file. The 2nd office script is supposed to transfer the values from the json file into the first 7 column of 12 columns Table3. But when I tried to run the 2nd script it fails saying that the input array does not match the dimensions of the range. How to rectify it?