0

I use Power Automate (not desktop version). My flow seems simple:

  1. Every weeks
  2. Copy file (From folder A to folder B in the same SharePoint). Replace existing file.
  3. Run a script in the file (removes duplicated emails and removes columns)

Only Copy file works. I tried to split the script in two: First script removes duplicated emails. Second script removes column. No success.

Here is the first script:

function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
// Remove duplicates from range A:AF on selectedSheet
selectedSheet.getRange("A:AF").removeDuplicates([10], false);
}

Here is the second script:

function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
// Delete range B:F on selectedSheet
selectedSheet.getRange("B:F").delete(ExcelScript.DeleteShiftDirection.left);
// Delete range G:G on selectedSheet
selectedSheet.getRange("G:G").delete(ExcelScript.DeleteShiftDirection.left);
// Delete range H:L on selectedSheet
selectedSheet.getRange("H:L").delete(ExcelScript.DeleteShiftDirection.left);
// Delete range K:Q on selectedSheet
selectedSheet.getRange("K:Q").delete(ExcelScript.DeleteShiftDirection.left);
// Delete range M:N on selectedSheet
selectedSheet.getRange("M:N").delete(ExcelScript.DeleteShiftDirection.left);
}

Have you any recommendation using Power Automate online or the desktop version?

ZygD
  • 2,577
Ryley38
  • 101

0 Answers0